Background:
So I have 20 procedure macro that does the following operations:
Clears cells from sheets, open inputs files, copys input data, creates keys by using logical keys for expected and actual, compares expected and actual results by doing vlookup off of expected key - highlights wrong cells, highlights red duplicates of actual and expected in there sheets, and then lastly finds extra actuals that are not in expected sheet and copys that key in underneath all comparisons.
Problem: Orginally it took 2.5 hours for the Macro to compare 20,000 rows from two input files.
Now it takes 1h20min by adding manual calculation syntax and cancel screen updating.
What else can I do to reduce the time to complete 20,000 rows from 1h20min to 20 - 30 min?
Thanks(Let me know if you need code theres like 30 pages)
So I have 20 procedure macro that does the following operations:
Clears cells from sheets, open inputs files, copys input data, creates keys by using logical keys for expected and actual, compares expected and actual results by doing vlookup off of expected key - highlights wrong cells, highlights red duplicates of actual and expected in there sheets, and then lastly finds extra actuals that are not in expected sheet and copys that key in underneath all comparisons.
Problem: Orginally it took 2.5 hours for the Macro to compare 20,000 rows from two input files.
Now it takes 1h20min by adding manual calculation syntax and cancel screen updating.
What else can I do to reduce the time to complete 20,000 rows from 1h20min to 20 - 30 min?
Thanks(Let me know if you need code theres like 30 pages)
