How do I Copy data dynamically to a calculated cell

  • Thread starter Thread starter Alex Smariga
  • Start date Start date
A

Alex Smariga

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
 
The easiest way to do this is (assuming cell to copy is
A1) in cell B1 enter =A1

Hope this helps

Paul Falla
 

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

A data validation question 1
VBA - retrieve data on last create named range from previous inserted named range 0
Remove specific cells in a column. 2
Excel Help to copy information from one row at a time to another sheet 1
VBA to run all variable combinations in a calculation model and store result 6
How I can set dynamic pivot table ONLY when I have enough data point 1
Conditional Formatting 1
Dynamic Cell References in Excel 2

Back
Top