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.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":277175},"skills":["Excel VBA","IMacros","Microsoft Excel","Microsoft Excel PowerPivot","VBA"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-09-15T16:49:57+05:30","url":"https://www.toogit.com/freelance-jobs/Mjc3MTc1"}
Remote Web Development Job In IT And Programming
Find more Web Development remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$95.79
Cost 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
To all the excel experts out there, I need help on an advanced formula. I am trying to use an INDEX MATCH formula that is configured with MATCH set to look through a one-column range and provide a match based on given criteria. The sample criteria lo...read more
I need someone that has access to the PACER website to extract some data regarding bankruptcy cases filed in 2018
I need someone with pivot table and data management experience to take a large lead list and break it out by category, state and title where title is available.
We are posting a short-term position because we need help immediately - there is potential for an ongoing position for the right person. 10-30 hours a week.
What We Need:
Flexible Administrative Assistant -
We are looking for an ent...read more
Create and tweak spreadsheet for investors and developer to use for irr and budgets for real estate