Thread: Macro Question
View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default Macro Question

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'!D10:D428)

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.