+ Reply to Thread
Results 1 to 5 of 5

Create Sheet Templates based off Data Validation Entry

  1. #1
    Registered User
    Join Date
    07-15-2020
    Location
    RI, USA
    MS-Off Ver
    16
    Posts
    1

    Question Create Sheet Templates based off Data Validation Entry

    Hey All, New here and looking for some help. I am trying to create a sheet that is a template of information I need to collect from a customer. This would be used many times over so I need to be able to select what products they ordered from a dropdown box (which I have working) but then using that selection create a template that asks the customer to fill in information I need to gather. So for instance if they buy a product called fruit i need a tab that says fruit and on it there is a table that says "custom order name, Contact, Phone number, Address, Where you want fruit delivered" this would be a table they could fill out but it would only exist if they first chose fruit. (this is an example not my actual use case.) any help is appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    817

    Re: Create Sheet Templates based off Data Validation Entry

    Hello Md,

    I don't totally follow what you would like to do but here's a starting point:-

    Please Login or Register  to view this content.
    This code will create new sheets from a template sheet based on a value selected from a drop down in cell A1.
    It is a Worksheet_Change event code and needs to be placed in the Template sheet module. To implement this code:-

    - Right click on the Template sheet tab.
    - Select "View Code" from the menu that appears.
    - In the big white code field that then appears, paste the above code.

    It is an event code so as soon as you make a selection from the drop down in A1, a new sheet will be immediately created from the Template and named with the selected value.

    Below, I've attached a mock-up of how this works and should give you an idea of how it could work for you.

    I hope that this helps.

    Cheerio,
    vcoolio.

  3. #3
    Registered User
    Join Date
    07-17-2020
    Location
    New York
    MS-Off Ver
    2020
    Posts
    24

    Re: Create Sheet Templates based off Data Validation Entry

    Hello,
    I am trying to do something very similar. I am fairly new to this. I downloaded your sample file but when I choose an option from the drop down box, nothing happens. I have the fields all filled out but still it does not generate another sheet. Do you know why this could be?
    Thank you

  4. #4
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    817

    Re: Create Sheet Templates based off Data Validation Entry

    Hello Lexi,

    I'm assuming that:-

    1) You've tried the code in your own workbook.
    2) You've placed the code into the Template sheet module as per post #2.

    It's somewhat difficult to determine why without seeing your workbook (a sample thereof). Read the gold coloured banner at the top of this page which gives instructions on how to upload a sample file.

    If you haven't tried it in your workbook and you're just working with the sample in post #2, on opening the sample, have you disabled the security settings?

    You should receive two warnings (gold coloured bar at the top of the sheet):-

    1) Protected View --->Click on the Enable Editing button.
    2) Securitry Warning--->Click on the Enable Content button.

    This will allow you to work on the sample.

    Cheerio,
    vcoolio.

  5. #5
    Registered User
    Join Date
    07-17-2020
    Location
    New York
    MS-Off Ver
    2020
    Posts
    24

    Re: Create Sheet Templates based off Data Validation Entry

    I hadn't placed the code into the template sheet... I guess I was a little too eager. This is along the lines of what I am trying to do with a bit of an alteration. I just posted a forum if you would like to check it out and help I would much appreciate it.

    Thanks!

+ 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. [SOLVED] Create Error Message for Data Entry Validation
    By HAJANISHA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-25-2020, 10:07 AM
  2. [SOLVED] Create Table based on data entry in cell
    By cobbrjr in forum Excel General
    Replies: 9
    Last Post: 06-12-2018, 12:20 PM
  3. [SOLVED] How do i create a list on a sheet, based on an entry in a matrix
    By cumiskeya in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2016, 10:41 AM
  4. Replies: 3
    Last Post: 12-18-2015, 03:16 PM
  5. Auto-Populate cells based on data validation and free-form entry
    By Tawana127 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-17-2013, 02:32 PM
  6. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM
  7. Validation based on data entry
    By numberwang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2009, 04:00 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