[Solved] Link to external data won't work do I need a Macro?
Posted: Thu Mar 23, 2017 5:48 am
I'm semi-new to this stuff, but very much a self taught sort of spreadsheet user.
I'm just trying to link to an external HTML table:
http://mesowest.utah.edu/cgi-bin/droman ... type=LOCAL
Seems pretty easy really but every iteration i try is a fail.
If i copy (all of the web page) and paste it (into a sheet) i get what i am looking for, so I know the tables are in there. Is there some simple little thing I am missing?
When i use this web page:
http://www.jhavalanche.org/viewBigsheet
I can link these tables, so I know I'm doing the process right to some degree.
I messed around with copying the page and then trying to use a MacroRecording of the SpecialPaste function -but that is a lot work and not to mentin cluncky method to do what seems to be a simple thing...
I'm just trying to link to an external HTML table:
http://mesowest.utah.edu/cgi-bin/droman ... type=LOCAL
Seems pretty easy really but every iteration i try is a fail.
If i copy (all of the web page) and paste it (into a sheet) i get what i am looking for, so I know the tables are in there. Is there some simple little thing I am missing?
When i use this web page:
http://www.jhavalanche.org/viewBigsheet
I can link these tables, so I know I'm doing the process right to some degree.
I messed around with copying the page and then trying to use a MacroRecording of the SpecialPaste function -but that is a lot work and not to mentin cluncky method to do what seems to be a simple thing...