+ Reply to Thread
Results 1 to 1 of 1

UserForm that Crosschecks Multiple Sheets to ensure Data Matches entry.

  1. #1
    Registered User
    Join Date
    02-05-2019
    Location
    St. Louis, MO
    MS-Off Ver
    365
    Posts
    13

    UserForm that Crosschecks Multiple Sheets to ensure Data Matches entry.

    I have a workbook that I have used macros to take data from 4 separate sheets (Client Contacts, Client Export, Client Users and Partner Users) and place them into sheet "Import". I would like a user form for the user to spot check the results in "import" by checking the other sheets to ensure the data matches. If the data matches I would like some sort of approved popup, and if there is an issue I would like a warning popup.

    The fields I need to have checked are all in "Import". These fields could have been pulled from any of the above mentioned sheets.

    It would be even better for the popup to randomly pick 3 lines for the user so they don't have to type anything in.
    Last edited by Paul; 09-26-2019 at 01:17 PM. Reason: Removed attached file due to contents (sensitive/private information).

+ 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] Validating data entry to multiple textboxes in a userform
    By AJalal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2017, 05:19 PM
  2. Data Entry Form with multiple sheets
    By nimesh29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 01:04 PM
  3. Comparing Data between sheets to find matches and no matches
    By tysont in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2015, 03:07 PM
  4. Edit VBA Userform code to run if only 1 entry that matches criteria
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-24-2013, 05:25 AM
  5. Data entry over multiple sheets
    By ajlo in forum Excel General
    Replies: 6
    Last Post: 09-05-2011, 07:52 PM
  6. conditional format to ensure data range matches
    By tuizner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2010, 06:41 AM
  7. Userform data entry into hidden sheets
    By Pedros in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2006, 11:55 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