We need a MS Excel VBA application that consolidates 3 excel files into one single file.
MS Excel 2010
Sheet 1 will contain a input field for data location.
Fields to hold the identified import files
A load file button to activate the import
A file mask section where the user can define a mask that allows the identification of the import files
A section where unrecognized files shall be listed.
The application shall serve as a base structure and template for further development. Detail import functionalities will be done by us.
A sample master file and sample input files as well will be provided by us.
Steps file selection
1 Select the directory where the Excel files to import data from are located by pressing buton brows
2 If 'load files' is pressed
3 Check for each file whether it matches one of the file mask.
4 If a file matches add it to the corresponding input fiels (File A, B, C or D)
5 Files that doesn't match to any of the defined masks shall be listed below 'Unrecognized files'.
No excel file found in submited directory
File for one or more file type is missing
Steps Data Import
1 Select source data
2 check if destination contains already the source data
3 If not append data to destination.
4 Update calculated column
Source column not found
Destination column not found
File masks is used to setup the expected field content for a specific file by defining 5-6 Fields at a known position. This is to be set by the user!
27 freelancers are bidding on average $88 for this job
Hi, I can do the job, MS Excel VBA expert, I was developed several apps, to doing different stuff I am looking forward to work with you Best Regards Diego