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