I have attached a file.
Sheet1 has a list of equipment with serial numbers in column A.
I need to Loop through each piece of equipment and compare the Serial number to each Named Range (CompanyA) & (CompanyB) - the serial number MAY be in CompanyA Or CompanyB or neither.
If there is a match, I would like to move the entire row to the first open row in the corresponding sheet. If no match, move to the next row.
Some heavy lifting is done (I hope) the macro in Module1 resizes the range on sheet1 and begins a loop at the first row...
I figure it would be easiset with Case Statements (because in the real workbook there will be about 15 tabs)
Thank you for looking at this.
Bookmarks