Hi,
I have a spreadsheet with 3 identical worksheets. On all, Columns A to F are used and row 1 is headers. I want to create a button on the "Input" worksheet that when clicked scans column F and:
1. If the cell value of column F for the row is "In", move relevant row(s) to "Current Stock" sheet.
2. If cell value of column F for the row is "Out", vlookup the ID number in column A, moving the matching rows from "Current Stock" sheet to "Archive" sheet
While I can find VBA on here to move rows conditionally to another sheet, I'm coming unstuck on the multiple criteria required above. Any help appreciated!
I have a spreadsheet with 3 identical worksheets. On all, Columns A to F are used and row 1 is headers. I want to create a button on the "Input" worksheet that when clicked scans column F and:
1. If the cell value of column F for the row is "In", move relevant row(s) to "Current Stock" sheet.
2. If cell value of column F for the row is "Out", vlookup the ID number in column A, moving the matching rows from "Current Stock" sheet to "Archive" sheet
While I can find VBA on here to move rows conditionally to another sheet, I'm coming unstuck on the multiple criteria required above. Any help appreciated!
