In Excel, how can I store and append to a cell value as inputs ch.

G

Guest

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!
 
G

Guest

Hi David. Can you not store the value you want in a variable, then put those
value anywhere you want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to retrieve values corresponding to the value selected in Dropdown box 4
Cell values to an array, then array transpose to another workbook 8
Excel VBA to move cells to sheet2 based on selection in sheet1 0
How to store values in excel using macro ? 4
Populating values in cells based on lookup from other cell. 4
Search the column and return a cell value 15
How to calculate % in summary sheet from cell A9 in multiple sheet 3
Copy from sheet1 and sheet2 and append to sheet3 in different format 8

Top