I have a spreadsheet of historical data I am creating. Each row would be a
single project and there are several columns that have different information
about each project. I would like to create a button in the header of each
column that would give me an option to sort the rows by the custom values in
each column. For example I may want to see all union projects, or all
non-union projects, or all projects that were apartments or condos. I hope
this description makes sense.

Hi,

Have you tried pivot tables? I think it is the tool that best fits your
needs. With pivot tables you can filter the data the way you are saying.

Regards,
--
Carlos


"Mike Smith" wrote:

> I have a spreadsheet of historical data I am creating. Each row would be a
> single project and there are several columns that have different information
> about each project. I would like to create a button in the header of each
> column that would give me an option to sort the rows by the custom values in
> each column. For example I may want to see all union projects, or all
> non-union projects, or all projects that were apartments or condos. I hope
> this description makes sense.

I unfortunately know nothing about pivot tables. I will have to read up and
see how to create one. I tried the wizard a couple times but it says the data
field is invalid.

"Carlos Mallen" wrote:

> Hi,
>
> Have you tried pivot tables? I think it is the tool that best fits your
> needs. With pivot tables you can filter the data the way you are saying.
>
> Regards,
> --
> Carlos
>
>
> "Mike Smith" wrote:
>
> > I have a spreadsheet of historical data I am creating. Each row would be a
> > single project and there are several columns that have different information
> > about each project. I would like to create a button in the header of each
> > column that would give me an option to sort the rows by the custom values in
> > each column. For example I may want to see all union projects, or all
> > non-union projects, or all projects that were apartments or condos. I hope
> > this description makes sense.

Look at these:
http://peltiertech.com/Excel/Pivots/pivottables.ht
http://www.babeled.com/2008/07/18/ex...-manipulation/

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike Smith" wrote:

> I unfortunately know nothing about pivot tables. I will have to read up and
> see how to create one. I tried the wizard a couple times but it says the data
> field is invalid.
>
> "Carlos Mallen" wrote:
>
> > Hi,
> >
> > Have you tried pivot tables? I think it is the tool that best fits your
> > needs. With pivot tables you can filter the data the way you are saying.
> >
> > Regards,
> > --
> > Carlos
> >
> >
> > "Mike Smith" wrote:
> >
> > > I have a spreadsheet of historical data I am creating. Each row would be a
> > > single project and there are several columns that have different information
> > > about each project. I would like to create a button in the header of each
> > > column that would give me an option to sort the rows by the custom values in
> > > each column. For example I may want to see all union projects, or all
> > > non-union projects, or all projects that were apartments or condos. I hope
> > > this description makes sense.