Copy Sheet from one Workbook to Multiple Closed Workbooks
I am very new to Macros and was hoping that y'all could help me out.
I am looking to copy/move a tab called "Summary" in a file called "Base" to 303 other files that are in the same file in my directory, but all have different names.
The catch with this is that the Summary tab is formulated. It calculates the cell from data in other tabs in the same workbook. I need the macro to open the file, move/copy the Summary tab, break the link with the Base file so that it's looking at the correct data when calculating things, save the file, and repeat with the rest of the files.
I would appreciate any help you can give me!
Re: Copy Sheet from one Workbook to Multiple Closed Workbooks
And how would one know what links to break and how and where to find the correct data?
break the link with the Base file so that it's looking at the correct data when calculating things
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1