How to copy and paste to a referenced cell

[TDH]

How can I copy cell Sheet1!C3 and then paste it to the referenced cell that is in Shee1!D3. With a formula I can copy from a referenced cell =indirect(D3) but I need to go the other way and copy to the referenced cell.
Also can I copy the same cell and paste it to the next blank row in Sheet2!B:B
Thanks for any help

TDH

 

[bryanbayfield]

Hmmm ... a little confused here.

You talk about copying and pasting and then give an example of that using the INDIRECT function. But that function is nothing to do with copying and pasting - I'll assume that you don't want to actually copy and paste at all, but just want to set certain cell values equal to other cells values using formulae.

INDIRECT takes as it's required argument a reference to a cell. The cell referenced should itself contain a reference to a cell - it is the value of the cell contained in the second reference that is returned.

So you want a function f (cell_ref) that looks up the cell reference contained in cell_ref to get another reference, and set the cell contained in the second reference equal to a certain value? If so, what value? Certainly not that of the cell you're entering the formula equal to - you'd create a circular reference.

You can certainly copy any cell you like and paste it to the next blank cell in Column B - but how do you want to do this? Excel interface or VBA?

Can you make yourself a tad clearer please?