Hello,
I have a file (let's call it file A) that is linked to another file (file B) that gets updated monthly. I would like to link file A to file B and just edit links > change source every month, but the problem is the tabs I am linking to contain the current month in the tab name.
Is it possible to create a macro that looks in a table in file A (sheet1'!A1:B3 - column A is the tab names in file A and column B is the new tab names in file B) and does a find replace in each of the three tabs in file A for the new tab names in file B according to what's in the table? IS this the best way to handle this issue? Thank you in advance for your help, George
I have a file (let's call it file A) that is linked to another file (file B) that gets updated monthly. I would like to link file A to file B and just edit links > change source every month, but the problem is the tabs I am linking to contain the current month in the tab name.
Is it possible to create a macro that looks in a table in file A (sheet1'!A1:B3 - column A is the tab names in file A and column B is the new tab names in file B) and does a find replace in each of the three tabs in file A for the new tab names in file B according to what's in the table? IS this the best way to handle this issue? Thank you in advance for your help, George