+ Reply to Thread
Results 1 to 1 of 1

Userform: Save Multiple Rows that Matches Criteria

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    20

    Userform: Save Multiple Rows that Matches Criteria

    Hi, I have an userform - attached - where the user cycles through matched findings, and can save changes directly to INPUT. However, I want to have two different type of saves. One that saves against the target line (one row - identified via unique ID) - as shown in the attached, and another ability to save multiple rows with the same data, if the criteria match (Person ID x Date).

    For example, I want to have a save ability, that allows me to change the txtName (column O) from "Jack" to "Jill", for all rows that have a match of Person ID = a123 and Date 01/01/2018. However, at the same time, if I want to change the Building name (column M), than that change should only apply to the target row (e.g. unique ID G1 - in column N).

    Any help would be appreciated.
    Attached Files Attached Files

+ 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] Save all UserForm data for multiple rows
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2015, 02:22 PM
  2. [SOLVED] Search for multiple rows from multiple sheets by criteria & show result in userform
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-07-2014, 11:29 AM
  3. 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
  4. UserForm updating rows of data that matches a given ID #
    By Guonade in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 10:41 AM
  5. Replies: 6
    Last Post: 03-06-2013, 04:02 AM
  6. [SOLVED] Only copy rows across IF matches criteria
    By Shansy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 10:00 PM
  7. [SOLVED] Copy Rows if first cell matches criteria
    By amq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 11:23 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