| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I pull certain data out of spreadsheet and import into
That's a cool add-in, thanks for posting it. Is there a way to have the
criteria reference a cell? "JP" wrote: In addition to Don's suggestion, Ron de Bruin has an add-in that can do this. See http://www.rondebruin.nl/easyfilter.htm Also I am working on a similar tool: http://tinyurl.com/3c3tyv HTH, JP On Mar 21, 9:17 am, SirDomino <SirDomino. wrote: I am attempting to pull data that meets certain criteria out of a spreadsheet and have it imported into a blank spreadsheet. I have 5,000 records in Excel 2003 with fields for the Company Name, Address, City, State, and Zip. I would like to specify a city and have all the records that match that criteria, copied out of the spreadsheet and then imported into a new blank spreadsheet. So the new spreadsheet will only contain records that match the city I specify. I have been trying to do this for days, and I searched the forums without any luck. I would appreciate any help you guys could give. I look forward to your responses. Thanks! -- SirDomino |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I pull data from a spreadsheet to another spreadsheet | Excel Discussion (Misc queries) | |||
| how do I import data from one excel spreadsheet into another? | Excel Discussion (Misc queries) | |||
| How do I import data from a closed Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
| Import data to a spreadsheet. | Excel Discussion (Misc queries) | |||
| Can you import data from a scanner into an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
