need command button to trasfer data

[eddie12345]

hi there

i am creating a workbook for my company where if a customer calls i collect data through a user-form that captures the name, surname, query, description, tel, email, address and date and when i hit the submit button the data in the forms go's to sheet to in the following order.

a b c d e f g h
Name Surname Query description tel email address date


so, when ever i use the userform it allocates the data to next available line. so every data falls underneath each other.

now.......
i would like to have command buttons that is named COMPLETED and NOTCOMPLETED next to each data entry so that i can select if its is completed it will cut out my data entry thats completed to my completed sheet and if its notcompleted to cut and paste it in my notcompleted sheet.

the completed buttons gets allocated in column I
and NotCompleted in column J

I hope this make sens what i want to do and can any1 please assist.

Kind regards
Eddie

[Winon]

Hello eddie12345,

Welcome to the Forum.

May I suggest you upload a sample Workbook with what you have, and showing us how you would like the outcome to be like.

Baie dankie

[eddie12345]

Book2.xlsm


basically i need a command box that will be in the completed column and a command box in uncompleted column.

So that when i hit either 1 or the other it would go to the completed sheet or uncompleted sheet.

but when it moves out of the log sheet to corresponding sheet the rows in the log sheet must move up so i can do select complete or not complete again.
and so goes on

[eddie12345]

Currently i have created the following module for a command button (complete)


Sub Upload()

Range("A2", Range("H" & Rows.Count).End(xlUp)).Copy Sheets(3).Range("A" & Rows.Count).End(xlUp)(2)
Range("A2", Range("H" & Rows.Count).End(xlUp)).ClearContents

End Sub


The problem with this code is that it does not cut it copy and paste
Also, if i use this module on the 2nd row or lower it does not jus copy the info from the line the command button sits. it copys all the info from this line and upwards.

i want it only to copy the inf for instance A4 B4 C4 D4 E4 F4 G4 H4 because I4 contains the command button

And in the next roe I5 where the command button sits i want it to only copy info from A5 to H5

And so goes on

i know i have to create a module for each command button on each row and then change the range but it still copys all the info.
Please can any 1 assist.

i hope i make sense with what i want to do

Kind Regards
Eddie

[Winon]

Hello eddie12345,

Please see if the attached sample Workbook, is what you want. I have changed the layout of the Userform a little bit, to fit on my screen. You may change it again to the way you want it.

Regards

[eddie12345]

Thanks so Kindly

This is perfect.
I do appricaite the assistance.

Thanks Thanks Thanks

[eddie12345]

Thanks so Kindly

This is perfect.
I do appricaite the assistance.

Thanks Thanks Thanks

[Winon]

Hello eddie12345,

You are welcome. Glad I could help.

Please go to your first Post, click on Thread Tools, and select "Solved", to mark this Thread as Solved.

Thank you,

Regards.