Sheet 1 is small sample of my updated list of cities. I am needing to pull the information that correspodns with each city from Sheet 2 which is a small sample of the information I need to populate my list with. I have used some random names and information for testing purposes.
Sheet 1 I have Albuquerque with blanks for Contact and the various other headings, in Sheet 2 I have Albuquerque with all the information I need in sheet 1.
How can I pull the information over into sheet 1? The Citys which are not represented with data will be populated with another data source file once I am given that information. I need to keep the cell coloring as this will help in the next step of my data sort.
Anyhelp would be great as I have over 27,500 cities.