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.
Bookmarks