Why not copy the existing data and append it to another sheet before
refreshing the query?

Tim


"Vicky" wrote in message
...
Dear all,
I've macro codes for web page query table. The webpage table contains the
data for 180 rows & 6 columns. The webpage table overwrites whenever the
new
data being updated.
Now i wish to import the data table in excel spreadsheet whithout
overwriting the data tables, although the web page table gets overwrited
i.e.
to keep the exsting imported data as it is & import new data below the
exsting datatable or to insert the new rows for new data without
overwriting
the exsting data.
Is it possible?
If yes then, how?
--
Vicky