I need two VBA Scrips created that analyze data
Budget: $250 – $750 USD
Hello,
We have an output from our system that creates CSV files. I have been pretty good about creating marco's by recording, the biggest problem I am running into is the speed at which it takes for the macro to complete the task.
Both Macros use a separate excel file to find filter values.
Filter values are combined with values in the document to create a code. I then am able to assign actions to those codes (Vlookup) that assist me in the next steps of my process.
One of the reports references a third excel document to enter contact information if required by utilizing Vlookup
The biggest problem I have (which I believe makes the recorded macros so slow) is that the reports I am analyzing can be anywhere between 4 lines and 10000 lines long. Therefore when I record my own I have 200+ filter values analyzing each row.
We have an output from our system that creates CSV files. I have been pretty good about creating marco's by recording, the biggest problem I am running into is the speed at which it takes for the macro to complete the task.
Both Macros use a separate excel file to find filter values.
Filter values are combined with values in the document to create a code. I then am able to assign actions to those codes (Vlookup) that assist me in the next steps of my process.
One of the reports references a third excel document to enter contact information if required by utilizing Vlookup
The biggest problem I have (which I believe makes the recorded macros so slow) is that the reports I am analyzing can be anywhere between 4 lines and 10000 lines long. Therefore when I record my own I have 200+ filter values analyzing each row.