Finding and moving data between worksheets based on dynamic variables

[Talfryn]

Greetings,

Been scratching my head over this, and while I've found many examples of code which copy and paste data between worksheets, I'm struggling to adapt it to what I want it to do. The last time I did any real VBA coding was in college about 17 years ago so I'm kinda jumping in the deep end here and while I can understand small snippets, most of the code I've looked at over the past few days is going over my head.

So far, I have vlookups in the cells to the left and right of F3 which return data on the serial number entered into F3. Right now we can see the s/n 1234ABCD is located on the sheet "In", has a part number of "AB", a status of "Bad" etc.

In essence, what I'd like to have is a button that will move that serial number and its corresponding data into a different sheet based on a drop-down list that will be in H7. For example, if H7 contains "WIP" the button will move that row of data into "WIP" and delete it from "In"

Here are screenshots of the "Main" sheet where I want the button and the "In" sheet where the data is located.

Any help with this would be much appreciated.

 

[Talfryn]

I've had some time to play around with it and the move function is working perfectly so thank you again. Although, could I ask that you do remove the serial number drop down as this workbook will grow to contain hundreds, possibly thousands of items given enough time. The worksheet drop down is a good idea though, there aren't too many sheets and will save users from getting errors if there's a typo.

 

[OaklandJim]

Here is the modified workbook.

 

[Talfryn]

Thank you so much, seems to be working perfectly so far. I'm sure I'll be back with another thread as I develop this spreadsheet more but for now you've done exactly what I needed.

 

[OaklandJim]

I appreciate the follow-up. If you want additional assistance from me then use this same thread unless your need is significantly different.