Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |