I am developing a quote register at my work.
I've hit a stumbling block with some VBA I'm wanting to execute
I have a worksheet (sheet 1) which contains the quote, it has the quote number in cell L1 and the previous quote revision number in cell H1
There is another worksheet (sheet 2) which is a register of quotes and their status. It has the quote numbers in column A and revision number in column B and the current status in column C.
What I'm wanting to do is: Look up the quote number from sheet 1 L1 in sheet 2 column A as well as the revision number from sheet 1 H1 in sheet 2 column B. Where there is an exact match for both occurrences, I want it to make the status "Rev'd" in the corresponding cell in column C.
I did manage to find some code but it only has 1 criteria and I'm struggling with the second criteria.
Any help would be greatly appreciated.