I have a set of 4 numbers. I need to go to each row in the spreadsheet,
search for 4 cells whose values matched these 4 numbers and then copy the
value of the cell right after these 4 cells to a table.
For example: the 4 numbers are 1, 2, 3, 4
In a row, I got: 10 30 100 3 5 1 2 3 4 20 40.....
I will have to copy 20 to a table and then continue to the next row.
I see we have a lot of examples searching for 1 value but for 4, I'm not
sure how to do it with a macro.
Thanks a lot,
mini