so i have a workbook which consists of 7 sheets. i have a macro that is creating an 8th sheet. now what i wanna do is compare each individual cell in one of the columns of the 8th sheet with every cell in one of the columns in the 3rd sheet. then if there is a match, i want it to say "hardware" in the next column over corresponding to the cell with the match in the 8th sheet. i hope this makes sense. i have tried to simplify it as much as possible. how would i go about this?