Sot data and make it apperar in other sheet?

  • Thread starter Thread starter SpeeD
  • Start date Start date
S

SpeeD

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
 
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
 
Back
Top