Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to create a "sub worksheet"
My question is as follows,using an example: Say I have a cell showing total payments. I then want to have a feature that is similar to the comment feature where I would click on this cell and the details of all prior payments would "pop-up". In this "pop-up" I would then add another payment with details specific to that payment and the new total would then be reflected in the payment cell. Is there a way to do this without having to enter the payment details anywhere else on the worksheet or in the workbook. The only entry of the individual payment detail is on the "pop-up" information. I guess anther way to ask this is: Is the a feature similar to the Comment feature that is really a mini-worksheet? Thanks for any assitance in this. -- billandrus ------------------------------------------------------------------------ billandrus's Profile: http://www.excelforum.com/member.php...o&userid=27945 View this thread: http://www.excelforum.com/showthread...hreadid=474484 |
#2
|
|||
|
|||
There's nothing built into excel that does this kind of thing. I bet you could
spend hours creating a userform that does what you want. But maybe you could just add a hyperlink to that cell that goes to another sheet where all the details are. billandrus wrote: My question is as follows,using an example: Say I have a cell showing total payments. I then want to have a feature that is similar to the comment feature where I would click on this cell and the details of all prior payments would "pop-up". In this "pop-up" I would then add another payment with details specific to that payment and the new total would then be reflected in the payment cell. Is there a way to do this without having to enter the payment details anywhere else on the worksheet or in the workbook. The only entry of the individual payment detail is on the "pop-up" information. I guess anther way to ask this is: Is the a feature similar to the Comment feature that is really a mini-worksheet? Thanks for any assitance in this. -- billandrus ------------------------------------------------------------------------ billandrus's Profile: http://www.excelforum.com/member.php...o&userid=27945 View this thread: http://www.excelforum.com/showthread...hreadid=474484 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Can I create a new worksheet in excel with preset formating? | Excel Discussion (Misc queries) | |||
Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
How do I create a validation list on a separate worksheet? | Excel Worksheet Functions |