Hi All
I have two sheets... "X66" and the other "Master".
for each backend role in sheet "x66", column L, (L2,L3, l4, etc..)
search sheet "Master" for a match.
For "X66" B3, check "X66" B$1. If B$1 matches "Master"Sheet, column E, then fill B3="X"
otherwise, "N/A"
Repeat steps 3 and 4 for next cell until "X66" J$1
Repeat
Repeat until column L is empty
I ultimately have 15,000 to do and they all need to be added to each individual sheet based on selection. So, this would save a lot of time.
Thank you !!
Gene
Bookmarks