Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Copy data dynamically to a calculated cell
In my worksheet, I have 3 columns of data and a table of monthly
entries. One column is a value for the table, once column is a location in the table to place a value, and the third column is the value to be copied to that location. Is there a function that would allow me to create a formula to "COPY(fromcell, tocell)". I have all the information, I just don't understand how to make such a folrmula. Do I have to create a macro? I've never done that before, and I'd prefer if it were a formula in a cell, as the data is pretty static. Alex Smariga |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Copy data dynamically to a calculated cell
The easiest way to do this is (assuming cell to copy is
A1) in cell B1 enter =A1 Hope this helps Paul Falla -----Original Message----- In my worksheet, I have 3 columns of data and a table of monthly entries. One column is a value for the table, once column is a location in the table to place a value, and the third column is the value to be copied to that location. Is there a function that would allow me to create a formula to "COPY(fromcell, tocell)". I have all the information, I just don't understand how to make such a folrmula. Do I have to create a macro? I've never done that before, and I'd prefer if it were a formula in a cell, as the data is pretty static. Alex Smariga . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation on a calculated cell | Excel Discussion (Misc queries) | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Dynamically changing a calculated field in Pivot Table | Excel Programming | |||
Enter data into a cell and dynamically update another cell | Excel Programming | |||
Enter data into a cell and dynamically update another cell | Excel Programming |