Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Certain Data from closed file
To All,
I want to be able to do the following: Spreadsheet data.xls is a CLOSED spreadsheet that contains many columns and rows of data. I want to search column C of this spreadsheet, and extract all the rows that contain FR55 in column C to a spreadsheet newdata.xls. The macro needs to be contained in spreadsheet newdata.xls and extract the data from data.xls. Any ideas? thanks in advance, Regards Joseph Crabtree |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Certain Data from closed file
Nel post ups.com
*joecrabtree* ha scritto: To All, I want to be able to do the following: Spreadsheet data.xls is a CLOSED spreadsheet that contains many columns and rows of data. I want to search column C of this spreadsheet, and extract all the rows that contain FR55 in column C to a spreadsheet newdata.xls. The macro needs to be contained in spreadsheet newdata.xls and extract the data from data.xls. Any ideas? thanks in advance, Regards Joseph Crabtree Hi Joseph, Try to see he http://www.erlandsendata.no/english/...dacimportwbado http://www.erlandsendata.no/english/...nvbadacwbdbado http://www.erlandsendata.no/english/...nvbadacwbdbdao I think you should find something to solve your problem... -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Certain Data from closed file
I'd open data.xls and use data|Filter|autofilter on the worksheet in column C.
Then filter to show FR55's and copy the visible range to the other location. Then close data.xls. With screenupdating turned off, it should be invisible to the user. joecrabtree wrote: To All, I want to be able to do the following: Spreadsheet data.xls is a CLOSED spreadsheet that contains many columns and rows of data. I want to search column C of this spreadsheet, and extract all the rows that contain FR55 in column C to a spreadsheet newdata.xls. The macro needs to be contained in spreadsheet newdata.xls and extract the data from data.xls. Any ideas? thanks in advance, Regards Joseph Crabtree -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAN I IMPORT DATA FROM A CLOSED FILE TO A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
How do I copy data from a closed file. | Excel Programming | |||
GetValue to extract data from closed files | Excel Programming | |||
How to extract data from a wooksheet in a closed workbook | Excel Worksheet Functions | |||
Problem with named Range in ADO extract from Closed Excel File | Excel Programming |