Not sure whether this belongs in the VBA forum or here.

I have a VBA script on one worksheet that pulls information from a second worksheet. (I won't go into details unless you guys want them.) Problem is, that second worksheet has over 150,000 rows of data, and I'm working hard to keep that number low. The script is run hundreds of times per day and can easily have dozens of lookups each time it's run. As each lookup takes 2-3 seconds, this slows down the whole process significantly.

Is there a quicker way for me to store this information? A co-worker suggested MS Access, but I have no experience in it. Can my Excel sheet quickly and easily pull from an Access file? Or is there maybe a better way to store this much data?

Thanks!