Importing data

[Captain Haddock]

Hi,

I’m trying to import filtered data (Autofilter) from ”Test_data.xls” to ”Test.xls”, but got ALL information from the database. What have I missed in ”Data_Import external data_Import data”?

Thanks

[Marcelo]

after select the range that you would like to copy press F5 | special |
visible only

Hope this helps
regards from Brazil
Marcelo

"Captain Haddock" escreveu:

>
> Hi,
>
> Iā€™m trying to import filtered data (Autofilter) from ā€¯Test_data.xlsā€¯ to
> ā€¯Test.xlsā€¯, but got ALL information from the database. What have I
> missed in ā€¯Data_Import external data_Import dataā€¯?
>
> Thanks
>
>
> --
> Captain Haddock
> ------------------------------------------------------------------------
> Captain Haddock's Profile: http://www.excelforum.com/member.php...o&userid=34399
> View this thread: http://www.excelforum.com/showthread...hreadid=551158
>
>

[Captain Haddock]

Thank you!