Excel macro
Budget: $10 – $30 USD
Hello we want a excel macro to do the next operations:
1.-Compare 2 files for information and check the information found in what row it was found in a directory full of files. This giving to the macro where is the source to file to be used to search files and where the destination files to search for.
2.-Trim row values clones. For example some excel files will have in a column the same value a lot of times. I just want to keep one row with that value. Then using the same search of point 1 if is selected “Trim” it will find values in columns I will explain and keep first row found only and remove all other rows with that value in the whole excel.
All the results of operations must be in txt file or excel file in one output directory. The same if trim selected the trimmed files will be located in output directory but each one saved as xlsx, xlsx and csv.
In resume the macro must ask fro the route of a source file. This is the file to use to search the information. In other directory will be destination files. These destination files is where you will look from the spruce file in all of them for the instances you select in the macro.
In other words the job is search information in excel files from a source file like a robot and report results and trim some rows if selected that option that’s all. The options to search are defined in the macro with checks or bullets.
Be sure you know Excel macro VBA.
This is not data entry not offer that. This is a job to program VBA macro in excel. With knowledge how to call files and process from some files and directories to other files and directories and process in output directory the results. No other thing.
More details and instructions will be given for high details.
1.-Compare 2 files for information and check the information found in what row it was found in a directory full of files. This giving to the macro where is the source to file to be used to search files and where the destination files to search for.
2.-Trim row values clones. For example some excel files will have in a column the same value a lot of times. I just want to keep one row with that value. Then using the same search of point 1 if is selected “Trim” it will find values in columns I will explain and keep first row found only and remove all other rows with that value in the whole excel.
All the results of operations must be in txt file or excel file in one output directory. The same if trim selected the trimmed files will be located in output directory but each one saved as xlsx, xlsx and csv.
In resume the macro must ask fro the route of a source file. This is the file to use to search the information. In other directory will be destination files. These destination files is where you will look from the spruce file in all of them for the instances you select in the macro.
In other words the job is search information in excel files from a source file like a robot and report results and trim some rows if selected that option that’s all. The options to search are defined in the macro with checks or bullets.
Be sure you know Excel macro VBA.
This is not data entry not offer that. This is a job to program VBA macro in excel. With knowledge how to call files and process from some files and directories to other files and directories and process in output directory the results. No other thing.
More details and instructions will be given for high details.