>>here is my scenario:
>>I have a excel file which contains 650 sheets. the first sheet is called Index and has a reference to all other sheets in col a (649 rows follow)
>>
>>all the other sheets are named by the date of the data,
>>Sheet[2].name ="032211'
>>Sheet[3].name='031811'
>>etc.
>>
>>
>>
>>in col b I would like to get a total of the sheet f2:f64000 of the sheet name found in col a
>>
>>like:
>>
>>032211 123,345.00 (total from second sheet)
>>031811 432,564.88 (total from third sheet )
>>
>>etc..
>
>That sounds like a job for Excel Automation, or an Excel macro, to insert all those formulae automatically.


It's the automation I want to check up on.
I imported all the rows into my app and Now I want to make sure I did not miss anything.