I see questions which save an entire workbook, but I need to save a
worksheet, remove to an archive existing workbook. Each work book is a job,
so this will create a history of jobs for each of our project managers.
Active jobs in one work book and completed jobs in another. Please give me
some vba guidence. Thanks
Larry