faraoosiris
asked on
Reference to transposed pairs of columns is excel for further calculations/
I have taken coordinates from an exsisting flightplan and copied them into Notepad+++ and save the file to a txt file. The txt file is imported in excel sheet1.
With the help of a function I found on the internet, the imported txt file is transposed to paired columns of data on sheet2.
On this sheet I want to recalculate the positions from a Degree Minutes Seconds format to a digital format. This to be able in the end to make a KML file that can be displayed as a path in Google Earth.
This is the situation depicted in the attached file. However if I run the Macro to transpose the data, all the formulas on sheet 2 are gone. How to overcome this?Jeremy.xlsb
With the help of a function I found on the internet, the imported txt file is transposed to paired columns of data on sheet2.
On this sheet I want to recalculate the positions from a Degree Minutes Seconds format to a digital format. This to be able in the end to make a KML file that can be displayed as a path in Google Earth.
This is the situation depicted in the attached file. However if I run the Macro to transpose the data, all the formulas on sheet 2 are gone. How to overcome this?Jeremy.xlsb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your prompt reply.
I implied your suggestion and it works like a charm.