Build macro(s) to create new worksheets based on a template

Our small nonprofit PTA group is a part of a consortium of community organizations in Shoreline, WA that hold a Back to School event every August for approximately 1000 kids and 500 families. We use an online database for registration and then export this data into Excel for additional processing.

We have an existing Master Family Template worksheet in our workbook along with a Master List where each registered family has their own row.

Each of the 500+ families needs their own sheet (with their specific info) to be created and printed in advance of the event. We are looking for a Macro or Macros that will do the following:

1. Create one unique sheet (500+) for each registered family that is named after the family's last name (and will have error checking for duplicate last names). Ideally, this Macro could be run for all of the existing families already registered (there's about 350) and have the ability to add new family sheet when new families are added.

2. Each newly created family sheet will recreate the existing Master Family Template.

3. Each newly created family sheet will input the specific family's Family Number into their respective family sheet so this doesn't have to be done by hand and all of their unique data will flow into their sheet.

4. Finally, all of the 500+ family sheets will be sorted alphabetically within the workbook.

We would need the macro work successfully by August 7th.

Skills: Excel, Visual Basic, Data Processing, Excel Macros

See more: excel macro to create new workbook based on value in cells, excel vba create new sheet with name from cell, excel macro create new sheet and rename, excel vba create new workbook and copy sheets, excel macro create new sheet from template, excel vba create new workbook and name it, excel vba create new workbook from template, vba code to add new sheet in workbook, create div based template, build website based template, create new magento mods / enhancements to the template (beanstalk / git), create new powerpoint template, create your company logo using our online logo design tool http www designimo com create logo, Customize or create new responsive template , Create and deliver PPT Template and new LOGO, I have floor plans for apartment villa\ s. Would like to create new interactive floor plan that can change floor coverings, cab, prestashop create new email template, excel macro create new workbook with name, grav create new template, create new template magento 2

About the Employer:
( 0 reviews ) Shoreline, United States

Project ID: #26578566

Awarded to:

(790 Reviews)

40 freelancers are bidding on average $154 for this job

(950 Reviews)

Dear Employer, I am an Excel expert and have been working on process automation projects since a decade now. Please consider me for this job, I will deliver a highly professional project. My previous reviews on simi More

$250 USD in 7 days
(205 Reviews)

Hi, Greetings! ✅checked your project details: Build macro(s) to create new worksheets based on a template ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience More

$180 USD in 3 days
(390 Reviews)
(268 Reviews)

(413 Reviews)
(191 Reviews)

Greetings! Thanks for very detailed and clear requirements. I can develop a macro that would use the predefined template to generate filled Worksheets (one for each family) and sort the worksheets in alphabetical orde More

$70 USD in 2 days
(220 Reviews)
(280 Reviews)
(60 Reviews)
(165 Reviews)

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write More

$200 USD in 5 days
(118 Reviews)

Hi, I have gone through the project requirement and as I understand you need 500+ sheets to be created based on template using Excel macro. Keen to work on this. With my extensive experience on Excel and macros. i ca More

$100 USD in 7 days
(109 Reviews)
(95 Reviews)

I am a full time freelancer providing automation consultancy to SME / MSME companies. I can develop an excel based automated family management tool to manage 500 or more family's details, we can complete this work even More

$250 USD in 5 days
(43 Reviews)

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel macros. More

$120 USD in 5 days
(52 Reviews)
(18 Reviews)

Hi Kim. I am a Excel macro and vba developer with 6+ years of experience. I have worked on several similar projects create and combining multi macro functions and can deliver quality notes to tight deadlines. You can s More

$500 USD in 2 days
(5 Reviews)

Hi There, I have understood your requirement & I can provide you with macros to deliver all the 4 tasks mentioned. I can deliver this before 7th August. I am a Macros & Excel Expert with more than 5+ years of exper More

$200 USD in 7 days
(6 Reviews)

Hey, I can help you in Building Macro to create new worksheets based on template In how much time you want it to be completed???? Let's talk upon your project Waiting for your response!!!

$30 USD in 1 day
(12 Reviews)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$80 USD in 1 day
(18 Reviews)