Create a defined name from the range $$A$2$:H$51$ automatically, using the city names in the left column as the range name. This will create a named range for each transaction.