Dear JulieD,

Yes, it's actually the latter example that I mean ... I need to have the
three worksheets sorted so that the desending order is from page one through
page three, i.e. page one would have

1...cat
2...dog
3...elephant

page two would have

1...ferret
2...mouse
3...rat

I've not done macro/codes befoe. Any suggestions?

Thanks, E :-)


"JulieD" wrote:

Hi Evelyne

you mean on worksheet 1 you have
...........A
1.....mouse
2.....cat
3....dog

and on sheet 2 you have
..........A
1....rabbit
2....elephant
3....rat

do you want - sheet 1 to have
.........A
1...cat
2...dog
3...mouse

or sheet 1 to have
........A
1...cat
2...dog
3...elephant
???

if it's the first one, perform a sort on each sheet
if it's the second one, sort of combining the three sheets into one, sorting
them and then splitting them back to three sheets - the only way i know that
you can achieve this is to use a macro / code - is this an option that
you'ld consider?

Cheers
JulieD

"Evelyne" wrote in message
...
I have a workbook with 30 lines per worksheet. I need to be able to sort
the
data from each line below the headers from all three worksheets. Any
ideas?