Hi everyone, hopefully some kind person can help me.
Apologies firstly as I have very limited excel experience but I picked up a few excel books 3 weeks ago in order to sort out a problem I get as a Wind turbine tech and despite working on this for a ton of hours I am no further forward and I am going around in circles.
I work on 53 wind turbines total, and these at 5 different wind farm locations. each turbine has a different i.p address which frequently have to be typed into a browser every time we need to access that turbine.
I just need to be able to select a particular turbine that then automatically go to that i.p address in a browser.
I have got a drop down list working ok but a 2nd data validation box to reference the first only works on 2 wind farms (glassmoor and deeping) I have used a, =indirect(A2) but it comes up with an error of "the source currently evaluates to an error" when selecting ok.
Am I using the best route to achieve this goal and if so what could I be doing wrong?