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

Should be relatively easy to do with VBA. I'll tackle this one. Send me the
workbook along with a sample of what the 'other' workbook needs to look like
(or a copy of it if you already have one) and I'll see what I can do for you.

Send to (remove spaces)
Help From @ JLatham Site .com
Remind me of your username (Skeletor) here and again explain what needs to
happen in the email.


"Skeletor" wrote:

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