Automatic Copy / Paste Macro Needed

[cQuinc]

Tomorrow I have a project that will require a few hundred copy and paste operations.


It will go a lot quicker if I can find a macro that would allow me to copy the contents of a cell on one click and paste into a different cell on a second click. In other words Click #1 selects the cell and copies from it, Click #2 pastes the contents into the destination cell. Click #3 Copies, Click #4 Pastes. So on until I stop the macro.



It may not seem like much effort saved over the normal way of Right Click/Copy, Right Click/Paste but in this case for several hundred cells I think it would be helpful.


Quin

 

[Dryver14]

the Macro would need to know where to copy from and to or else it would need to be 2 macros one to copy and one to paste which is where you are now

 

[cQuinc]

The proposed macro would know where to copy from because the person using the macro would click on the cell that contains the copy information.

The macro would know the paste destination because the person using the macro would click on the destination cell. Just two clicks for the operation.

If I do this without a macro I count 4 Clicks
1 Left click to select the cell with the information
2 Right Click to copy the information
3 Right Click to select the destination cell
4 Left Click to paste the information.

Repeat several hundred times...

I think the difference would be much like when you paste formatting with the format painter. You can double click the format painter to keep it active and it saves a lot of time when pasting to dis-continuous cells.

Quin

 

[cQuinc]

Dryver,
Thank you for your comments. It appears I will need to learn more about VBA to appreciate what is possible and what is not.
Quin