Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel, how can I store and append to a cell value as inputs ch.
I have several formulas on sheet1 of my workbook that calculate values sent
to cells on another sheet within the workbook. I need to accomplish two things. First, I need to be able to store these values on the second worksheet even if the input changes on the first sheet. I also need to be able to append the values on the second sheet if certain criteria are met on sheet1. When I change the input on sheet1, the values atomically change on sheet2. I need to control this. (Copy - Paste Special - Values is not applicable in this case) Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel, how can I store and append to a cell value as inputs ch.
Hi David. Can you not store the value you want in a variable, then put those
value anywhere you want? "David WSI" wrote: I have several formulas on sheet1 of my workbook that calculate values sent to cells on another sheet within the workbook. I need to accomplish two things. First, I need to be able to store these values on the second worksheet even if the input changes on the first sheet. I also need to be able to append the values on the second sheet if certain criteria are met on sheet1. When I change the input on sheet1, the values atomically change on sheet2. I need to control this. (Copy - Paste Special - Values is not applicable in this case) Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a pull-down list of inputs for a cell in Excel? | Excel Discussion (Misc queries) | |||
Retrieve cell value basis the inputs into a diff cell // sk. | Excel Worksheet Functions | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
How do I create an excel macro to append to a cell with existing i | Excel Discussion (Misc queries) | |||
macro to append one cell to another | Excel Programming |