PDA

View Full Version : Drill Down



IrishCharm
07-24-2008, 07:22 AM
Hi,

I was wondering if there was a macro that could drill down into cells, for example if i single left click on the cell "A3" which contains the figure 10k - the cursor will automatically go to a different tab and cell range. This new cell range will be the sub total which i have pre-set. Not sure if this can be done on a cell basis.

Any ideas?

Cheers

Sarah

Bob Phillips
07-24-2008, 09:19 AM
How will it know where to drill into?