Delete row of SELLER items

[makinmomb]

I want the macro to delete rows where last column is not pink , this will give me a list of what is slow moving

Find attached

[CheeseSandwich]

Does the data usually have headers or just as it is?

[HansDouwe]

The percentages below 10% have been made pink with a Conditional Formatting rule.

This gives two other possibilities to delete the desired rows without a macro.

Possibility 1: Sort the table by column F in deceding order and delete the top rows, where the percentage is not pink.
OR
Possibility 2: Filter the table in column F on percentages from 10% and delete the rows you see. (That can then be done in one go, the filtered rows remain).

If you have any questions about this, please let me know.

[Trebor76]

Hi makinmomb,

Try this (initially on a copy of your data as the results cannot be undone if the results are not as expected):

Please Login or Register  to view this content.

Regards,

Robert

[makinmomb]

I know how to sort , i don't need added steps that is why i ask for a macro

[makinmomb]

Thank you Trebor76

[HansDouwe]

I know how to sort , i don't need added steps that is why i ask for a macro

Thank you for your feedback. That's totally fine. I only mentioned it as a possibility.

[makinmomb]

Cheese I have deleted headers for the macro not to do additional steps

[CheeseSandwich]

Cheese I have deleted headers for the macro not to do additional steps

I see, I only asked as I would imagine that using filter would have been the fastest option but it works better with headers.

[makinmomb]

The fastest is clicking a to z but i have too many items , so macro suits me

[CheeseSandwich]

I was talking about VBA

VBA to:
Filter data to anything greater than 0.1, then delete all the visible rows, then remove filter.

It will always be slower to delete one row at a time in a loop.

[HansDouwe]

The fastest is clicking a to z but i have too many items , so macro suits me

If you try the filter-functionality in your panel, and delete the visible rows is also fast for many items.