ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Update data from WEB (https://www.excelbanter.com/excel-discussion-misc-queries/219401-update-data-web.html)

karthik

Update data from WEB
 
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...


--
with regards
Karthi

Khoshravan

Update data from WEB
 
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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Karthik" wrote:

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...


--
with regards
Karthi



All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com