+ Reply to Thread
Results 1 to 4 of 4

Need Help - Automatically generate template sheet based on previous data

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    5

    Need Help - Automatically generate template sheet based on previous data

    I currently have a large spreadsheet that multiple people fill out. Each person fills out all the information in a row. At the end of the row, I would like a button that says "Generate Form" so that when clicked, a new sheet automatically opens with a template form that I created and is already filled out with the information that was just inputted into the spreadsheet. Also, there are four different template forms that could generate. For example, there are forms A, B, C and D. If the user inputs "B" into the first column of the row, then when he goes to click "Generate Form", a new sheet is created with all the information filled out in Form B. Any idea if this is possible?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Need Help - Automatically generate template sheet based on previous data

    Are you familiar with VBA?

    If I were handling this I would create the 4 templates and hide them in the background, then when the user pushes GENERATE Form they are asked to input all the data in userform instead of the excel sheets and then the macro will automatically load the data to the table AND the newly generated form.

    One if statement can determine which form to use.


    I suggest breaking this project down into attainable steps and then asking for guidance when you hit a road block because people are not very likely to help you create an entire project from start to finish. They are a very helpful bunch but it is much easier to answer specific questions or solve specific problems, if that makes sense.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Need Help - Automatically generate template sheet based on previous data

    Thanks for the advice!

    The thing is with our application, the user does not always have all of the information at the beginning. So he might input a few things, then a day later, add some more things, then generate the form in a week. Would this be a problem with this approach?
    Last edited by gpukchar; 04-17-2014 at 12:16 PM.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Need Help - Automatically generate template sheet based on previous data

    So with that being said I would make sure to validate what rows HAVE and have NOT had a form generated, but that should be fairly easy and you can even use conditional formatting to tell the user that they are still needing it to be completed.

+ 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. Macro/VBA Code to Automatically Generate a Label Template
    By cxr5009 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2013, 08:14 PM
  2. Generate another sheet with matching numbers from previous
    By ukphoenix in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2012, 11:18 AM
  3. Replies: 0
    Last Post: 07-12-2012, 12:03 PM
  4. Automatically Generate Data Sheet
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2012, 10:07 PM
  5. Generate new sheet and transfer previous total
    By itsunclebill in forum Excel General
    Replies: 3
    Last Post: 02-29-2008, 12:03 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