Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
billandrus
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Can I create a new worksheet in excel with preset formating? pertimesco Excel Discussion (Misc queries) 2 March 1st 05 07:32 PM
Create a "recap" worksheet that includes all info from all worksh. tdglaw Excel Worksheet Functions 1 February 2nd 05 04:48 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
How do I create a validation list on a separate worksheet? Ronaldo Excel Worksheet Functions 2 November 26th 04 10:23 PM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"