+ Reply to Thread
Results 1 to 3 of 3

Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data

    This is beyond my current VBA expertise having never worked with userforms before and I can't find anything similar on the internet.

    I have a spreadsheet that is updated weekly -- but every week new info is added that needs a user to input corresponding info. I use a vlookup function to link to another spreadsheet that populates the info from previous weeks and the info that is missing shows up as #N/A...

    First I was using a msgbox function to get the info:

    HTML Code: 
    But it can be up to 30 different new employees... and that is time consuming.

    I would like to make it more user friendly by creating ONE userform that displays all of the employees as labels -- has a text box in which to put the ID # -- and then has a drop down box to choose the type of employee (2 options). I want all of that info to go back to the reference spreadsheet so it will be saved for following weeks, and then redo the vlookup to get the info into the new weekly spreadsheet (I can do that part)....

    I'm completely stumped on it though... the code I have so far is pitiful:

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data

    Can you post a sample workbook of what you have?

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data

    Duplicate post

    http://www.excelforum.com/excel-prog...sing-data.html

+ 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. Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data
    By roxybethany in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2014, 12:08 PM
  2. [SOLVED] Pull data from one sheet to another based on multiple criteria
    By thestalkycop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 01:38 AM
  3. Pull ranked data from another sheet based on one cells criteria
    By murphyjeff08 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-19-2013, 11:51 AM
  4. Pull data from one sheet to another based on criteria
    By lowrymike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2013, 12:53 PM
  5. [SOLVED] Pull data from another sheet based on certain criteria
    By steve_sr2 in forum Excel General
    Replies: 1
    Last Post: 02-23-2006, 06:15 AM

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