Hello,
I am creating a excel workbook model that is running out of formula memory.
It has a data sheet with all the information. The working sheet pulls in data
from the data sheet depending on selections made by the user and runs
different calculations and scenarios.
The problem I am running into is once there are more than 2,000 lines in the
working sheet excel errors out due to memory and the screen turns black. Is
there a way through
vb to not use vlookups or indexing and only retrieve new
data when a selection changes? The average line count is around 8,000 lines
and 85 columns of formulas.
Any help would be great.
--
Thank you,
Jake
email as needed to: --
--