P
Patrick
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
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