I want to create a macro which allows me to copy the current reference location (e.g. Cell B3).

And paste into another cell with the formula (=B3) composed by the previous location copied


Thank you!