I'm trying to sort a worksheet by columns but keep all the data on the rows
in the correct place. e.g. sort a work sheet by a date column and get it to
move all the information on each row aswell.

"Martyn" wrote in message
...
I'm trying to sort a worksheet by columns but keep all the data on the
rows
in the correct place. e.g. sort a work sheet by a date column and get it
to
move all the information on each row aswell.

Make sure you select the entire range (all the columns you're working with)
before you do your sort.
--
David Biddulph

Thanks David, worked it while waiting for a reply.

"David Biddulph" wrote:

"Martyn" wrote in message
...
I'm trying to sort a worksheet by columns but keep all the data on the
rows
in the correct place. e.g. sort a work sheet by a date column and get it
to
move all the information on each row aswell.

Make sure you select the entire range (all the columns you're working with)
before you do your sort.
--
David Biddulph

any way to make this an automatic sort without using macros
--



"David Biddulph" wrote:

"Martyn" wrote in message
...
I'm trying to sort a worksheet by columns but keep all the data on the
rows
in the correct place. e.g. sort a work sheet by a date column and get it
to
move all the information on each row aswell.

Make sure you select the entire range (all the columns you're working with)
before you do your sort.
--
David Biddulph

Automatic means VBA.

Excel doesn't know when/how to sort things unless you give a command, either by
DataSort or by VBA.


Gord

On Thu, 21 Feb 2008 13:28:04 -0800, bkunes
wrote:

any way to make this an automatic sort without using macros