Macro Question

[Guest]

I have a workbook that contains a worksheet for each business day. Each
worksheet has the same layout. The worksheets are named July 6, July 7 etc.

I am trying to fill in a table like this (first row is the result I'm
looking for):

A B C
6-Jul 0.116796 0.071666 0.089365
7-Jul
8-Jul
9-Jul
10-Jul

where the formulae in the cells is

A....=AVERAGE('July 7'!D10428)

B....=AVERAGE('July 7'!H10:H428)

C....=AVERAGE('July 7'!I10:I428)

Is there a way to repeat the formula in the subsequent rows of the table
with the new formula using the data from the worksheet named in ColA of the
table ?

Thank you in advance.

 

[Bob Phillips]

=AVERAGE(INDIRECT("'"&A1&"'!D10428"))

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)