What code can i use to
1. Filter column B to "red"
2. Vlookup column C to column E
( So that it only vlookup those filtered red in column B )
3. Delete those #N/A that didn't match ( for red only)
And loop this until cell A and B are blank
Thanks in advance
1. Filter column B to "red"
2. Vlookup column C to column E
( So that it only vlookup those filtered red in column B )
3. Delete those #N/A that didn't match ( for red only)
And loop this until cell A and B are blank
Thanks in advance