Find Jobs
Hire Freelancers

Simple macro to fill a template excel file based on an input file data and generate for each ID a filled template

$30-250 USD

Completed
Posted over 1 year ago

$30-250 USD

Paid on delivery
See attachment for the process. There are 2 excel files. File 1: data sheet, columns with data and a cell where you can input an ID. In this example there are 40 IDs. Based on the ID numbers the according data is being fetched. So for each ID this sheet 3 columns of data is changing. File 2: general template where you have one excel sheet where this data for each ID should be pasted and the excel file should be saved as the ID name. So copy three columns for each ID from file 1 to this template excel file, every time on a fixed position. Save the excel file and repeat again the process till the last ID in this case 40 ID's.
Project ID: 34273656

About the project

28 proposals
Remote project
Active 2 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, this is very common request, would you mind attaching those 2 excel sheets so i can see the exact cells and how everything looks like. In general this is very simple and i can automate this for you now (as in while you wait). Done this hundreds of times. If you are interested, feel free to message me. Thanks, Milan
$45 USD in 1 day
5.0 (758 reviews)
7.5
7.5
28 freelancers are bidding on average $100 USD for this job
User Avatar
Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do great work for you and ensure your quality. I have more than 5 years of experience with excel. Complete a lot of jobs on Freelancer with high satisfaction of the client.
$199 USD in 1 day
5.0 (101 reviews)
6.1
6.1
User Avatar
Hi sir how are you I am expert and experienced in excel spreadsheet development and data entry I have understood your all task requirements I will do the job exactly and perfectly without error kindly message me I am waiting positively thanks sir
$30 USD in 3 days
5.0 (25 reviews)
5.1
5.1
User Avatar
Ready to write the macro/script required, for each ID in sheet 1 will copy 3 column data, insert it in defined places in sheet 2(the template) save the sheet2 as new file with ID as name, repeat attache the data sheet (file1) and the template sheet (file2), will send you back file 1 with the macro, anyway you will pay after test and work is perfectly completed
$30 USD in 2 days
4.9 (14 reviews)
4.2
4.2
User Avatar
"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, tables, absolutely any request will be satisfied. If necessary, I will write accompanying documentation or video. Ready to solve a problem of any level of complexity. Services Offered: ✅Automating Tasks. ✅Data Validation. ✅Data Analysis. ✅Custom Formulas. ✅Creating User Forms. ✅Charts. ✅Pivot Tables. ✅Formatting, Fixing, Forms, Formulas, Functions. ✅VBA Macros Automation. ✅Web Scraping/Data Mining from any website and any amount of data. ✅Data collection, Images Downloadable / Images URL. At any time ready to provide support on emerging issues. I am happy to provide after-sales support, you can always count on me. ""✌️People like surprises and here I come into play, to present your ideas to the world in the best manner✌️"". Please don't waste your time looking around. Please feel free to contact me. I'm ready to start your project. Thanks in advance!"
$50 USD in 1 day
4.8 (16 reviews)
4.0
4.0
User Avatar
Hi there, Your Excel Macro Specialist is here Graduated from London; United Kingdom in Investment & Finance; Risk Management. I have done various VLOOKUPS, Macros, Data Analysis, Sorting of data, VBA, Hyperlinks and etc. I have handled various excel projects such as Financial Modeling, Risk Assessment, Balance sheet, Income Statements, Data Sorting and etc. I will be able to complete your task as per your requirement and understandings Feel free to inbox for more details and budget Regards, S.A
$30 USD in 1 day
5.0 (2 reviews)
3.4
3.4
User Avatar
Hi, I've read your description carefully. I have full experience with Excel, VBA, Macros I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more about the project from you via chatting. Thanks & Best regards!
$60 USD in 2 days
5.0 (1 review)
2.2
2.2
User Avatar
Hello I have a much time. So I can finish your project completely I'm an expert in Excel I've read the project description carefully. It would be a great pleasure for me to have the opportunity working with you. Best regards!
$140 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
⭐️I am here to Work , Create , Produce & do my best ⭐️ Hi , I have seen the project details , & I found that I can handle your project effectively I can help you to fill a template excel ( file 2 ) based on ID from file 1 About me : ✅ I am executive virtual assistant ✅ Bachelor's degree in business administration ✅ Diploma in administrative procedures and office support ✅ I am excel expert ( Macros , VBA , advanced formulas ) ✅ I have a certificate of completion advanced excel course accredited by the CPD (35h ) kindly message me in the chat box , I will be available Thanks , Raghad
$35 USD in 2 days
5.0 (2 reviews)
1.0
1.0
User Avatar
Yo! I am skilled writer with the vast skills and qualifications necessary for this job. I have experience in Excel Macros, Visual Basic, Excel and Data Processing. I am confident that I can produce high-quality work that meets your specifications. If given the opportunity, I will exceed your expectations. I look forward to hearing from you. Please contact me to discuss more about this project. Thank you Wilfred
$100 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
Hello, I like to work with you i am a expert in make Excel file. I read your concern and it is easy task for me if you can give me a chance i will do your work in your time with best quality work.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there. I am a full stack developer with experience in Visual Basic, Excel Macros, Data Processing and Excel. I have worked with many similar projects. I and my team of developers strive to give our best. Please contact to discuss in detail. Regards
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client, Excel is my game , really very easy project and can finish it in less than two days I have experience in excel more than 10 years with professional courses I teach to who want to learn excel
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Prospective Clients from Netherlands I have read your project and can prepare your Excel file according to instructions. I have excellent skills in Microsoft Office Suite and Google Productivity Tools, thus this place me in best position for the job. Send me the file, and let me do a sample for you for assurance of my expertise. I assure to deliver your job before deadline. I look forward to working with you. Thanks, Afees
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Looking on your work description . I found that I am the best match and skills for this work. Based on my past experiences on Excel, I could do this work with perfection. For a smooth and professional work give this project to me. I am free to talk about this project anytime.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NETHERLANDS
Zwolle, Netherlands
4.9
31
Payment method verified
Member since Jun 4, 2012

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.