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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Sheets as variable 2
Data Validation in another sheet 1
Replace cell letter 1
Problem with formula in grouped sheets 2
Matching column in different sheet 1
Separating data into new sheet 1
Matching data in two sheets 3
COUNTIF, Sorting, on Two Sheets 1

Back
Top