I have a finance workbook, there is a summary sheet, surprisingly called "Summary". Each Cell is a total of the the same cell for the rest of the workbooks.
For example cell A1 has a formula in it, =sum(sheet2:sheet10!A1).
What I was wondering was is if a Macro could be written so when you doubleclick on any cell, a chart or summary table appears in a user form showing the breakdown.
for example
Sheet1 - £5,000
Sheet2 - £4,000
Sheet3 - £12,000
...
..
.
Any thoughts how this could be done, if at all?
Many thanks
For example cell A1 has a formula in it, =sum(sheet2:sheet10!A1).
What I was wondering was is if a Macro could be written so when you doubleclick on any cell, a chart or summary table appears in a user form showing the breakdown.
for example
Sheet1 - £5,000
Sheet2 - £4,000
Sheet3 - £12,000
...
..
.
Any thoughts how this could be done, if at all?
Many thanks