trying to link but not lose info

B

Bryan J Bloom

A2 B2 C2 D2 E2 F2
123 1/01/01 1/02/01 1/03/05 1/04/05 1

a2= unit number
b2-e2= dates the unit moved
f2= what cycle its on

So im trying to get the sheet to link to another worksheet, but not lose the
info or the link when I start the next cycle.
eg; the above example is now done with cycle 1 and is linked to another
sheet, cycle 2 is about to start, so Im going to erase the dates. Is there
anyway of Excel saving cycle 1's information in the linked worksheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top