Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data
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, Im 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data
Thank you! -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How to avoid date convertions when importing external web data? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |