I have a sheet and its organized like so:
Row Column
1 A - K: each cell has seperate info
2 B: has info
3 B: has info
2-5 C-K: merged cell with text info
6 : blank

Then the pattern repeats itself. What I want to do is on workbook 2, look up in workbook 1 column J for the info in 1J and if it says X, copy 1-6 onto work book 2. If it says Y skip it.

Is this possible with the big merged cell?