I have two workbooks and I’m trying to go through them and highlight the following.
In each row where an error is identified, I want to highlight the (“Errors”) column, the (“Employee”) column as well as the column with the specified error.
I was able to hard code the "Errors" column as "A" but the "Employee" column varies between the two workbooks. In the first workbook its "H" and in the second one its "J"
Is there anyway I can highlight properly based on header name regardless of where the column is in the sheets? Here's what I've tried so far.
Any help would be greatly appreciated!
Bookmarks