Tom-
I have approx. 130,000 rows of information and there are only, as you
know, 65,536 rows per sheet. Out of 13 columns of information per
Dept. I need to pull info from 7 of the columns over to the main
worksheet. It needs to look first at the Dept. number (C17) then at
the SKU that then leads to the information in that row and picks up the
information needed. It's works, except for the fact that it's too much
information and I get the error message, up to the point of adding the
seperate worksheets with the 5 +/- depts. on it. It also worked better
until I linked the seperate worksheets to the original Dept. info sheet,
which is updated monthly. If I knew what formula to use so it would
look at all 38 sheets that would be great.


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=382579