Hi All,

I am trying to gather data from web into excel. The problem is like
this.
1. http://incometaxindiaefiling.gov.in/knowtan/knowtan.jsp is address
of web site where you can search TAN data for the assesses using
search criteria, if you know the TAN.
2. If you select only the "Category of Deductor" and/or "State"
without mentioning anything in 3rd search criteria, it will give
results for the whole database by clubbing 10 results per page
(alongwith the page number links for further search)
3. Each link on the result page leads us to "Particulars" of that
link, which is the desired information I need.

Is there any way by which the particulars for each link on each page
are pulled/imported into one excel sheet/workbook (in columner form)
automatically, thereby avoiding the need to open each link and copying
the results to excel sheet again and again.

Kind Regards
CA Kanwaljit Singh Dhunna
India