Hi
I have a spreadsheet with two worksheets that needs to have the information compared. Data is in one worksheet starts from G2 and in the other worksheet it starts from C2 & it should match as the first condition. The second condition is that O2 and E2 also match but because the data is not in order it needs to look within an array A2:A706 to Y2:Y706.
I can't figure out how to use the AND function within an array to make it work. It may be the case that I need VBA to make it work?
Once worksheet has 119 rows and the other has 705 with data within them.
I have a spreadsheet with two worksheets that needs to have the information compared. Data is in one worksheet starts from G2 and in the other worksheet it starts from C2 & it should match as the first condition. The second condition is that O2 and E2 also match but because the data is not in order it needs to look within an array A2:A706 to Y2:Y706.
I can't figure out how to use the AND function within an array to make it work. It may be the case that I need VBA to make it work?
Once worksheet has 119 rows and the other has 705 with data within them.