RE: Converting to an efficient set of tables

Note: I forgot to include this in my original post.

Another possible solution I thought of is to use the "Replace" feature in
the Edit menu. Tell it to search for "LOS ANGELES CA" and replace it with
=Sheet2!B4 (for example) where cell B4 in Sheet 2 contains the same value,
"LOS ANGELES CA". Would there be a way to perform hundreds or thousands of
these "Replace" actions through VBA rather than manually doing so one by one?
If so, I'd appreciate knowing how since I have no idea.
.