maintaing link even if the worksheet is copy to new workshee

[wavemehello]

Hi there,
sheet 1 (january) has some data, I used paste link to paste the data of sheet 1 in new worksheet (xyz). but when sheet 1(january) is copied to new sheet 2(february) and changes made in sheet2(february) it does not reflect to xyz. How to maintain the link even if the original worksheet is copied to new worksheet?

lastly, uhm, do u understand what I mean?

regards
Aj

 

[Andrew Poulsom]

If you move (rather than copy) the sheet while xyz is open, the link will be adjusted.

 

[GlennUK]

Think about it ... you are asking Excel to maintain the link when you are copying, but in theory you could copy your stuff many many times ... what logic would you expect this maintenance to follow? BUT, how about if you MOVED your stuff ... then links would be maintained.

 

[wavemehello]

If I move, I cant trace changes of each month

The reason that I copy the worksheet to new worksheet at the end of each month is that I can trace what changes I have made for each month, if I move the worksheet, I cant trace the changes. This way at the end of the year, there will be 12 worksheet for each month all updated month by month.

Is there a way as I want it to be? It would be great help!

AJ

 

[GlennUK]

Move it to the new worksheet, then copy it back to it's original place!

 

[wavemehello]

Let me explain

My HR officer has a worksheet with 300 staff information as name, dob, empno, etc. At the end of every month he copies the sheet and renames it to new month and continues work so that he can trace changes made in each month.

My training manager wants to use partial information of the staff for his training tracking database. I tried paste link the necesary columns in a new worksheet it works, but when the HR officer copies his worksheet to new worksheet, the training managers link is gone! Is there a way to continue the link for my training manager such that even if the HR officer copies the worksheet to new sheet?

 

[wavemehello]

thankx

Oh thank you, thats simple! I will try and check if it works.

 

[Andrew Poulsom]

Ask your HR Officer to have the training manager's workbook open when he moves the worksheet (or saves it with a different name).

 

[wavemehello]

asking does not seem smart way practically!

It seems there is no other best way to do it automatically, can some coding help? otherwise its ok, I better drop the whole idea.