Find Jobs
Hire Freelancers

create excel macro/vba

$10-30 AUD

Completed
Posted over 9 years ago

$10-30 AUD

Paid on delivery
Budget $15 Need someone to create a script in excel (macro) which can take data from multiple files one by one and add to one master file. Tasks: 1. All data contained in multiple slave files must be copied and placed into one Master file which will contain all records consolidated 2. The script will sit inside the created Master file called ‘CombinedData’ 3. Button on Sheet2 called ‘Import Slave Data’ 4. When pressed, all files (except for Master file ‘CombinedData’) in the same directory/ folder as master file will import in 5. Need to only copy data- data remains unchanged in originating slaves 6. Data is processed by one slave at a time, one by one 7. Data is added to Master below existing data row so builds up (should not delete /replace any data in master file) 8. Need to add column ‘File Name’ to column A of Sheet1 for Master file and append the file name for where each record came from for every row added in Master file. This means data from slave will always begin from column B. 9. Need to copy color highlight (important) 10. No need to copy data validation rules. • Admin will ensure format of columns is the same as slave so data is displayed correctly • There are formulas so only values should be copied into master. • The script needs to be versatile so can be used in other scenarios- no hard coding of slave names or full directory name- just whatever is contained in the folder where master file sits it should take.
Project ID: 6690921

About the project

21 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi! I would be pleased to do a project for you again! I can deliver very fast, I have the scripts ready, only have to complete it if you could please answer a couple of questions I have after going through your requirements: 1. Done: are there also subfolders? (If yes: if masterfile is in "C:\SomeFolder\ and path of file in subfolder would be: C:\SomeFolder\SubFolder\, what would you like to put as filename? Only the filename, or also the name of the subfolder?) 2. I will not only ignore "CombinedData", but also the "temporary filenames", e.g. if "[login to view URL]" is open, there is also a temporary filename "~$[login to view URL]". 3. Button on Sheet2 = OK 4+5+6+7+8 = OK 9. What do you mean by copy color highlight? Copy value including formatting (including cell color) = OK 10. If e.g. a cell is bold + red, and bold comes from straight forward formatting and red comes from data validation rule: do you want to copy "bold + red" (= not the [login to view URL] but the [login to view URL]) or only "bold" (= neither the formatting rule nor the formatting value) Many thanks again for your consideration and I look forward to working on this project! I will also send you a message in your inbox to make sure you won't miss my bid between the many other ones... Brgds, MKL7
$15 AUD in 1 day
5.0 (18 reviews)
3.2
3.2
21 freelancers are bidding on average $24 AUD for this job
User Avatar
A proposal has not yet been provided
$50 AUD in 1 day
4.9 (251 reviews)
7.6
7.6
User Avatar
We are ready to work on this project and to start immediately We have the requirements to handle this project effectively and timely too. For this job we will be using our vast experience on excel Macros to handle it,
$34 AUD in 1 day
5.0 (53 reviews)
6.6
6.6
User Avatar
Hello, I'm Excel and VBA programmer with over 5 year of experience. I have written many different applications for Excel in recent years. I am confident that I can perform this task. I am currently working in a large trading company in Europe. Thank you very much Jan Krzyzak
$14 AUD in 3 days
5.0 (93 reviews)
6.0
6.0
User Avatar
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. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$27 AUD in 1 day
4.9 (63 reviews)
5.7
5.7
User Avatar
Hi, I have experiences with excellent feedback for this type of project, fast work and pay attention to the details. Regards, Jay
$30 AUD in 2 days
5.0 (92 reviews)
5.8
5.8
User Avatar
Hi; I can help. I am an Excel/Word VBA coder professional with over ten years experience in developing automated productivity enhancing, time saving applications. I can provide many examples on your request. I can have your macro completed today, Your comments and questions are most welcomed. Regards Zenon
$45 AUD in 1 day
4.9 (32 reviews)
5.6
5.6
User Avatar
Hi, I'm Excel VBA developer and i can develop script for data consolidation ''No Hard Coding**** Thanks
$15 AUD in 1 day
5.0 (10 reviews)
4.7
4.7
User Avatar
Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$15 AUD in 0 day
5.0 (48 reviews)
4.6
4.6
User Avatar
i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign
$15 AUD in 1 day
4.9 (26 reviews)
4.3
4.3
User Avatar
20+ years of experience. Will list file s from folder. open one by one . first do normal copy and then value paste to retrain format from slave.
$15 AUD in 2 days
5.0 (2 reviews)
3.4
3.4
User Avatar
We are a group of qualified people ever ready to complete your work in time. we are 24 hours ready to finish as soon as possible.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already done this kind of job so I can fulfill your requirement easily... Will be happy to work with you..
$20 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, a few information about me - Master of Science in Electrical Engineering - excellent knowledge of Microsoft Office suite, Photoshop, Audacity, Adobe premiere, Adobe Illustrator, Pinnacle studio, QuickTime Pro I have a great experience in MS Office software as well as in VBA for MS Office . Everything is clear from your description and I don't have any questions for now. Best wishes Ivan
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i belong to banking field and use to work on excel.i will ensure you that you will find hardly any mistakes in my work.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am having experience of more than 14 years in Data entry and have worked on MS office i.e. word, excel and power point. I look ahead associating with you want the clear idea about the work to be done, time frame and payment will be made. I assure you that work will be delivered to you as per pre decided schedule and to your utmost satisfaction. Waiting for your affirmative reply.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , I have already some tools that does what you want. I can update it to you need in no time and you can use it when you want.
$40 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Your explanation is written very clearly. In fact I have some additional questions: - in master folder there will be some other files? if yes what types? - all workbooks will be of the same format (Excel 2003/2007, with macros, etc.)? - does SlaveData have headers? do script have to copy them? For every answer I have some ideas. It will be working like hell. This script will be ready in less then couple of hours with 3 days free support. BR, Daniel
$14 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Enmore, Australia
5.0
59
Payment method verified
Member since Feb 15, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.