March 20, 2019
I have a master workbook that has 29 worksheets. I have created a macro that opens 29 other workbooks, copies a worksheet from each of them, and then pastes it into the master workbook with the name of worksheet that was initially in the master workbook (before pasting it deletes the equivalent worksheet from the master workbook).
My problem is that there are formulae in the master workbook linked to the worksheets I have deleted. As the ones i replaced them with have equivalent names, I hoped that the formulae would still work but they don't.
Is there a way of making a formulae linked to a worksheet name rather than a specific worksheet?
Or if not, how would I got about creating a macro that goes into each formula and links it to the new worksheet?
June 25, 2016