Double click in cell column A Sheet2 and move cells in row to specific cells in Sheet1

[abjac]

Hi I am trying to make this work. But so far no luck. What i would like to do is when i double click example Cell A2 in Sheet2 it moves the cells in that row to specific cells in Sheet1- I need some which refer to the row i double click. It maybe easier to see the attached worksheet.
I have so far put this code into Sheet 2. But it only call a macro i have recorded to move from row 2 in Sheet 2. I need some code which refer to the row i double click on, and copy the data in this row to sheet 1: so from the specific row i double click on. ¨So if i double click in example A3 it should copy these date in this row.


In sheet1 after i would like to copy back again after i example make changes. So it overwrite in the same row i copied from Sheet2


So blow code not working . It just copy one specific row. I need one which refer to the row i actually double click on.

Please have a look and i have attached a test sheet more easy see there.

Thanks in advance
Abjac

Please Login or Register  to view this content.

[abjac]

Ps i had some code i could not post according to some firewall it was the code recorded but can be seen in the test sheet. But weird i cant put it there. But this code again just copy from a specific row to sheet 1.- I need one which copy from the row number i click and actually in Sheet one. A code which can copy it back again same row. So it overwrite changes. Have a look thanks Abjac

[TMS]

Think this is what you want:

Please Login or Register  to view this content.

[TMS]

This version stores to row number so you can use it to update the values

Please Login or Register  to view this content.

[abjac]

Wow was on my way to bed here. This seems to be really really good. It works perfect. The second code it store the row number in sheet 2 in cell A1. That i understand but what kind of macro example with a save button in sheet1 do i need to refer to this row number and copy the update back again? The codes are brilliant really. In the real sheet can be more to move but that i can find out. Any idea how to move them back to the row number in sheet2 from the row number in cell A1 sheet1 ?
Ps. there can be empty cells in the real sheet.
Sincerely abjac

[TMS]

Well, if you use the second code and put the row number in cell A1, you could double click on it and use the value in copy statements ... just reverse what you did in the original move.

[abjac]

Hi TMS. And thanks i tried i would like to have separate macro in sheet 1 to safe the changes. I tried this below referring to the value in cell A1. Bur i cant make it work. Could you have a look and see how i could make a separate macro to safe and copy the changes to sheet2 the correct row.

This below dont work at all. Sure i do some basic mistakes . Please have a look thanks in advance Abjac

Please Login or Register  to view this content.

[abjac]

Hi TMS. I think i managed now to get a solution which seems to work good. It can be seen in below code. Thanks so much for your help.
Verư very good solution and your are for sure expert. Thanks

My working code to safe the data.

Bad again cant get the code in because of this security . Sorry

i Attach the workbook with the codes thanks
Sincerely Abjac

[TMS]

You're welcome. Thanks for the rep.