Hello,
Newbie here. I am trying to automate the processing of survey data, to make life quicker and easier. The surveying trolley takes measurements at regular intervals, and logs these alongside the distance travelled (either KM/Metres or Miles/Yards). Some of the locations along the route have a site name, with a known distance limits (e.g. Site 1 is from 30.980km to 30.990km).
What I want is either a formula or a script that fills in the location names automatically, so for example cells C2:C3 both have "Site 1" filled in for me.
I have found a similar example of this on the forum, but can't get my head around the code to make this work for me. Can anyone help please?
Thanks.
Newbie here. I am trying to automate the processing of survey data, to make life quicker and easier. The surveying trolley takes measurements at regular intervals, and logs these alongside the distance travelled (either KM/Metres or Miles/Yards). Some of the locations along the route have a site name, with a known distance limits (e.g. Site 1 is from 30.980km to 30.990km).
What I want is either a formula or a script that fills in the location names automatically, so for example cells C2:C3 both have "Site 1" filled in for me.
I have found a similar example of this on the forum, but can't get my head around the code to make this work for me. Can anyone help please?
Thanks.