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