Thread: Move or copy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Move or copy

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