Move or copy

[Richard]

I have an inventory sheet that keeps track of parts sent to assy. Which is
also linked to the schedule sheet. To restart the schedule sheet the contents
from the inventory sheet need to be deleted, but I need to keep the contents
of whats sent to assy. Is there a way to added another sheet and have the
contents sent there without linking the 2 sheets. Simply: Send the contents
to sheet 2 then delete the contents from sheet 1 and retain the contents of
sheet 2

 

[Pete_UK]

You have to consider what you want to do the second (and subsequent)
time around - send the data to another Sheet2 (delete or retain the
first Sheet2 ?), append it to the existing Sheet2 ?

You will need a macro to do what you suggest, but you will need to
define the actions more clearly.

Pete

 

[Richard]

Yes, my problem is I'm using Sheet2 for the parts sent to assy, which is
linked to sheet 1 with this formula: =IF(B3="","",MAX(B3-SUMIF('Sent to
Assembly'!A:A,A3,'Sent to Assembly'!B:B),)) which counts the parts sent to
assy and is subtracted from B2 on sheet 1 which is the initial qty meeded.
But once Scheduled parts are completed. I need to start a new schedule. I
still need a record of whats sent to assy. If I could send Column A,B,C, to
another sheet without it linking to sheet 2 when I delete sheet2, sheet 3
will remain.