Multiple worksheets & duplicating formula

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

I have 35 worksheets; one w/s for each volunteer Each w/s has the exact
document to capture the number of hours a volunteers works and the type of
service they perform (ex: office work, patient care). I created a work sheet
listing the name of each vol (running vertically) and a row of cells
(horizontially) to capture the total for each month for each vol.

How do I change the formula to between w/s without having to do the = sign
for each cell from all worksheets?

I'm using Excel 2003

Thank you for saving my mind from exploding!
Jackie
 
If the structure of your sheets are same (the columns, rows may have
different size), another solution for getting a summary sheet of all vol. is
to use consolidation under data menu. Consolidate will summarize the data
from different sources to one.
 
All my worksheets; each tab having the individual name of a volunteer has the
exact same format and cell reference. I looked at the data - consolidate
option and I would greatly appreciate it if you could provide a simple sample
of how to feed all the information from the 35 worksheets to the single
worksheet that captures the total hours for each month. The INDIRECT
formula has saved me many hours...not having to enter "=" and clicking on
each worksheets specific cell I want information from. I'd love to learn of
another option.

Thank you so much for your interest and time.

Jackie
 
Back
Top