Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel open a small table from a cell
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel open a small table from a cell
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 "Felicity" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WHEN OPEN EXCEL WORKSHEETS ALL COLUMNS COMPRESSED DOWN SMALL WHY | Excel Worksheet Functions | |||
ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
Open an Access table in Excel | Excel Discussion (Misc queries) | |||
How can I add a small .gif in an Excel cell? | Excel Discussion (Misc queries) | |||
Cell is too small? | Excel Discussion (Misc queries) |