I know just enough about Excel to get me into trouble but not enough to
get me out.
I am trying to build a form that buyers will fill out for advertising.
Objective: when they enter the dept. number and the sku number all
information pertaining to that sku will automatically fill in the
appropriate places in the form.

I have 38 depts. I need to look at. I know IF statements can only go 7
layers deep. So I took the information from the 38 depts and put it on
7 different sheets in my workbook. I then find out that this
information is updated monthly so I revamped my worksheets and made a
link to the original sheets.

I am getting the error: Excel cannot complete this task with the
available resources. Choose less data or close other applications.

Our IT department tried to open and close this and with all the memory
they have it still has problems. He did find something about nesting
and it can only go 20 layers deep. Unfortunately I don't know about
nesting and no can seem to help me. Any suggestions? Other than scrap
it. HA!


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