Sort Ascending order and eliminate zero data

[rizmomin]

Hello:

Please refer to attached sheet.

I have data in Column A to D where
Column A is the employee #
Column B is the name of the employee
Column C is blank
Column D is the hours worked

The employee data is in
row 1 is the heading
row 31, cell D31 is the total of row from 2 to 30.

I would like to have a VB Macro to sort out in Ascending order of emmloyee name (Column B) and ignore any with
0.00 hours in column D and paste the result starting at Cell A45.



Please help and let me know if any questions.

Thank you

Riz Momin

[AB33]

Riz,
As an option,
You can filter by column D and ignore values which are less than 0 and copy them to A45

[rizmomin]

Hi AB33:

That's possible but i still need to filter the employee names in Ascending order.
So basically, I need to sort the employees first and then delete the ones with zero hours

Please help and Let me know if any questions.

Thank you

Riz Momin

[JasperD]

Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[rizmomin]

Hi JasperD:

Yes this works.
Thank you so much for your help.

Riz Momin

[rizmomin]

Hi JasperD:

Is there a way i can only filter data from Row 2 to Row 30 (Row 1 and Row 31 exclude in filter as heading).
I do not want to filter thru all of column A because i have other data.

Thank you

Riz Momin

[HaHoBe]

Hi, Riz,

Please Login or Register  to view this content.

Ciao,
Holger

[AB33]

Riz,

I do not like the filter based on last row as it sometimes does not work, but since I can not paste it on the same sheet, I have left with no other options

[rizmomin]

Hi HaHoBe:

Your code works great for me.
Thank U

Riz Momin