I have a file "Zone A" with two tabs "old" and "new" see attached.
The "old" tab has Lat and Long in columns D & E whereas tab "new" does not. I need to match the incident#'s in "old" and "new" and when they match, then Lat and Long from "old" to be added to tab "new" in the columns named Lat and Long columns ( blank now in "new")
If incident#'s in tab "old" does not match to incident#'s in tab "new", then leave Lat and Long blank for the incident#'s in tab "new".
Bookmarks