To better understand I want to provide an example.
Looking at the sheet I provided, I am looking to fill any cells with the owner name missing. For example, Jessica has 3 cars, each listed with her Owner ID, but not all cells are filled with the owner name. I am looking to find a way to automate the process where, if a an ID matches with a name, it will populate all cells associated with that ID. There are also some that have the name scattered about such as Len's. Some IDs also do not have a name to be matched with because there is no data for their name.
If there is a row, with a name and ID #, I want all rows that have that ID # to populate the owner's name associated with it.
So ideally any row that has the ID # 123 in it should automatically fill the Owner name to Jessica in this example.
Let me know, thank you.
Bookmarks