Hello all,
Just wondering if it is possible to access subtotals from a marco? If
so I am just looking for the general syntax. I do quite a few extracts
where the data needs to be subtotaled and then !some! of the subtotals
need to be used in another sheet (or book).This would be the formula
entered in the cell if done manually "='Buyouts 09.05'!F3911" but that
makes reference to a specific cell which will not be the same the next
time.Sample data would be something like:
A |B |C
A1 1 100
A1 1 100
A1 1 TOTAL 200
A1 2 5
A1 2 6
A1 2 TOTAL 11
A1 TOTAL 211

Does anyone know of a way to accomplish this? Is it even possible? Terry