Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Create new sheet and copy data in VBA

0

Hi 

I am facing problem in doing below things

District Name        School Name          School Address

Balasore               ABC                           123456789

Balasore               DEF                            5627905970

Balasore               GHI                             5409805100

Bhadrak              JKL                               517084870807

Bhadrak              MNO                            545404878079

I have the data in above format, i want to do following things in VBA

According to district name new sheets to be created and renamed to district name 

and copy the school name present in that district

So for above example

there will be 2 sheets created and renamed to 1. Balasore and 2nd Bhadrak

in Balasore sheet All the school present in balasore wil be copied

So Balasore sheet will look like

District Name        School Name          School Address

Balasore               ABC                           123456789

Balasore               DEF                            5627905970

Balasore               GHI                             5409805100

and Bhadrak sheet will look like

District Name        School Name          School Address

Bhadrak              JKL                               517084870807

Bhadrak              MNO                            545404878079

Kindly help me with VBA code

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login