Macro for Sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos - 17 Jul 2007 11:41 GMT

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.

Reply to this Message

Don Guillett - 17 Jul 2007 14:46 GMT

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?

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hello to all,
> I tried to record a macro to sort a list of names in 4 sheets. The names
[quoted text clipped - 6 lines]
> 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.

Reply to this Message

Carlos - 17 Jul 2007 16:13 GMT

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

> As always, post your coding efforts for comment and suggestions. You
> probably have sheets("sheet1") or so. Why are you duplicating in the other
[quoted text clipped - 11 lines]
>> relative data with that person in the other 3 sheets in the same
>> workbook.

Reply to this Message

Don Guillett - 17 Jul 2007 16:52 GMT

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi,
> I found out why. The sheets were protected.
[quoted text clipped - 15 lines]
>>> relative data with that person in the other 3 sheets in the same
>>> workbook.

Reply to this Message

Rate this thread: