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 |
How do I pull certain data out of spreadsheet and import into another?
The macro recorder can be your friend in learning how Record a macro while using datafilterautofilterfilter on the citycopypaste -- Don Guillett Microsoft MVP Excel SalesAid Software "SirDomino" wrote in message ... 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 |
How do I pull certain data out of spreadsheet and import intoanother?
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 |
How do I pull certain data out of spreadsheet and import into another?
See also
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SirDomino" wrote in message ... 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 |
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 |
All times are GMT +1. The time now is 06:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com