Double click a cell to copy it to another cell & how to create a reset button in excel

Hi guys,

Wish you all a happy new year.

My inquiry is very straight forward. I would like to copy a cell to another cell in the same worksheet by double-clicking the original cell. (Perhaps using VBA code). I would also like to know if I can creaet a reset button so that whenever I want to reset the values in Table B, I can simply click the button then all the values goes back to its default value.

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

Any help will be highly appreciated.

cheers,

How about Worksheet Event Code?

Please Login or Register  to view this content.

For resetting?

Please Login or Register  to view this content.