Hello Sir,
The macro will work upto 1.25 lak rows with 110 column, but throws error if it exceeds 1.25 lakh rows with following message
Run time error 7
over flow error.
How could it be fixed
Special thanks to Jindon Sir for providing short code to perform lookup function.
However when I...