Creating a Custom Data Entry Form to Update Multiple Excel Records at Once

Here's an example.

You can filter the data using the comboboxes
Click on an item in the Listbox to populate the TextBoxes

I would suggest you add a column to contain a unique transaction ID this will then make it possible to write the textboxes contents to the sheet.

Edit: I have added reference numbers & code to amend the entries