Creation of sheets based on data in cells

Some times we need to create sheets based on predetermined cell values\names

Through this program we can create work sheets (in new work book) with our required names which is pre-determined in worksheet

For better understanding\to provide the hold on looping procedure i have provided examples with 4 types loops., all the four gives same results but they are different programs.

For - - -Next Loop

J denotes about number of sheets count required to create based on value in cells

i denotes Loop variable among the created sheets, it is very much useful to rename sheets, whatever the value\text exists in predetermined cell value

For Each - - -Next Loop:

Do While Loop:

Do Until Loop:

Download The Workbook