Command Button takes A row and places it to corresponding sheet name

[trevor2524]

Hello,

I have a practice workbook that I need to have the entire row get cut and pasted to the first available row on the corresponding sheet that matches the column A selection. The first available row should occur after the four row when looking at Column B. The list option should not be copied as the entire row should have just the values copied. This way i can restart the process after I hit the submit button. Thanks again for any help given.

TestButton.xlsm

[xladept]

Try this:

Please Login or Register  to view this content.

[trevor2524]

That almost works the way I need it to. Is there a way to keep the list values on the original sheet as well as carry them over to the new sheet?

[xladept]

I have a practice workbook that I need to have the entire row get cut and pasted to the first available row on the corresponding sheet that matches the column A selection.

I'll have to write a different routine - this one does what you originally wanted - later

[xladept]

Try this and let me know:

Please Login or Register  to view this content.