J
jmanders2004
Hi, I have a question about using Excel to add data from multiple
worksheets. I am a salesman and have a daily report I have to email in
(using an Excel worksheet) each night. The form is set up to hold one
pay period of data (or two consecutive weeks, Mon. through Sat.) The
form is set up to add the daily numbers for a given set of categories
on a weekly basis. There is a place for the sum of each category for
week 1 of the pay period and a place for the sum of each category for
week 2 of the pay period. Then there is a place where the totals for
both weeks are added together for the grand totals.
What I would like to be able to do is to create a form in which I
could merge the numbers from all of these bi-weekly reports together
to keep track of my overall progress. And I would prefer to use the
exact same format that I use for the bi-weekly reports. How can I do
that? Or is it even possible? Thanks for any help forthcoming.
M. Anders
Salisbury, NC
worksheets. I am a salesman and have a daily report I have to email in
(using an Excel worksheet) each night. The form is set up to hold one
pay period of data (or two consecutive weeks, Mon. through Sat.) The
form is set up to add the daily numbers for a given set of categories
on a weekly basis. There is a place for the sum of each category for
week 1 of the pay period and a place for the sum of each category for
week 2 of the pay period. Then there is a place where the totals for
both weeks are added together for the grand totals.
What I would like to be able to do is to create a form in which I
could merge the numbers from all of these bi-weekly reports together
to keep track of my overall progress. And I would prefer to use the
exact same format that I use for the bi-weekly reports. How can I do
that? Or is it even possible? Thanks for any help forthcoming.
M. Anders
Salisbury, NC