Need links to copy over with new spreadsheet

Closed
Johann - Sep 20, 2011 at 02:56 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 22, 2011 at 09:07 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 22, 2011 at 09:07 AM
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
0