Forum Discussion
How to create many (a lot of) tabs that copy the info from the worsheet
I am making data sheets on the rooms of a building. There are hundreds of rooms, and i need individual sheets for each one. So I have the first sheet made (like a template) that I need to copy over m...
Hi,
To create a new sheet based on a template and order it, you can use this macro below and https://www.excel-easy.com/vba/examples/add-a-macro-to-the-toolbar.html so you can reach it quickly:
Sub AddSheet()
Sheets(1).Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = "Room" & Sheets.Count - 2
End Sub
Note: this macro supposes that the first sheet is the template and the second is the Index.
Also, it names the sheets like the following order: Room1, Room2, Room3...
With regard to the Index page, you can use the solution that explained in this https://www.techrepublic.com/article/use-index-sheets-to-quickly-navigate-in-an-excel-workbook/# to do so.
Anyway, I've done all this in the attached workbook as an example of what you are asking for.
Hope that helps