Macro/VBA code to Filter and delete unwanted data

[robertguy]

Hi,

Can any please advise me of the macro/vba code require to filter on column ‘C’ for any data that is not ‘Order’ and delete these rows of data and thus only showing rows of data with ‘Order’ in column ‘C’ (Please see attached workbook)

Any assistance would be greatly appreciated

Many thanks in advance


Regards

Rob

[xladept]

Try this:

Please Login or Register  to view this content.

[Winon]

Hello robertguy,

Please try this alternative, I am not lazy and have prepared a sample Workbook for your perusal.

When you click on the "Click" button on Sheet1, it will automatically create a backup of the original Data on Sheet3. That is to have data to fall back onto should you have made a mistake. Inf you did indeed made a mistake the "Reset" button will restore your Data for you, to start over.

Place the Code below in a Standard Module and enjoy.

Please Login or Register  to view this content.

Regards.

[Winon]

@ xladept,

Just an example of how to do something thoroughly

[xladept]

@ Winon - I am grateful for the instruction

[Winon]

@ xladept,

One day is one day, when I will not only catch up with your niggling sarcasm, but surpass you. Please don't come crying to me then!

[xladept]

@ robertguy - Winon has a point; we could just hide those rows:

Please Login or Register  to view this content.

[Winon]

@ xladept,

Hey Orrin,

I have just noticed that none of your Code returns the Data sample as shown in Sheet2. It remains one row short.

[xladept]

@ Winon - Thanks Tjaart!

@ robertguy - These get them all:

Please Login or Register  to view this content.

[jindon]

robertguy,

Try

Please Login or Register  to view this content.

[Winon]

Hello robertguy,

As xladept says, if you just want to hide the Rows without "Order" in Column "C" then use his Code as posted above.

The attached Workbook demonstrates how the Code would work.

Regards.

[robertguy]

Winon / jindon / xladept,


Many thanks for all your prompt replies it is very much appreciated.

Using a combination of all you excellent responses I have managed to resolved my problem to which I am greatly indebted

Thanks Again


Regards


Rob

[Winon]

Hello robertguy,

Thank you for the feedback.

You are welcome, glad we could help.

Also, thank you for the Rep, I really appreciate it!

Regards.

[xladept]

You're welcome and thanks for the rep!

[jindon]

Thanks for the rep and glad you like it.