Hi EE,
I’m after some help with Google Docs Spreadsheets; I know it doesn’t have a lot of the functionality of the likes of Excel. However what I’m after doing is taking some information from a website and updating the cells in a Google doc spreadsheet on a 60sec refresh. I’ve done some searching and found some info but for whatever reason I can’t get it to work.
The formula that I’m using is:
=index(ImportHtml("
http://apmex.com/","tabl
e",7),3,2)
Which works great for pulling the data but when I apply the same theory as below I can’t get it to work?
Details i found on the web:
I used a simple workaround of appending a parameter which updates every minute.
Function call is: =ImportHtml("
http://www.fifa.com/worldcup/standings/index.html?"&H81;"table"
;4)
Formula in H81 is: =Minute(Now())
Any help with this would be greatly appreciated.
Thank you
Ross