Move from one sheet to another

[jimpatel1993]

Hi

Thanks a lot for looking at my post. I wanted to move certain data from one sheet to another depending on the selection of list box data. Please check the attachment for my query.

Really appreciate your help.

[HansV]

See the attached version.

Move data between sheets.xlsm

[jimpatel1993]

That's fabulous work.
Thanks a lot for your help. Just couple of questions related to that design please.
1. Is there is any way to stop moving duplicate data please?
2. Is there any way to delete certain part number from the sheet2 which has been transferred mistakenly and
3. Is there any way to clean all the data in the sheet2 please

Thanks a lot and much appreciated

Jim

[HansV]

See the attached version.

Move data between sheets.xlsm

[jimpatel1993]

Amazing
That was great help
Really appreciate your time
Thanks a lot
Kind regards
Jim