I have a sheet of client data. On a separate sheet I have a button that updates the client data (Add/amend/Delete). Once the data is altered, I also update the named ranges on the Client Data Sheet with VBA code.
I have 3 named ranges: Company List, Legal Name, and Client Data.
The problem I...