Excel VBA Macro: Collecting data in external files – Experts only.
$30-250 USD
Completed
Posted over 4 years ago
$30-250 USD
Paid on delivery
Please read this carefully. The task is to locate Excel files having a specific filename (ie. starting with I 19, I 20 etc.) in a specific folder (incl. all subfolders) on a company drive (around 50 to 200 files).
Then, a worksheet should be extracted (it has always the same name) and copied to a new Excel File in the original folder. During the process, the extracted worksheets should be renamed with the filename from the original file. It should be checked, whether there are any changes from the last import to reduce runtimes, (unchanged files should be ignored). The original files should not be altered.
Then, in the newly created Excel file, certain cells (around 20, always the same structure in each worksheet) should be extracted to a new worksheet (eg cells E:8, G:8 and F:12 etc.) and written in one line in this new data worksheet (eg. “results”). While processing, the expected data structure per cell (text, date or number) should be checked, errors should be shown to the users (and the respective cells ignored).
We provide sample sheets of the original document and the target document with some test data (10 to 15 filled out excel files). In the target document, the cell references and the cell target format can be seen. Output is a smoothly running VBA macro generating the “results” worksheet in a flat data structure. The macro should be compatible to Excel 2013 to 2016ff and compatible to German syntax and formats (eg "1.000.000,00") and “20.11.2019”. Comments can be in English, we provide the translations for the error messages. Max. Budget is 80 USD.
Please add “understood” to your bid to show you have actually read this brief.
Understood your project.
I have done similar job on my previous project when i had to rename all of the files and transport the data to a new created file. 10 years working with data especially with macros will definitely solve your problem.
$77 USD in 1 day
5.0 (22 reviews)
4.7
4.7
5 freelancers are bidding on average $85 USD for this job
“understood”
Hi,
My name is Virendra.
I am experienced Data Analyst and Macro Developer.
I have read your instructions carefully.
I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports.
I have done mostly Excel VBA Programming jobs.
So, I can do this job nicely.
Ready to start, please message me to discuss your project in more details.
Thanks,
Virendra
understood
Hi, would you like to go with SCIENCE AND EXPERIENCE. I'm a Master holder in computer science and a developer expert for 10+ years.
I'm an expert who pays attention to details and time as you could see in my profile / reviews.
I've designed similar projects so the project will be delivered to you SHORTLY and PERFECTLY.
Please feel free to contact me and make sure you will be fully satisfied and pleased.
Waiting for your appreciated response.
Regards