filter question

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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