Copy Template Worksheet to Multiple Worksheets and Incrementally Number Sheets in Workbook

Guys,

I have what is probably a simple request to all the VBA experts out there, and simply want to take a template sheet in a workbook and copy it across to 100 sheets numbered/named 101 -200, and add the name of each sheet as a text reference, e.g. sheet name 101 will have a cell within the worksheet that refers to sheet 101.

I have attached a simplified spreadsheet which indicates what i'm trying to achieve.

Thanks in anticipation

Dingbat.

Maybe:

Please Login or Register  to view this content.

John,

All works OK, but need the worksheets numbered in ascending order, at the moment the numbering starts at 200.

Thanks

dingbat

Change your i's

Please Login or Register  to view this content.

John,

Thanks for the quick response, but for some reason this does not seem to work, and running the macro now does nothing.

Thanks

Dingbat

Try:

Please Login or Register  to view this content.

John,

Excellent, all working OK.

Thanks

dingbat

You're welcome. Glad to help out and thanks for the feedback.