Find Jobs
Hire Freelancers

VBA - Excel Template File - Create and Save as New File

£20-250 GBP

Closed
Posted over 4 years ago

£20-250 GBP

Paid on delivery
We have a master template/cutting list file, that we currently manually update around 10 cells. Then we save as ‘Product SKU’. However we have another excel workbook that contains an organised list of Product SKU and all the variables that need to be inputted into the master template. We required code written to: Lookup the list, then One row at a time, import SKU, product variables, updating the master file. Finishing with a Save As “Product SKU”. Leaving us with Multiple Workbooks, one workbook for each Product SKU.
Project ID: 23559653

About the project

52 proposals
Remote project
Active 4 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
52 freelancers are bidding on average £109 GBP for this job
User Avatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£135 GBP in 3 days
4.9 (165 reviews)
7.6
7.6
User Avatar
Hello, I am an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£100 GBP in 2 days
4.9 (419 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can create a tool (xlsm file) that will allow you to generate the output you want. The tool will be completely reusable every time. Contact me to discuss the details. Best regards
£100 GBP in 3 days
5.0 (291 reviews)
7.2
7.2
User Avatar
Greetings! I understand the requirements. I can implement an Excel based solution - at the click of a button, user would be prompted to select the input file (with organised list of Product SKU ). The macro would then use this data to update Template file and generate individual Product SKU files automatically. Please share template file as well as sample input file. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
£80 GBP in 2 days
5.0 (227 reviews)
7.0
7.0
User Avatar
I can provide you a VBA procedure that will read a list of SKUs and other variables from your Excel workbook, fill your template file and save it. I can complete it in less than a day for just £90 and all I need to start is some samples from you. Thanks. Roman
£90 GBP in 1 day
5.0 (210 reviews)
6.8
6.8
User Avatar
Hello there, I am an Excel expert and I can create this script for you. Please share with me your sample master data. As your description, project can be done within 4 hours I think. Thank you.
£80 GBP in 1 day
5.0 (211 reviews)
6.5
6.5
User Avatar
Hey, I am an expert in Excel and have delivered more than 500 projects successfully here on Freelancer itself. Several of those have been vba scripts built custom as per client requirements. I can build the desired macro for you. Can you share some data that you may have compiled and I would be able to share my thoughts on how it may be built. If you could send a message to me, we may discuss how we could collaborate. Look forward to hear from you. Best Regards, Rishi (Automyze Consulting)
£185 GBP in 7 days
4.9 (184 reviews)
6.7
6.7
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
£135 GBP in 2 days
5.0 (132 reviews)
6.6
6.6
User Avatar
£ 23 Only ------ Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* rattings ------ I can start right now, please message me to discuss more.
£23 GBP in 1 day
5.0 (160 reviews)
5.8
5.8
User Avatar
Hi, I can create the excel VBA scrit that you need to import SKU details, fill the template and save the file with SKU name. Best regards, Florin Enache
£150 GBP in 3 days
5.0 (22 reviews)
5.3
5.3
User Avatar
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
£135 GBP in 7 days
4.7 (33 reviews)
5.8
5.8
User Avatar
Hello, I am an Australian-based software developer with significant experience in writing customised VBA applications. I am certain that I can achieve your exact needs within minimal time. I have previously worked a lot with file management and data matching/sorting...and will easily be able to adapt previous solutions to work in your specific circumstances. In order for me to complete the job, I will require a copy of the files that you need processed, an example of one of the Product SKU files (that you have manually created in the past) and answers to the following questions: 1) Will this VBA solution be deployed on Windows or Mac or both? 2) Will the files all be in the same folder as the template file? Or are they located in another folder? If you have any questions at all, please feel free to reach out via Private Message.
£50 GBP in 2 days
5.0 (27 reviews)
5.6
5.6
User Avatar
Hi, I will ad a new tab in your Template workbook named as "setting", in this setting you will have a "Generate" button, that run a VBA program which will open the other Excel book that contains products SKU and will go through each line of that work book and will copy past data of each product SKU in your template file and then saving it in destination folder so will be one workbook for each product SKU in that folder. (the path of data workbook and destination folder can be managed in the setting tab). Please send me message to discuss more.
£150 GBP in 2 days
5.0 (13 reviews)
4.9
4.9
User Avatar
Hi Good Day! A serious freelancer here. I can create you an automated tool that can consolidate all your excel file to master file. I am willing to help you out and show you my expertise. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability and knowledge to help you. Thank you!
£50 GBP in 1 day
4.9 (48 reviews)
4.8
4.8
User Avatar
Hi I have very good experience working with XL and creating VBA macros to get the correct information and results. I can do this work on time and quality. Regards. Reuben
£30 GBP in 2 days
5.0 (19 reviews)
4.9
4.9
User Avatar
Hello, I can help you with your project - VBA - Excel Template File - Create and Save as New File I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. https://www.freelancer.com/u/whitehorsetechn?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, vibrantwebtech Ramesh
£180 GBP in 2 days
4.8 (14 reviews)
5.3
5.3
User Avatar
Hello.... I can do it perfectly ....and i also want to start it now...... Please give me a chance to work with you ...I promise the accuracy of work will be definitely 100%......promise you will not found a single mistake in my work.... Give me the one and only chance for your work.... You will get your work delivered in given time.... Chat me to discuss the details so that i can start the work ASAP Thank you.
£20 GBP in 1 day
5.0 (19 reviews)
4.2
4.2
User Avatar
Hi There I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your project. I will provide an efficient, robust and well documented solution with dedicated support. I will anticipate to discuss the details to get started. Thanks Farah Saif
£250 GBP in 7 days
5.0 (31 reviews)
4.3
4.3
User Avatar
I can do the job! Task sound straight forward, we would only need to specify the functionalities you require for your template file. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
£150 GBP in 7 days
5.0 (25 reviews)
4.4
4.4
User Avatar
Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros on a daily basis. I will be able to assist create a vba macro to help you copy the cells and transfer to the master file. Please contact me for more information. Thank you!
£35 GBP in 1 day
5.0 (11 reviews)
4.1
4.1

About the client

Flag of UNITED KINGDOM
Maidstone, United Kingdom
0.0
0
Member since Jan 25, 2020

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.