Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Pop up box with a formula

I have a worksheet that links to another worksheet within the same
workbook. Each cell with a data in it on the first worksheet is showing
a percentage. This percentage comes from the sum of two cells on the
other worksheet divided by another number.

My question: is there a way to have a pop up box of some sort show the
sum of the two cells that is generating the percentage so that those
using the spreadsheet would know what number was generating the
percentage shown.

Thank you for any assistance.

  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Pop up box with a formula

1-The cell on Sheet1 can be actually the formula retrieving the data from
Sheet2.....this formula will show up in the formula box when the cell is
selected.
2-You could hand-type the information you wnat in a CommentBox attached to
each cell.

hth
Vaya con Dios,
chuck, CABGx3



"japc90" wrote:

I have a worksheet that links to another worksheet within the same
workbook. Each cell with a data in it on the first worksheet is showing
a percentage. This percentage comes from the sum of two cells on the
other worksheet divided by another number.

My question: is there a way to have a pop up box of some sort show the
sum of the two cells that is generating the percentage so that those
using the spreadsheet would know what number was generating the
percentage shown.

Thank you for any assistance.


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
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 01:38 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"