I have created an Excel file that has 175,635 rows of data. It contains all the clock in/out data for work orders for the past six months. Now I'll need to do a VLOOKUP to assign a project code to each transaction. Maybe it's time to take it into Access or something.
==========
VLOOKUP takes about 2 minutes to refresh. Definitely need to do something different.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment