I am no Excel buff but this application has some really neat features which we normally aren’t aware of during general use.
What if I want some data to be stored in Excel sheet from a web page and then regularly update that data from the internet?
It can be done in a jiffy within Excel using the Web Query option.
Open Excel (Start > Run > excel.exe)
Go to Data > Import External Data > New Web Query.
This will open a browser within Excel (it is IE),go to website (here I am using finance.yahoo.com) and select the tables that you want to import using the yellow arrow button.
Selected tables here will be tick marked and once done,hit the Import button.
This will prompt for data placement(the cells where you want the data to appear),select as appropriate and voila – all the table values from webpage are in Excel.
Now,whenever updation is needed,right click any of the imported table cell and select Refresh Data.
This will update the data after fetching it from the website source.(Basically,the web query will run again and import the data.)
There are macros which can also automate the refreshing of data,I will post more on that after some time.
Happy Exceling.
Peace.