Need links to copy over with new spreadsheet [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,
I have several spreadsheets that are linked to one main spreadsheet, these spreadsheets are saved and a copy is created every month, how can I have the link to the main spreadsheet follow the new copies without manually creating another link to the new sheets?
Thanks 4 any help you can...



1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Johann,

If no one else replies with a fit solution for you, then I would advise to rearrange your data.

Since you cannot save individual spreadsheets I am assuming that by spreadsheets you mean workbooks (excel files). Combine all you workbooks into one. Make a save of the entire workbook and rename it appropiately. You (or macro) could then delete all the unnecessary sheets from your workbook if desired.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!