If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cross program data sharing | m_jurrens | Powerpoint | 1 | December 16th, 2005 04:36 PM |
cross office program data sharing | m_jurrens | General Discussion | 0 | December 16th, 2005 03:36 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
pasting data over hidden cells | KyWilde | Worksheet Functions | 3 | May 23rd, 2005 01:35 PM |