Closed

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

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.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Data Entry

See more: excel vba save image file, create save data excel file php script, asp net mvc create save csv file, excel vba save text file, read text file save unicode file excel vba macros, save vba excel file rewrite, vba excel create file, vba excel dynamically create form, excel template create workload, create excel template csv file, android app create save midi file, excel vba save mspaint file, mail merge vba excel template, vba excel template generation, create save png file windows

About the Employer:
( 0 reviews ) Maidstone, United Kingdom

Project ID: #23559653

56 freelancers are bidding on average £108 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

£200 GBP in 2 days
(763 Reviews)
8.5
P0L

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
(352 Reviews)
7.4
zekovicm

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 More

£135 GBP in 3 days
(151 Reviews)
7.5
elqueabandona

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 More

£100 GBP in 3 days
(247 Reviews)
7.0
ksriniravi

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 More

£80 GBP in 2 days
(202 Reviews)
6.9
gangabass

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 sta More

£90 GBP in 1 day
(201 Reviews)
6.7
periyannas

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
(115 Reviews)
6.4
shikhamehta

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 ma More

£185 GBP in 7 days
(183 Reviews)
6.7
nvchien94

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
(174 Reviews)
6.2
wsh2

Can do! At your earliest convenience, please attach workbook sample(s) to this private chat message thread so we may better discuss your requirement. Many thanks in advance! Greetings from the USA.. {smile} Highly e More

£135 GBP in 7 days
(55 Reviews)
6.4
SShtv

Hello, I am interested in your proposal and I am ready to solve your task. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of More

£80 GBP in 2 days
(90 Reviews)
6.0
afenache

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
(22 Reviews)
5.3
zu02

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 wo More

£135 GBP in 7 days
(33 Reviews)
5.8
AnowarRatul

£ 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
(78 Reviews)
5.0
whitehorsetechn

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. More

£180 GBP in 2 days
(14 Reviews)
5.2
Sercho56

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 l More

£50 GBP in 2 days
(16 Reviews)
4.8
urmate

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 More

£250 GBP in 7 days
(31 Reviews)
4.3
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

£135 GBP in 2 days
(18 Reviews)
4.5
paulodayto08

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 of More

£50 GBP in 1 day
(37 Reviews)
4.5
arash18k

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 g More

£150 GBP in 2 days
(12 Reviews)
4.4