Example: XLS 1 has one column with 300 rows of city names. The next column has a space for the last date we spoke to our contact in that city (any much more information). XLS 2 has one column with city names and one column with the last date of contact. However, not every city is on the XLS 2 document. So when XLS 2 is ran each month how can I get XLS 1 to update with the date for the date column in XLS 2?
