Adding figures from multiple worksheets

  • Thread starter Thread starter Mark Anders
  • Start date Start date
M

Mark Anders

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
 
=SUM(Sheet1:Sheet2!H11) - this sums across two sheets and as long as all sheets are formated in exactly the same way, you could probably copy the format from one and use it as a sum sheet. If you put an extra sheet in front of them all and sum through that sheet you can add a new sheet behind it and not put the sum out of range

----- Mark Anders wrote: ----

Hi, I have a question about using Excel to add data from multipl
worksheets. I am a salesman and have a daily report I have to email i
(using an Excel worksheet) each night. The form is set up to hold one pa
period of data (or two consecutive weeks, Mon. through Sat.) Th
form is set up to add the daily numbers for a given set of categories on
weekly basis. There is a place for the sum of each category for week 1 o
the pay period and a place for the sum of each category for week 2 of th
pay period. Then there is a place where the totals for both weeks are adde
together for the grand totals

What I would like to be able to do is to create a form in which I coul
merge the numbers from all of these bi-weekly reports together to keep trac
of my overall progress. And I would prefer to use the exact same format tha
I use for the bi-weekly reports. How can I d
that? Or is it even possible? Thanks for any help forthcoming

M. Ander
Salisbury, N
 
Back
Top