LINKING AN EXCEL SHEET TO SOME DATA AVAILABLE IN INTERNET
Purpose:
Assume that you need some information on a regular basis to be downloaded from internet into an excel sheet format (rows and columns). You also need this information to be updated regularly when the same is updated in the internet.
How to do
You can achieve the same by using “Data from web” function
Where do I find Data from web in Excel 2007 / 2010
Go to “Data” tab to locate
Where do I find in Excel 2003 or earlier
Go to “Data” menu to locate the same
The screen will look as follows:
CAclubindia
