Forum Discussion
Macro to move row to another sheet
Hello all, I'm still new to VBA and practicing through trial and error. I'm currently working on an excel document that is an inventory spreadsheet. When we perform annual inventory checks I want...
You do not need VBA in this case. Use FILTER() function. So, when you scan barcode, the scan data will show in a cell to sheet2. Use FILTER() function to pull data from sheet1 based on criteria of scan data.