select some data from a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

woodenski@excite.com - 27 Nov 2006 23:56 GMT

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

Reply to this Message

Jim Gordon MVP - 28 Nov 2006 04:16 GMT

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

Quoting from "woodenski@excite.com" <woodenski@excite.com>, in article
1164671761.145126.301830@l39g2000cwd.googlegroups.com, on [DATE:

> 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.
[quoted text clipped - 14 lines]
> thanks,
> mark

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

PhilD - 28 Nov 2006 12:08 GMT

> 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

--
<><

Reply to this Message

2neatmagazines@gmail.com - 28 Nov 2006 17:04 GMT

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

Reply to this Message

Mac Forum / Applications / Excel / November 2006

select some data from a list