Excel open a small table from a cell

[Felicity]

I'm not quite sure how to describe this. My clients is in a restaurant
business. He tracks the hours worked/costs etc using Excel. When he comes to
a summary of the hours for lunch & dinner, he wants to click on say, the
total which will open a temporary small dynamic spreadsheet right next to the
cell showing him what these hours are made up of (ie John $10.50/hr 5 hours
Mon/Wed/Thurs). I don't really know where to sart looking.

 

[Bernie Deitrick]

Felicity,

The best way to attain something like this is to use a pivot table to crunch your numbers. When a
number in a pivot table is double-clicked, a new worksheet is produced that shows the numbers that
went into that value. That sheet can then be used or deleted as needed.

HTH,
Bernie
MS Excel MVP