Sot data and make it apperar in other sheet?
 

Hi.

i have all my data in a "List table" in sheet1.

How can i sort that data and make it appear in sheet2 automatically?
is there a simply and obvious way that im missing?

Thanks a lot
SpeeD

Sot data and make it apperar in other sheet?
 

Sorting on a sheet won't magically make data appear on another sheet.

Is the second sheet linked to the first?

Sorting sheet1 will sort linked data on sheet2.

Elsewise you will need VBA code to copy sorted data to sheet2


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 10:25:02 -0700, SpeeD
wrote:

Hi.

i have all my data in a "List table" in sheet1.

How can i sort that data and make it appear in sheet2 automatically?
is there a simply and obvious way that im missing?

Thanks a lot
SpeeD