Update data from WEB

  • Thread starter Thread starter Karthik
  • Start date Start date
K

Karthik

I've a data in WEB, which I want to update to an excel sheet daily, I
normally copy and paste the data into the spread sheet. Would it be possible
to somehow link the sheet to the web and update it daily automaticaly?

Thanks in advance...
 
Are you familiar with following command?:
Data| Import External Data| New Web Query
This is a useful command for getting data from Web, esp. if during
copy/paste your data don't enter to independent cells automatically.
I think by this method, refreshing the sheet will update to new data
automatically. Please try and let us know, if it works, as you want.
 
Back
Top