VBA to map cells

[HeWhoDares]

Hi all,

Brand new to this board and also to VBA so please forgive any uselessness on my part. Looking forward to learning loads.

I am trying to use VBA to map cells. I'd like to click on the destination cell and then select the source cell (that contains the data) and have that data copied to the destination cell. Without going into the background, I want to avoid copy and paste and avoid using the SUM formula.

Is this possible?

Thanks,

HeWhoDares

 

[mole999]

I got this from Rick a while back to swap two values around, I'm sure someone might be able to copy from one to another > https://www.mrexcel.com/forum/excel-questions/781871-cell-transpore.html?highlight=swap

 

[HeWhoDares]

Thank you, mole999.

One important clarification that I missed. The source data could come from anywhere, often from different workbooks altogether, and so a range will not work. Effectively I want to replace typing "=" and then clicking the source cell, with VBA. If I could click the destination cell (basically adding "=" to the formula) and then select the source data cell that would solve the issue I am facing. I've searched for several hours but cannot find how this is done.

Thanks again!

 

[mole999]

I don't know of anything across books, sorry