|Macro for create no. of sheets which will be taken from active sheet, cell - A1 to A9/10/etc(Until the cell is empty). I can create macro for create a sheet. but i am not able to create many sheets as i expect.|
Workbook has 2 sheets named, 'Sheet1' and 'Sheet2'.
Sheet2 is a template for all the sheets to be created.
In Sheet1, I may enter values (Sheet names to be created) for any no. of cells. If i enter a1 to a10 then ten sheets should be created, if i enter 20 then twenty sheets need to be created.
Pls help me on the same.