| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I pull certain data out of spreadsheet and import into another?
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
