Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells with Hidden Data
Hi All
Just a query here.....is it possible to have a cell expand with more data or linked to more data that can be accessed by clicking on that Cell: e.g Cell B9 has "Total Queries" , Cell C9 gives the total time in minutes Would like to click on B9 then that gives more detail eg . Specific queries, I have about 13 other cells that will be changed daily but dont want to see them all immediatley only when clicking on the 'summary cell' B9. Calls 26 mins Letters 40 mins Emails 90 mins etc. I know Access would be good but really need this in excel functionality... Any ideas would be great thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells with Hidden Data
Maybe you could use a comment.
Or maybe you could use a hyperlink to a different sheet that contains this other info. mellowe wrote: Hi All Just a query here.....is it possible to have a cell expand with more data or linked to more data that can be accessed by clicking on that Cell: e.g Cell B9 has "Total Queries" , Cell C9 gives the total time in minutes Would like to click on B9 then that gives more detail eg . Specific queries, I have about 13 other cells that will be changed daily but dont want to see them all immediatley only when clicking on the 'summary cell' B9. Calls 26 mins Letters 40 mins Emails 90 mins etc. I know Access would be good but really need this in excel functionality... Any ideas would be great thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells with Hidden Data
Thanks for the reply Dave - actually found a solution by using the
Group functionality in the Data Menu - means I can hide and expand the data easily by specifying the rows! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I paste data skipping the hidden cells ? | Excel Discussion (Misc queries) | |||
How do I exlude hidden cells when copying data | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |