Thank you for the reply.
Attached you can find a "Sample.xlsx" file which should almost be self explanatory.
What I am trying to do is the following:
1) On sheet "Summary 2010 (new)" i would like to click on cell M10 and see a pop-up with the summary of what charges are adding up to that value
2) I would like to be able to click on any cell in that table and get the same effect.
In the case of M10 I would like to see a pop-up box next (or close to the cell) -- i.e. relative to the cell with the following information:John - 15 EUR
- 1 Oct - Taxi with friend - 15 EUR
Peter - 42 EUR
- 1 Oct - Returning from Lunch - 10 EUR
- 1 Oct - Taxi for a friend - 15 EUR
- 5 Oct - Taxi going to lunch - 10 EUR
- 5 Oct - Taxi coming from lunch - 7 EUR
Total - 57 EUR
If I clicked on a different cell I would like to get the summary of that cell instead.
Please ask if it is not clear, like that I can try to explain better.
The reason I am not using Pivot Tables is because the attached file is a simplification of what I am doing and the matrix formulas that I am using are really not a problem for me. I am just trying to get a pop-up box with this information next to the relevant cell.
Thank you for your help!!
Bookmarks