Custom sort the same range on every workseet except the first sheet?

[Shannon561]

Good Day!

I would like to search the same row on every work sheet except the first sheet.

The range is the same D3:D100 and I need it to sort in the following order.

Design
Documentation
Tender
Post Tender
Builder Appointed
Construction

The first worksheet is different to the rest and does not need sorting. Each worksheet has its own unique name.

Any help would be greatly appreciated.

Thank you

[Nisha Dhawan]

Hi Shannon,

First we would like to know which Excel version are you using exactly according to that we will be able to give you the solution.

If you are using Excel 2013 try below steps:-

Select the data range >Go To Data Tab> Click on Sort> Click on Z to A.

[Shannon561]

Hello, thank you for your response. I am using 2003.

But I need it to custom sort via the list in my first post.

[karedog]

Hi,

Please Login or Register  to view this content.

Regards

[Shannon561]

Worked perfectly Thank you Very much

[karedog]

You are welcome, thanks for the reputation points.

Regards