Yes it would be the best solution if i only had Excel 2003. =o)

The company uses 2002 and theres no way for me to change that atm. Is
there a way to do this in Excel 2002?

/Jeo

Can't you create a list in Excel 2002?

I don't have this version on Hand.





" wrote:

Yes it would be the best solution if i only had Excel 2003. =o)

The company uses 2002 and theres no way for me to change that atm. Is
there a way to do this in Excel 2002?

/Jeo

Hi

DataList came in with XL2003.

You could create a dynamic named range for your data. Then, providing
there are no blank columns within the range, clicking on any cell within
the range and choosing Sort, will select the whole of the named range
before carrying out the sort.

If you want to use VBA, then Dave Peterson developed a very nice routine
utilising hidden shapes.
This can be found at Debra Dalgleish's site
http://www.contextures.com/xlSort02.html

--
Regards

Roger Govier


"Leung" wrote in message
...
Can't you create a list in Excel 2002?

I don't have this version on Hand.





" wrote:

Yes it would be the best solution if i only had Excel 2003. =o)

The company uses 2002 and theres no way for me to change that atm. Is
there a way to do this in Excel 2002?

/Jeo

The "list" feature was introduced with Excel 2003


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 19:56:00 -0700, Leung
wrote:

Can't you create a list in Excel 2002?

I don't have this version on Hand.





" wrote:

Yes it would be the best solution if i only had Excel 2003. =o)

The company uses 2002 and theres no way for me to change that atm. Is
there a way to do this in Excel 2002?

/Jeo