Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question to speed up a process -
I have a sheet of over 4000 lines that i need to run a
comparison to a weekly update of over 4000 lines. Other jobs i have done have been for sheets with up to 1200 lines. When i ran my code on the sheet with 4000 lines, it took over 2 hours to execute. What i am doing is taking any lines that have been added to a weekly download and inserting them into the master sheet. If i were using Fox Pro, i could run a quick query and have a seperate table that would only have lines in the update that did not exist in the Master sheet and the update would be done much faster. any ideas? Is there a way to query a spreadsheet in such a way? TIA Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on Calculation Speed | Excel Discussion (Misc queries) | |||
vlookup speed question | Excel Worksheet Functions | |||
Speed up the process | Charts and Charting in Excel | |||
Re-calc. speed question | Excel Worksheet Functions | |||
VBA Speed question | Excel Programming |