Commandbutton to cut and paste highlighted row

[KK1234]

Hi all,
I have 3 sheets
In sheet1 I have rows numbered from 1-19

What I want to achieve:
- Select row 3 by highlighting third cell in column1
- Then press command button1 to transfer it to sheet2 and button2 to transfer row to sheet3.
I have tried many methods but can not get it right.
Some help please
Thanks
Kind regards

[sktneer]

What do you mean by "Select row 3 by highlighting third cell in column 1"? You mean cell A3, but do you want to select A3 and press the command button 1 and 2 or you want to select A3 and then change the background color and then press the command button 1 and 2.

Moreover will the command button 1 and 2 work for row3 only, i.e. do you want to transfer only row 3 to sheet2 and sheet3 every time?

You need to clarify more.

[KK1234]

Hi,
e.g. in sheet1 I select A3 and press button1 . This will transfer entire row to sheet2 in the next empty row.
& pressing button2 it will transfer it to sheet3 in similar way.
There is no colour change.
I have coloured sheets just to make look different.
Thanks
Kind regards

[JOHN H. DAVIS]

Maybe:

button 1

Please Login or Register  to view this content.

button 2

Please Login or Register  to view this content.

combined:

Please Login or Register  to view this content.

[KK1234]

Hi John H Davis.
Really thanks for your help.
It works great.
Thanks again
kind regards

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.