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

On Mar 11, 9:34*pm, Richard wrote:
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