Sort Excel Sheets In Custom Order Based On Value In A List

[Excel Fox]

just write

If wks.Name <> "Sheet1" And ((wks.Cells(5, 3).Value = rng.Cells(lng).Value) OR (wks.Cells(5, 2).Value = rng.Cells(lng).Value)) Then

[naveenroy]

Hi,

Thanks so much for your help everyone appreciated for this sheet thanks for your patience and your great help.

I know am asking to much this last modification i need.. like they need summary sheet.I have wrote a macro but iam not able to get all the fields I have attached in the link below.

https://www.box.com/s/bs98wqyaw3ahvv348nc1

In sheet1 .. D1 to I1 i have mentioned cell names for all sheets which i wanted in the summary sheet. i also want which are in blank and color and format also.

Thanks a lot this will be last help. Please

[naveenroy]

Hi,

Thanks so much for your help everyone appreciated for this sheet thanks for your patience and for your great help.

I know am asking to much this last modification i need.. Last thing i need is summary sheet.I have wrote a macro but iam not able to get all the fields I have attached in the link below.

https://www.box.com/s/bs98wqyaw3ahvv348nc1

In sheet1 .. D1 to I1 i have mentioned cell names for all sheets which i wanted in the summary sheet. i also want which are in blank in cell, same color and format also and i need Hyperlink to the Proposal ID in summary when clicked it wil do tht particular sheet.

Thanks a lot this will be last help. Please

[naveenroy]

Hi Sir,

Please help in fix this code for summary data where i need particular/some cell values in each sheet and hyper link the proposal ID

https://www.box.com/s/bs98wqyaw3ahvv348nc1