Category Archives: IT Topics
Excel: Create Numbered Worksheets
- Open Excel
- Create a Worksheet named Summary
- In Cells A1 to A100 (or less or more ) create the range of numbers needed
- Go to the Developer tab
If you don’t see the Developer tab
- Click the File tab.
- Click Options.
- Click Customize Ribbon.
- Under Customize the Ribbon and underMain Tabs, select the Developer check box.
- Click the Visual Basic Icon
- Delete the code in the Book1 Module1 Window
- Paste in the following Code
Sub CreateSheetsFromAList()Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets(“Summary”).Range(“A1”)
Set MyRange = Range(MyRange, MyRange.End(xlDown))
For Each MyCell In MyRange
Sheets.Add After:=Sheets(Sheets.Count) ‘creates a new worksheet
Sheets(Sheets.Count).Name = MyCell.Value ‘ renames the new worksheet
Next MyCell
End Sub
- Click Run (the Green triangle button)
Calendar 2015 – Use Excel Templates
Great – make your own calendars using Excel templates: http://www.calendarpedia.co.uk/calendar-2015-excel-templates.html