Auto Generate and name Worksheets from a list

Solved/Closed

E-Coli - Sep 2, 2008 at 02:33 PM
Gagan - Apr 3, 2017 at 10:47 AM

Hello,

How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begins at cell A10. Mind you, this list will vary from workbook to workbook. Do you have some code already compiled to perform this?

E-Coli

Excel auto create tabs from list
Grand theft auto v free download no verification for pc - Download - Action and adventure
How to stop facebook from auto refreshing - Guide
Grand theft auto iv download apk for pc - Download - Action and adventure
Create skype account with gmail - Guide
Counter strike 1.6 cheats list - Guide

2 responses

Answer 1 / 2

Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Sep 6, 2008 at 01:26 AM

Hello E-Coli,
apparently my tips did not help you.
anyway, here is a solution :

Sub CreateSheetsFromAList()
    Dim MyCell As Range, MyRange As Range
    
    Set MyRange = Sheets("Summary").Range("A10")
    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

siva
Oct 22, 2009 at 01:10 AM

please let me know where exactly script shouldbe done becus I am not familiar with macros but I would like to create sheet name for about a year datewise from the month of NOV 2009 in a single work book or atleast for a period of 3 months

pls reply immdtly

thanks

Glossophobe
Nov 4, 2010 at 11:06 AM

This was beautiful - Than you E-Coli and Ivan-hoe!

Answer 2 / 2

tuta
Mar 25, 2009 at 03:00 PM

Hi

It was really useful your formula but I would need the others worksheets to be equal to the first one. I've trying to do it but I wasn't able to do it. Can you help me one that?

subop
Jul 31, 2013 at 06:13 AM

Sub AutoAddSheet()

Dim MyCell As Range, MyRange As Range

Set MyRange = Sheets("Summary").Range("A10")
Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange
Sheets(9).Copy After:=Sheets(Sheets.Count) 'Create a new worksheet as a copy of Sheet number 9 in this example
Sheets(Sheets.Count).Name = MyCell.Value 'Renames the new worksheets
Next MyCell
End Sub

ramkyc
Sep 22, 2013 at 07:38 PM

Hi subop and Ivan, Excellent solutions! How do I create a worksheet containing the names of the worksheets in the book? Against each worksheet name, I would like to display the content of cell K2 of each of those worksheets.

TIA
Ramakrishna

RT
Apr 17, 2014 at 12:00 PM

Helo,
I was wondering if it is possible to add a "hyperconnection" (klickable link) between the name in the list and the worksheet whit the same name?

So that when you crate a new worksheet it also adds a connection between the list and the new worksheet. Easyer to navigate between the worksheets, if the list is long, this way.

Hope to get som e help on this topic.

RT

DIL2040
Mar 4, 2015 at 03:08 PM

Good one. I tried this and since my summary tab had 300 records, there were 300 sheets created. Now how do I remove those sheets and restrict it to only 10. I dont want to create a new excel sheet as sooner or later I would need the command for removing the sheet automatically like creating.

Similar discussions

Generate excel workbooks based on excel list

Hello,

I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel. So if column A says 'AC.334.997' and column B says 'Process improvement project', it would generate workbooks based on the template - in this case named 'AC.334.997_Process improvement project', and so on.

Any help would be much appreciated!

Thanks,
Matt.

Configuration: Windows 2003 / Internet Explorer 7.0

Create multiple copies of excel based on a single template

Hello there,

I need your help.

I need to create multiple excel workbooks using a single template and saving them based on a list of names which is on another excel.

I also want the template to reflect the respective name in one of the cell (say in cell A2).

Can this be done using macro?

Thank you in advance.

Search a list of names at one time in excel

Hi,
I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is it possible to enter all the names in list A and search it against the list of names in list B in one go? List A and list B are saved in separate excel sheet files

Thank you
Priya

macro to compare two excel sheets

Hello,

I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet.

The number of rows and columns may not be equal and it can vary each time. So, we need to find the range of columns and rows first. I am struggling with this.

I tried the following code to compare the values,
Sub Macro7()
'
' Macro7 Macro
' Macro recorded 12/11/2008 by UBOC User
'
'
Range("A2").Select
ActiveCell.FormulaR1C1 = _
"=IF(SIT!RC=PPE!RC,"" "",CONCATENATE(SIT!RC,"" - "",PPE!RC))"
Range("A2").Select

How to specify macro for current active sheet

Hello,
this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selected. How do I do this? For example, I have a sortZip Macro that I want to run on several worksheets when I hit the RUN button but it only works on the worksheet that I originally created the macro on.

I would really appreciate your advice on this!!! - Please :D

Code is:
Sub SortZip() ' ' SortZip Macro ' ' ActiveWorkbook.Worksheets("GilbertApril09").Sort.SortFields.Clear ActiveWorkbook.Worksheets("GilbertApril09").Sort.SortFields.Add Key:=Range( _ "H2:H390"), SortOn...

Comparing two excel worksheets

Hello,

I am trying to find an easy way to compare and extract data from two excel worksheets.

This is the scenario.. I have an excel worksheet with a list of employee names and their relevant information. I have another excel worksheet with a list of employee names that have accounts in a system. I would like to know what employee doesn't have an account in the system and what account in the system needs to be removed because they are no longer in the employees list? Follow?

thanks
K

Similar discussions

Subscribe To Our Newsletter!