Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Howdy all! Here's my problem: I've got a gargantuan spreadsheet with the following headers: A | B | C | D | E | F | G | H No. | Supplier # | Supplier Name | Address | City | State | Zip | Amount Is there any way to pull out only data that matches what I'm looking for and insert it into a separate worksheet? More specifically, I'm looking only for suppliers where City=Chicago. Can anyone help me with this? Thanks in advance for any advice given! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Hi
One way is to use Data/Filter/Autofilter. It's really easy! Just switch it on and filter what you want using the little down arrows at the top of each column. Once the list is as you like it, I use Ctrl+Shift+8 (or Ctrl+*) to select it all and then copy it and paste onto new sheet. Hope this helps. Andy. "loopkid1" wrote in message ... Howdy all! Here's my problem: I've got a gargantuan spreadsheet with the following headers: A | B | C | D | E | F | G | H No. | Supplier # | Supplier Name | Address | City | State | Zip | Amount Is there any way to pull out only data that matches what I'm looking for and insert it into a separate worksheet? More specifically, I'm looking only for suppliers where City=Chicago. Can anyone help me with this? Thanks in advance for any advice given! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Hi Andy, Are you looking to pull out all the details or just some information e.g. total amount for chicago? If you can say what you want to achieve and why this will help Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Hi Ed, I certainly can clarify a bit! I'm wanting all of the details from each row where City=Chicago on a separate worksheet. Basically, I'd like to be able to look at and/or print just a list of all those suppliers located in Chicago without printing out the entire list (600 some pages) and going row by row. Does that help at all? Let me know what else you need from me, and thanks! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Hi
Using my suggestion of Data/Filter/Autofilter should do the job for you. There is an intro to using this feature he http://www.contextures.com/xlautofilter01.html Andy. "loopkid1" wrote in message ... Hi Ed, I certainly can clarify a bit! I'm wanting all of the details from each row where City=Chicago on a separate worksheet. Basically, I'd like to be able to look at and/or print just a list of all those suppliers located in Chicago without printing out the entire list (600 some pages) and going row by row. Does that help at all? Let me know what else you need from me, and thanks! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data based on content
Hey Andy, You were right...that worked perfectly! Thanks! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=519360 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I color specific data series based on location on data she | Charts and Charting in Excel | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |