| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Values from 2 cells in another cell
Hi.
I have a calculation spreadsheet where the user inputs various values into certain cells. These values are then processed through a few calculation steps to (obviously) come up with the answer! I want to be able to show the calculation steps with the entered values next to the cell that performs the actual calculation. Can this be done? E.g. Cell A1 = Enter 1st Number; Cell A2 = 12345 Cell B1 = Enter 2nd Number; Cell B2 = 67890 Cell A30 = 12345 x 67890 =; Cell B30 = A2*B2 Is this possible? I have tried using code but cannot seem to get it to work (I get a #NAME error in Cell A30) Thanks, Steve. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying values rather than formula in cells | Excel Programming | |||
| Displaying temporary values on formula cells. Is this possible?q | Excel Discussion (Misc queries) | |||
| Displaying cell values in a Userform | Excel Discussion (Misc queries) | |||
| Shortcut key to display change the display from displaying cell values to cell formulae | Excel Programming | |||
| Displaying Formulas and Values of the Same Cells | Excel Programming | |||
Threaded Mode
