Find and Several Sheets

[Guest]

I have a master data sheet set up in the format below... Where DN, SA, and
SC are obviously column headings, but also represent sheets in my workbook.
I have used the "subtotals" function in each sheet to compile a total amount
(in column 7 of those sheets) for each day. For example, in the DN sheet
there maybe 10 entries on 1/3/2005. Using the subtotal function I now have a
1/3/2005 total. I would like to take that "total" value and put/paste it
into the "master data sheet" under the DN and 1/3/2005 intersection. Is it
possible to have a macro do this for either a selected date range or a date
range entered into two cells?

DN SA SC
1/3/2005
1/4/2005
1/5/2005
1/6/2005
1/7/2005
1/10/2005
1/11/2005

 

[bhofsetz]

John,
Is the total for each day always in colulmn 7 of the respective
sheet?

You could probably use a VLOOKUP on your master sheet to pull in the
respective total data from the individual sheets.

In each of the cells below your column heading copy this formula and
then copy down.

below DN place

=VLOOKUP(A2,DN!A2:G10,7)

below SA place

=VLOOKUP(A2,SA!A2:G10,7)

below SC place

=VLOOKUP(A2,SC!A2:G10,7)

The added benefit of using this formula is that if your totals on the
other sheets change then the master sheet will automatically be
updated.

HTH