select some data from a list

[woodenski]

I have a mailing list that I have imported into Excel. The usual
fields, name, address, state and zip, all lined up in neat columns.

I would like to be able to make some selections and have them show up
in another tab in the same spreadsheet. For instance, I want some
technique to select all the address from a certain zip code, and have
them show up in the second tab.

But, I cannot seem to find any technique that does this kind of query.
I recall that this was called a query in Lotus 123?

Any suggestions on how this works.

I know that I can sort by zip code, select the appropriate records, and
copy to the next tab. But, this seems kind of clunky.

thanks,
mark

 

[Jim Gordon MVP]

Hi Mark,

There is a toolbar button that selects only the visible cells. To make this
button available use Tools > Customize > Customize Toolbars/Menus. Click on
the Commands tab. In the Categories select Edit. From the Commands side drag
the command Select Visible Cells to any menu or toolbar.

You can create custom filters easily using the AutoFilter. Click in the
header row then from the menu choose Data > Filter > AutoFilter.

Each column will then have a button you can click to create filters.

Once you have created the desired filter, click the Select Visible Cells
button and then copy the cells. Switch to a new worksheet then paste.

If you do this a lot, try making a Macro by turning on the Macro Recorder
(Tools > Macro > Record New Macro).

Other people will probably chime in with other suggestions.

-Jim Gordon
Mac MVP

I have a mailing list that I have imported into Excel. The usual
fields, name, address, state and zip, all lined up in neat columns.

I would like to be able to make some selections and have them show up
in another tab in the same spreadsheet. For instance, I want some
technique to select all the address from a certain zip code, and have
them show up in the second tab.

But, I cannot seem to find any technique that does this kind of query.
I recall that this was called a query in Lotus 123?

Any suggestions on how this works.

I know that I can sort by zip code, select the appropriate records, and
copy to the next tab. But, this seems kind of clunky.

thanks,
mark

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[PhilD]

Other people will probably chime in with other suggestions.

This sounds to me like a place to use a LOOKUP function. I cannot tell
you exactly how to use it, though, because I usually get someone at
work to write these for me (well, that's what staff are for, isn't
it...!)

PhilD

 

[2neatmagazines]

Jim and Phil,

Thank you for taking the time to answer my question. The filter is
exactly what I had in mind. Already have it working .

The lookup is a really slick feature and I can use this in another
spreadsheet this afternoon. I think it will make this one work much
easier.

Thanks again,
mark