for TT.xlsm heres a link to the tester file
(real file will have differnt amount of lines anywhere from 50- 5000. tab names and headers will always be the same)
In Not on a Category tab, column D will have random vendor names, its different every day.
Vendor Policy tab column has every single vendor in column A
If any vendors in Not a Category tab match with column A in Vendor Policy tab then check if there is a yes in column J of vendor policy tab. If its yes then put in column H of Not a Category tab TT
so example tab1 column D has 1 source video.
tab3 has 1 source video also and column J is yes so i manually put TT in coulmn H not a category tab
thanks in the advance for the macro
(real file will have differnt amount of lines anywhere from 50- 5000. tab names and headers will always be the same)
In Not on a Category tab, column D will have random vendor names, its different every day.
Vendor Policy tab column has every single vendor in column A
If any vendors in Not a Category tab match with column A in Vendor Policy tab then check if there is a yes in column J of vendor policy tab. If its yes then put in column H of Not a Category tab TT
so example tab1 column D has 1 source video.
tab3 has 1 source video also and column J is yes so i manually put TT in coulmn H not a category tab
thanks in the advance for the macro