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