outlawspeeder
Board Regular
- Joined
- Jan 17, 2009
- Messages
- 225
- Office Version
- 2019
I have on sheet 1 A10:A20 and B10:B20.
If on sheet 2 Column D matches A10:A20 the row is moved to sheet 3, if matches B10:B20 move the row to sheet 4, If it doesn't match at all mve to sheet 5.
I have been using a pivot data for this but I know there is a faster way that will have less errors.
If on sheet 2 Column D matches A10:A20 the row is moved to sheet 3, if matches B10:B20 move the row to sheet 4, If it doesn't match at all mve to sheet 5.
I have been using a pivot data for this but I know there is a faster way that will have less errors.