Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To Make a Changing Data Sheet | Excel Worksheet Functions | |||
How do I make the data sheet appear in my power point presentation | Excel Worksheet Functions | |||
Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
Data from two sheets make up a list in a third sheet (real time) | Excel Worksheet Functions | |||
Can I make a list, on one summary sheet, of data collected from ma | Excel Worksheet Functions |