Hard to tell without seeing but a macro can be created to do what is
desired.

--
Don Guillett
SalesAid Software

"Andrew" wrote in message
...
I have a database table which imports data from the web. This is OK,
however I need to be able to extract certain entries and copy them to a
different worksheet.
The advanced filter cannot do it.
Pivot tables dont allow me to "copy down formulas in adjacent cells" -
which
is a must
I would like to use the Import External Data function (this does
everything
I want) except it links to a data source on my C:/ drive. I just want it
to
link to a worksheet in the same workbook, this way it is portable since I
dont have a shared drive.
Have I missed something simple?
--
Thanks
Andrew