Copying formulas between workbooks

[jappi]

Can anyone tell me how to do this ?

I have one file with multiple tabs for financial transactions by each day of the week. In this workbook is also a summary tab which is referencing specific values (cells) in the other tabs.

I have a bunch of other workbooks that have all the daily transactions in exactly the same format as the other workbook but the other files don't have the summary tab.

So...I want to add the summary tab to the other workbooks and then just copy and paste all the summary references over. When I do this now it brings over the formulas but they all reference the tabs in the other file. Want to reference within files not between files.....hope that makes sense.

Thanks.

 

[jdavis9]

Instead of copying the sheet by selecting all and doing cntrl c, right click the tab select move or copy, select the book to move it to, select create copy and ok. I just tried it, and the references did not stay linked to the source workbook it came from.....

 

[jappi]

Thanks for the prompt response. I have followed your instructions specifically but I'm sorry to say the references to the other workbook remain. Plan B ?

 

[jappi]

Just to elaborate if its any use, the cells I am copying from just have an = reference to the other cell...nothing too complex

 

[NBVC]

perhaps after you have followed jdavis9's instructions you can perform a Find & Replace (from the Edit menu) and just replace the workbook name with nothing (i.e. leave the Replace field blank).

 

[jdavis9]

That is the only thing I can find to make work if it is keeping the link.

Do a find replace [otherfile.xls] with for the sheet you transfered.

=[Book1.xls]s2!A1 becomes =s2!a1

 

[jappi]

Thanks guys - that seems to be one way of cleaning it up. I'll take it ! Thanks again