prsnthkrishna
New Member
Hi All,
I have 7lakhs to 8lakhs lines/rows in excel file. I have prepared an excel macro. In Module1, I used LOOKUP formula and it gives incorrect result. So, I changed it to INDEX and MATCH formula. This is consuming time. After writing this INDEX formula, I used text to column formula to get the correct result.
If I do not use Text to column, I'm getting incorrect result.
Is there any other way to get the results with less time. Can anyone help in this. The macro coding file is attached.
Let me know if any corrections to be made in the code.
Regards,
Prasanth Krishna
I have 7lakhs to 8lakhs lines/rows in excel file. I have prepared an excel macro. In Module1, I used LOOKUP formula and it gives incorrect result. So, I changed it to INDEX and MATCH formula. This is consuming time. After writing this INDEX formula, I used text to column formula to get the correct result.
If I do not use Text to column, I'm getting incorrect result.
Is there any other way to get the results with less time. Can anyone help in this. The macro coding file is attached.
Let me know if any corrections to be made in the code.
Regards,
Prasanth Krishna