| 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 |
| 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 | |||
Threaded Mode
