More info including url and tables desired. Sometimes best to import the
whole table and use a FIND macro to extract what is desired to another
location.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TUNGANA KURMA RAJU" wrote in
message ...
I have a web query which imports data on a w/sheet range A1:I57,a part of
data which is invisible unless I scroll down.The query has 5 tables. Is it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what other
alternative
ways to change the destination of web query tables.