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:
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: