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.
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.