Sorting of Range in VB

[hoongz]

Hi I've created a workbook that users can key in a record. The final tab in the workbook actually allows supervisor to have a quick overview of those records that require attention. So basically in each of the month's tab, if the completed column is yes, it will not appear in the last tab. If it's no, it will be copied into the last tab. Those that exceed a certain number of days will be highlighted to make it more prominent. Here comes the part i need assistance in. I wish to sort the data in the last tab using the following order, by the name, followed by number of days. I keep failing to get it to sort. Appreciate if anyone could offer me some assistance.

I've attached a copy of the incomplete file for perusal.

Thank you

[arlu1201]

Are you able to get the data to be copied to the outstanding tab? Or do you need code for that?

This is the sort code you can use -

Please Login or Register  to view this content.

[hoongz]

Hi Arlu,

Thanks for your assistance. But this isn't working out for me. They said opject doesn't support this property or method. and highlight the 2nd field codes as shown below when i debug it

Please Login or Register  to view this content.

[arlu1201]

Oops...change this line from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[hoongz]

It works fine now thanks alot. But is it possible to set the sorting to start at the 5th row? Since I set my 4th rown to be the header.

Tested by changing the range and it worked. Thanks alot

[arlu1201]

Try this code

Please Login or Register  to view this content.