I need to copy a cells value and location to another tab

[Dean001]

Hi,

New here and not tried anything like this on excel before,
I need to copy and paste the contents (and location) of individual cells into another sheet, there will be hundreds / thousands of these to do and each one will need to be selected manually (which doesnt have the option to automate due to the nature of the work), currently they are being done with CTRL C / CTRL V and typing the cell location in. is there a way to automate this?
Ideally I would like to double click on the cell I wish to copy, the value to be put in the other sheet, the cell location (A1, C6 etc) be in the next cell over, then the next value that is double clicked on to be in the next row down.

Hope someone can help
Thanks

 

[MEUserII]

...[...] (which doesnt have the option to automate due to the nature of the work)...[...]. ...[...]... Is there a way to automate this?

That depends on whether the "nature of the work" allows Visual Basic Application (VBA) code to be executed in your Excel application. If so, then, yes, this can be automated (with VBA code). If not, then no, it can't be automated (at least with VBA code).

 

[Dean001]

Thanks for the reply,
The cell contents are number (negative number) and would allow VBA. That part only cannot be automated as each one needs to be looked at by a technician first.

 

[Dean001]

Sorry for the bump, just wondering if anyone could help.
Thanks.