Remote Web Development Job In IT And Programming

Need a developer to improve current VBA Macro

Find more Web Development remote jobs posted recently Worldwide

To improve a current VBA-Macro in MS Excel that automatically opens workbooks and then transfers data from these multiple workbooks from a single folder to a single Macro-enabled workbook.
Currently, my VBA-Macro can only transfer my source data if these files are stored in the document folder; path as follows C:\\Users\\So\\Documents\\. If the source data files are in any other directory, it does not work. I need it to be flexible in terms of the directory the source data files are kept.
Also, the number of rows copied from source data/files is not dynamic. If the number of rows in which data appears, increases, it still only copies from the pre-determined range.

I have another VBA-Macro that has a dynamic range (automatically includes new rows to be transferred) but does not open the source files automatically and is designed to only copy from one source workbook, not multiple. Its not good enough as I could just copy and paste. It defeats the purpose of having a VBA-Macro.

PC1 and PC2 are source data for MTM. VBA-Macro in MTM opens multiple files. But is not dynamic and PC1 and PC2 must be in the documents folder for the VBA-Macro to work.

VBA-Macro in MTMCONTRACTS transfers source data from Positions-Contracts. It can transfer from a dynamic range that includes new rows but does not open source data files automatically and only transfers from one opened file. It defeats the purpose of the VBA-Macro.

I just need the one VBA-Macro that combines the attributes of:
1. Opens multiple source data files automatically
2. Source data files can be filed in any directory, not limited to Documents folder
3. Dynamic; includes new rows.
Would prefer the VBA-Macro to be created for the MTMCONTRACTS file. That means also there would be at least one other source data file identical to Positions-Contracts in its format.
Would be grateful if this VBA-Macro is flexible so that if format/columns change, it will still work.

Many thanks.
About the recuiter
Member since Nov 11, 2022
Tuxmantra Solutions
from Departamento del Cauca, Colombia

Open for hiringApply before - Sep 15, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.95

Cost

Offer to work on this project closes in 119 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Create Dynamic Underwriting Excel Model for Real Estate Aquisition

Dynamic Underwriting Model in Excel needed for Real Estate Fund that is beginning acquisition of real estate properties. The fund offering is a Blind Pool investment fund.

Microsoft Access and Excel VBA Developer needed

I need someone that is proficient in VBA for Access and Excel. The person also must also have experience writing VBA code from Access to create formatted Excel reports. So, the person needs to be able to create an Access database that can generate a...read more

Data Cleanup - Email Address Research

I have (2) projects: Project 1: I have a list of 25,000 emails that I need to be researched and updated. I need to know the company name, industry, persons first & last name, phone number, and cell phone number (if it can be found). Most of the...read more

Tableau Dashboard For Marketing Analytics

I need someone competent in Tableau to create and manage a dashboard visualization for one of our SAAS clients.

We specialise in facebook ads, so the exported data will be provided for you. Tableau public is fine to upload your visualization...read more