Hi
hope someone can help.
I have a complex spread sheet of Redferns formulae to convert UTM Coordinates to Lats & Longs with grid convergence.
in it's current configuration I can type in 1 pair of cords and get 1 result.
I want to set up a spread sheet where I can copy in a list of coordinates and have the corresponding converted results posted in the next columns.
the original spread sheet is available from external link removed by moderation.
I just need to know how I can use this workbook to do a batch conversion.
Thanks in advance if anyone has any suggestions.
Steve