Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Making copy of sheets with links
Name:
Nina
Email (spam proof):
Email the originator of this post
Date:
Thursday, December 05, 2013
Hits:
30
Discussion (Terms and Conditions):
I have multiple workbooks that have several sheets that link to multiple sheets of a main workbook. Ex. Each salesperson uploads hours worked daily, $ amount of certain types of items sold each of these cells are linked to cells in the main store workbook. I am trying to copy the pages but the links aren't changing so I have all of the links set in the main store workbook for Jan I want to do the same for Feb. Is there a way to copy and change the sheet link all at once or will I have to go through each cell for each salesperson and link it to the store? I do this for each day of the year for 27 sales people. I have to be missing something, it cannot be this difficult! PLEASE HELP!!!

Sponsored by the best FTP application on the internet: