Macro for Sorting

[Carlos]

Hello to all,
I tried to record a macro to sort a list of names in 4 sheets. The names are
actualy copied from the main sheet to the other 3.
I selected the rows in the main sheet (P1) from row 14 to 58 and selected
the "sort" option from "data" menu. When I selected the second sheet (M1)
the sorting option was not valied. I could not do sorting!
Can any one help?

I need to do this so as sorting the names in sheet P1 will keep the relative
data with that person in the other 3 sheets in the same workbook.

 

[Don Guillett]

As always, post your coding efforts for comment and suggestions. You
probably have sheets("sheet1") or so. Why are you duplicating in the other
sheets to start with?

 

[Carlos]

Hi,
I found out why. The sheets were protected.
Thanks

 

[Don Guillett]

But why do you need more than one. Take a look at
data>filter>autofilter