Hello, I work with a company that uses Excel to track what happens to each individual product throughout our ‘manufacturing’ process. Basically, Each singular product has a tag with specific number on it, completely unique with a barcode. I have 4 excel sheets in the same workbook, and ultimately, I want to be able to move the data about that individual product over into the next sheet, removing it from the previous “group” or sheet. So far, I have been using VLOOKUP to “transfer” the data into the next sheet, but I still have to do a “copy and paste values” and then manually delete the products from the previous status or list.
