I need someone to develop an excel VBA macro script.
The script would automate the process of combining multiple excel files into 1 large existing table.
I get multiple excel files that are all formatted the same exact way every month, each file has the same column names. I need the script to read the files from a specific folder on my computer, combine them (no calculations, each row is unique), and then insert them into an existing table in my worksheet. The existing table is essentially cleared of old data and this new combined excel data is inserted into the table every month.
The number of files that need to be combined and inserted into the existing table changes over time, the script needs to simply identify all files in a specific folder.
A more detailed project description and sample excel sheets will be provided to selected professionals following their bids. The macro will be provided in an open source format. The copyright and all rights on the macro will be mine. The professional should be available via Skype if needed, but email might be sufficient.
Kind regards
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
Windows 7
Hello,
I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix.
I have created a couple of similar projects in the past, I could use the templates to speed up the process for what you need. Can you please give me a estimate files count and total rows count? because if we're talking about >1mil lines then it needs to be designed differently.
Please let me know if you think you need me and we'll take it from there.
Thanks!
$98 USD en 3 días
5,0 (9 comentarios)
3,7
3,7
11 freelancers están ofertando un promedio de $70 USD por este trabajo
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA.
I plan to complete the project via writing an Excel macro contained in a separate XLSM file.
This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros.
Check my reviews. They speak for themselves.
Best regards
Hello Sir.
Im excel VBA macro and formula Expert.
I can combine your many file to 1 file Sir :). please give me your job and im able to start doing your job right now :)
Thank You
Sincerely
Prameswara
Hi there!
I am a doctoral research scholar working at the Indian Institute of Technology (IIT) Delhi. I have extensive experience in using MS Excel with Visual Basic Application (VBA) for manipulation. I am hopeful of providing you a valuable service.
Thank you.
Warm regards,
Naseef Ummer
I have 7+ years of experience in software industry. ASP .Net, C#, VB .Net, Visual Basic,SQL Server, MySQL,Bootstrap, Telerik, Access,Excel VBA, Crystal Report is my working area. I am confident to complete your requirement.
With over 15 years experience as a software and mechanical engineer I've created numerous spreadsheets to perform similar import tasks. I've worked with people in a wide range of industries, including medical devices, transportation, education, and toolmaking.
I can create a macro allowing you to set up parameters for the import, including storage location. All code will be fully owned by you and can be edited by you or or business as you see fit. If so desired I can be available for long term support in the event future changes to your input files require updates to the macro.
Feel free to contact me with questions