Sort on 3 Worksheets

[BillyRaySpivy]

Hello,

Is it possible to sort names on 3 worksheets with a macro? Thereby keeping the row data intact.

Thank you

[BillyRaySpivy]

Wow this must be beyond this forums abilities. Thanks!

[Logit]

.
A basic and simple way of doing it would be to use the Excel Macro Recorder. Having run the recorder, it generated the following code that can be pasted into a routine module
and activated with a Command Button:

Please Login or Register  to view this content.

Admittedly, there are others ways of accomplishing your goal, but this is one that is always available to you.

[BillyRaySpivy]

Thank you for the very kind reply. I didn't think anyone would help me.

Since waiting I came up with another way. I used index match to bring the names and associated info to each of the worksheets from the personal information worksheet. That way when I sort it doesn't affect the row data on the other sheets.

Have a great day and thanks again!

[Logit]

Thanks for the Add Rep