find question
 

does it make sense to do a find within a find to determine some value?

i have a formula that uses index/match, but with almost 100k formulas, the calc is too long.

so basically in code, i find a value from ws1 column d (1), on ws2 column e, to get the value in column f(745).

then i use another find to find ws1 column O(331) & the found value above(745), on ws2 columns A(331) and B(745) and use some values from columns H-J to populate back on ws1.

hopefully you can see what i mean.

just not sure about the find within a find.

i have code that does it, no need to write me any code, just looking for other ideas.

--



Gary

find question
 

Hi,

I'm not sure that I never found using Find within find methode,
For me is better using array methode to find same data or doing same work
for several process or times also I use stored template in the XLA file to
populate values

That will save memory for Excel while processing.
--
Regards,

Halim