How do I pull a merged cell from another workbook?
 

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