PDA

View Full Version : Populate vlookup formula 1Million item



emina002
05-19-2016, 10:28 PM
Hi,

I know how to create macro,my problem is I have to put the Vlookup formula on almost 900,000 line items. I already turned off calculation option and only calculate specific column, I occupied 6 column that has formula. The problem is it is getting slow like the excel started to calculate 12mn(PST) and until now 1pm(PST).it only calculate 44%, I am afraid to move my cursor across excel and the calculation will stop processing, is there any solution to this? Please help:crying::banghead::eek:: pray2:

Paul_Hossler
05-20-2016, 06:04 AM
What does the code look like?

Do you need the formula or just the results?

If just results, there's collections and dictionaries that might be faster