Software

Ask something
Discussion Locked

Excel multiple workbooks nightmare

0 helpful
3 replies

by debbymcc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have 15 different workbooks from 15 different sources. The company I have worked for has decided that they want to add columns & formulas to each of the 15 workbooks to begin tracking data. (There is 1 page for each day of the month inside thisworksheet, and they reference the previous days, for example in the mtd column the formula is: 'F (2)'!J7+'F (3)'!I7 (to reference the 2nd day of the month plus the third, for month to date figures)) also there is a budget line that changes with each day (for example 'BUDGET (2)'!C3*3 is for the budgeted daily line to be X 3 days)I have done 1 and need to insert that into the other 15 with the formulas. I have tried selecting all sheets in both the source and destination sheets, but that references the source file, these need to be free standing workbooks. Is there anyway to copy & paste info from 1 workbook to another and have the formulas follow to the new workbook. I will go nuts if I have to do 31 pages worth of formulas for 15 different workbooks! help please

3 replies

by dklippert

Top of the head:

One klugey way I've done it in the past is to select the formulas and do edit replace. Replace "=" with "A=". Copy and paste into the remaining sheet. (You can select multiple sheets using Ctrl or Shift.
Now replace "A=" with "=".
You can copy the sheet to the other books by Right clicking the tab. Choose Move or Copy (make sure copy is checked). With the other books open you can copy the sheets to the other books.

by debbymcc

Thanks for your help, Every workbook is different, in layout and formulas, so I cant copy a page to insert it to another workbook. I just one section to be inserted to the workbook. And the formulas carry over to refernence the new workbook. Any ideas?

This discussion is closed to new replies.