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?
--
foxspirit
------------------------------------------------------------------------
foxspirit's Profile:
http://www.excelforum.com/member.php...o&userid=31264
View this thread:
http://www.excelforum.com/showthread...hreadid=509405