Moving a formula with the contents of a cell

[rlouise]

Hey there,

Im wondering: When I write a formula that refers to a cell, is is possible to add something to the formula so that when I rearrange contents, it moves with the original data (rather than staying with the cell that was initially identified).

Cheers!

Rachel

[LokeshKumar]

Hi,
You can simply select the formula and content same time and drag it to anywhere you want.
It is also possible by VBA but I am not sure if your problem is already solved or not?

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.