+ Reply to Thread
Results 1 to 1 of 1

Creating multiple forms with auto-populated fields, data validation and excel tables

  1. #1
    Registered User
    Join Date
    10-01-2015
    Location
    DC
    MS-Off Ver
    2013 Pro Plus
    Posts
    22

    Post Creating multiple forms with auto-populated fields, data validation and excel tables

    Hi,


    So I have this problem. I would like to create multiple forms from a master worksheet which will basically do the following:

    1. Select a range of names manually to be used later as new worksheet names (Selection)
    2. Go to the master worksheet "MasterForm" which contains two excel tables (forms)
    3. Change the cell A1=A1+1 that is if A1 was 1 now it should be 1+1=2 (This will change the auto-populate fields in the forms
    4. Create a copy of the MasterForm rename with the next name in the Selection (step 1)
    5. Break the links in the auto-populated fields in the form by copy+paste values
    6. Repeat 2-5 until end of the Selection (step 1)

    Below is the terrible code I wrote, a frankenstein made of two other codes. The caveat of doing so manually is that because the worksheets contain excel tables you cannot do batch edits across
    the tables and only one-by-one.

    HTML Code: 
    Last edited by gilliamwibson; 02-18-2016 at 04:30 PM.

+ 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. Creating multiple standard forms with different data
    By michael.adams2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2016, 10:10 AM
  2. [SOLVED] Create Auto Populated list Field based off multiple fields
    By alendor in forum Excel General
    Replies: 4
    Last Post: 04-22-2014, 11:38 AM
  3. Filter multiple columns based on multiple data validation fields
    By Jhunnieboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2014, 03:41 PM
  4. Replies: 1
    Last Post: 03-19-2013, 09:57 AM
  5. Replies: 1
    Last Post: 03-19-2013, 09:18 AM
  6. Auto-Creating Tables from raw data?
    By CrayzCrinkle in forum Excel General
    Replies: 8
    Last Post: 09-04-2012, 11:24 AM
  7. Creating populated forms from a spreadsheet
    By antony-ryan in forum Excel General
    Replies: 4
    Last Post: 09-18-2008, 09:38 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