>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)