+ Reply to Thread
Results 1 to 1 of 1

Create automatically new sheet based on main data sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    07-24-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2000,2003,2010
    Posts
    38

    Create automatically new sheet based on main data sheet

    Sheet # 1 = "DATA" is my data file


    Work-Order Item-1 Item-2 Item-3 Item-4 Item-5
    X X1 X2 X3 X4 X5 >>>> First line of data
    Y Y1 Y2 Y3 Y4 Y5 >>>> Second line of data
    Z Z1 Z2 Z3 Z4 Z5 >>>> Third line of data



    I would like to create automatically new sheet as my work order which is cell A3= X. sheet name should be "X".
    Data populated on my new created sheet should be from the second line of data as follow.

    Item-1 X1
    Item-2 X2
    Item-3 X3
    Item-4 X4
    Item-5 X5

    As soon as I entered my next new work order in cell A4, new sheet A4="Y" should be created
    Data populated on my new created sheet should be from the Third line of data as follow.

    Item-1 Y1
    Item-2 Y2
    Item-3 Y3
    Item-4 Y4
    Item-5 Y5

    As soon as I entered my next new work order in cell A5, new sheet A5="Z" should be created
    Data populated on my new created sheet should be from the fourth line of data as follow.

    Item-1 Z1
    Item-2 Z2
    Item-3 Z3
    Item-4 Z4
    Item-5 Z5

    How can I do this?
    All help appreciated.
    Last edited by manharji; 10-05-2016 at 11:22 AM.

+ 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. Replies: 1
    Last Post: 09-04-2014, 12:59 AM
  2. [SOLVED] Display data from sheets based on value in a cell on main sheet.. Help!
    By cpyter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2014, 02:20 PM
  3. Pull data from multiple sheets based on cell in Main sheet
    By cpyter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 01:19 PM
  4. Replies: 5
    Last Post: 02-09-2014, 08:29 PM
  5. Replies: 0
    Last Post: 03-04-2013, 03:25 PM
  6. Create copy of multiple worksheets and automatically fill in data from a main sheet
    By NMChemEng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2008, 05:28 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