Double-clicking a cell to copy it to another cell in the same worksheet

Hi guys,

1. I am wondering if I can copy a cell from table A to another cell in table B in the same worksheet by double clicking the original cell.
2. I would also like to know if it is possible to create a reset button that will enable me to reset the values in Table B when needed.

I have attached a sample excel file below for your review.

Any help will be highly appreciated.

Cheers,

DoubleClick is not good because you enter in edit mode as you can see testing this code

Please Login or Register  to view this content.

I suggest select cell then click a Button

Hello jjin,

Try the attached WorkBook. It automatically updates as you select a cell within Table A, and the Reset Button does what you have asked for.

Also see the "Please consider" note at the bottom of this post

Hi jjin,

You are welcome, glad I could help.

Thank you for the Rep.

To mark your thread as [SOLVED], check out the Forum Rules again. In there it explains different ways of how to do it. Choose what suits you best.