Hi. I have a Workbook named Weekly Commercial Sales Report where I have six
salespeople enter their weekly sales, quotes, sales lost and cold calling
activity. Each salesperson has their own page and using an "Update" buttonand
VBA code, this information is then extracted to 2 other pages named "Sales
Won Lost" and "Quotes Activity". After this is done, the whole book is saved
under a new name (date) and the information in the original report is
deleted, ready for next week.

Prior to deleting the information, I would like to send it to another
workbook containing seperate worksheets for each salesperson that adds the
current information to the previous weeks totals so that I can track the
total sales and activity andreview on a weekly/monthly basis. Is there an
easy way to do this using VBA and, if so, how would I do it?
I will send the exisiting workbook, if needed.
Thankyou in advance