I have 7 columns (Company, Service Order, Type, Model, Date, Warranty, and Status). Each column has a drop down list (except the Service Order and Date).
Under Status I have a drop down list with a few options.
Inbound, Checked In, Evaluated, and etc...
I have 4 sheets (Inbound, In_House, In_House2, and Past record), each with it's own table (some with 2 tables). This is how far I have been able to get:
I manage to set a code to add 'New Entries' on the Inbound sheet for incoming repairs with it's corresponding drop down list.
I tried a few codes to move the rows corresponding with the Status column (Inbound, Checked In, Evaluated, Approved, etc...). However, I had no luck and kept getting errors or it would remove all the rows and replace the table on the other sheet with the rows (close but no cigar).
So....a little help on cutting a Row from one table and moving it to another table in another sheet, corresponding to the Status Column. If I can get the first sheet working, I should be able to do the rest.
test1.xlsm
Thank you everyone for looking over my worksheet
Bookmarks