filter question
 

Hi,
I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc)
Columns b to G need to be filtered in order of Client name ( column B)

Can this be done? if so, can it be done automatically or with the help of a
macro?


Thanks,

Nigel

make sure that column A is numeric and not the result of an equation.
select all that you want to stay together while sorted.
select <data<sort and sort by column B

"Nigel" wrote:

Hi,
I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc)
Columns b to G need to be filtered in order of Client name ( column B)

Can this be done? if so, can it be done automatically or with the help of a
macro?


Thanks,

Nigel

Nigel

Sounds more like a Data Sort than a Filter.

Do you want Column A to read 1,2,3,4,5,6 no matter what order the other
columns are in?

In A1 enter =ROW() and copy that down to end of data.

Now do your sort and the 1,2,3,4,5,6 order will remain.


Gord Dibben Excel MVP

On Thu, 5 May 2005 03:21:03 -0700, "Nigel"
wrote:

Hi,
I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc)
Columns b to G need to be filtered in order of Client name ( column B)

Can this be done? if so, can it be done automatically or with the help of a
macro?


Thanks,

Nigel