Results 1 to 2 of 2

Creating multiple standard forms with different data

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2015
    Location
    VA
    MS-Off Ver
    2010
    Posts
    30

    Creating multiple standard forms with different data

    Hello,

    I am hoping someone could please help me out.
    I need to create multiple standard forms with data that I fill in on a separate tab.

    On my Entries tab (from attached file) , I enter various information in (Jim Jones, Mary Smith, Adam King).
    These entries need to be put in my BSM tab (has to be in this format) and I need one BSM tab for each entry. (BSM tab for Jim Jones, separate BSM tab for Mary Smith, etc.)

    The issue I am having is when the headings from the two tabs are not in the same order. BSM tab will always be in this format, but the Entries tab data might change columns (ie first name will be in different column going forward).

    Basically I am looking for a VBA lookup function to match columns from Entries tab and put them in the BSM tab for multiple forms.
    Any help would be greatly appreciated
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need to create multiple standard forms with different data
    By michael.adams2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2016, 09:49 AM
  2. Creating standard deviations with complicated data set
    By mounstahman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2015, 02:52 PM
  3. Creating short forms for multiple codes
    By vgr in forum Excel General
    Replies: 7
    Last Post: 07-19-2014, 08:37 PM
  4. Creating forms with multiple dropdown lists
    By AnnaDana in forum Excel General
    Replies: 3
    Last Post: 06-28-2013, 02:54 PM
  5. [SOLVED] Creating Forms, but jumping data?
    By mistereun in forum Excel General
    Replies: 15
    Last Post: 06-11-2013, 10:37 AM
  6. Creating standard reports from a excel data workbook
    By salma2009 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2013, 07:09 AM
  7. Help creating multiple user entry forms into a database
    By jacobkmc in forum Access Tables & Databases
    Replies: 2
    Last Post: 03-12-2012, 12:05 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