Dear Excel Forum experts,
I found an excel file on web that convert from Lat long to UTM ( I attached it ) , I add 2 sheets named UTM and Import from Google earth . I mport from google earth KML files as shown in attached file .
I need a Code to do the followings:
1- When I choose the cities names from column “N” like ( N7, N9 & N10) I want the code to copy each selected cells to the sheet UTM and past them at the last none empty cell in column “G” begins from “G7” as shown in UTM sheet.
2- I want the code to search for each intersection of selected cells and ns1:coordinates in the header row in import from google earth sheet I.e ( X7 =30.97196382996512,28.9608755022139,0 and X9=30.86514631631363,28.94668078011128,0 and X10=30.55340523573598,28.90134312464024,0 ) then delimit each value and copy them to sheet main page to cells F8 = 30.97196382996512 and F7 = 28.9608755022139 (see attached file sheet main page ) the copy the converting from cell E12 and cell E13 and H12 and past them in the same row of its name in column H and I and K .
repeat this till end all selected cells
note : the first delimited is the Long and the second is the Lat
Best Regards
Bookmarks