+ Reply to Thread
Results 1 to 2 of 2

How to create sheets as per List on 1st sheet

  1. #1
    Forum Contributor
    Join Date
    02-10-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2016
    Posts
    164

    How to create sheets as per List on 1st sheet

    Hi guys!

    I have to create sheet for Items and i have 90 Items. Is there any way to auto create sheets with item name as per List in Sheet 1.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: How to create sheets as per List on 1st sheet

    Create pivot table from listed names.
    Use that list in Report Filter (named List in this example).
    In Option Tab, under Option menu choose Show Report filter pages (See picture)

    Untitled.jpg

    When prompted choose that List field to create sheets with each name.
    If you want and you create some Pivot table fields they will be transfered there too.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically create sheets from list on sheet 1
    By Jason.Donnell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-15-2016, 03:22 PM
  2. [SOLVED] Create Sheets and copy rows to the Sheets if cell contains sheet names
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 08:06 AM
  3. Replies: 3
    Last Post: 10-01-2014, 01:49 PM
  4. Trying to Create Running List on Sheet 1 from info in Sheets 2-5
    By Melissitchka in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 03-28-2014, 12:45 AM
  5. [SOLVED] Macro for searching on sheet 1 with data from sheet 2 and create new sheets
    By stitchoz in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 03-03-2014, 12:25 PM
  6. Replies: 17
    Last Post: 02-01-2013, 12:20 PM
  7. How to create first sheet as a list of names of remaining sheets?
    By datanull@gmail.com in forum Excel General
    Replies: 4
    Last Post: 05-28-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1