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
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
Does the data usually have headers or just as it is?
If things don't change they stay the same
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.
Hi makinmomb,
Try this (initially on a copy of your data as the results cannot be undone if the results are not as expected):
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
I know how to sort , i don't need added steps that is why i ask for a macro
Thank you Trebor76
Thank you for your feedback. That's totally fine. I only mentioned it as a possibility.I know how to sort , i don't need added steps that is why i ask for a macro
Cheese I have deleted headers for the macro not to do additional steps
The fastest is clicking a to z but i have too many items , so macro suits me
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks