broman5000
03-27-2017, 06:54 AM
Hey guys/gals,
Please help!
Looking for the fastest VBA code that can highlight items in column B That do not exist in column A
Basically a loop of all data in column B and compare to whole column A until all column B data has been looked at
Column A is the master and may change each week
Column B changes in row length each week
If a cell in column B does not exist in entire column A, then highlight that cell in column B and continue the loop
I'd like to highlight the cell with red fill. I have attached the workbook at well
Thanks again and anything you can do to help would be great! Thanks!
MASTER Unique DROP P201711
Current Drop Week Unique Identifier
LIVEM37232401
LIVEM37232401
LIVER40232401
LIVER40232401
LIVEM35232402
LIVEM35232402
LIVER34232402
LIVER32232402
LIVET41232501
LIVET24232501
LIVEF31232501
LIVEF31232501
LIVEM36232601
LIVEM36232601
LIVER37232601
LIVER37232601
LIVEW43233301
LIVEW43233301
LIVES44233301
LIVES44233301
LIVEM20233302
LIVEM20233302
LIVER20233302
LIVER20233302
Please help!
Looking for the fastest VBA code that can highlight items in column B That do not exist in column A
Basically a loop of all data in column B and compare to whole column A until all column B data has been looked at
Column A is the master and may change each week
Column B changes in row length each week
If a cell in column B does not exist in entire column A, then highlight that cell in column B and continue the loop
I'd like to highlight the cell with red fill. I have attached the workbook at well
Thanks again and anything you can do to help would be great! Thanks!
MASTER Unique DROP P201711
Current Drop Week Unique Identifier
LIVEM37232401
LIVEM37232401
LIVER40232401
LIVER40232401
LIVEM35232402
LIVEM35232402
LIVER34232402
LIVER32232402
LIVET41232501
LIVET24232501
LIVEF31232501
LIVEF31232501
LIVEM36232601
LIVEM36232601
LIVER37232601
LIVER37232601
LIVEW43233301
LIVEW43233301
LIVES44233301
LIVES44233301
LIVEM20233302
LIVEM20233302
LIVER20233302
LIVER20233302