+ Reply to Thread
Results 1 to 2 of 2

Create New Sheet From Selected Data

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    20

    Create New Sheet From Selected Data

    Hi There, can't seem to figure this one out. I am in need of a macro that uses a command button that once clicked generates a new sheet named "Testing" which has predetermined questions in the first column and user inputted data from "Sheet1" in the second. I am more so in need of the general setup so the questions and answers aren't particularly needed but I will give a sample format of what I'd like to happen.

    Sheet1:

    G50 = 45 Series
    G52 = 80 Feet
    G57 = Single
    K29 = Dual

    Testing:

    Column A Column B
    Which Series Toolbar: G50
    What Width: G52
    Front Caster: K29
    Rear Axle: G57


    Ideally I would need several cases, If G48 = "Tank Only" then the new sheet would be listed as "Tank Testing" if G48= "Toolbar Only" then the new sheet would be listed as "Toolbar Testing" if G48= "Tank & Toolbar" two sheets are created "Tank Testing" and "Toolbar Testing" each having its own set of predetermined data with different user input cells from sheet1. I hope this is clear enough. Thanks
    Last edited by UnreadSix; 02-27-2014 at 01:09 PM.

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Create New Sheet From Selected Data

    I should mention that all values on sheet1 required are drop down lists

+ 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. Trying to create a new sheet based on column headings selected
    By davidhale87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 01:47 PM
  2. Replies: 3
    Last Post: 06-30-2012, 06:44 AM
  3. create sheet on tree view selected node
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-27-2011, 03:01 AM
  4. Create new sheet based on date selected (userForm)
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2011, 04:03 PM
  5. How to create a summary sheet that returns user selected data
    By nalmarri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2008, 03:53 AM

Tags for this Thread

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