Using conditional statements to copy specific rows to a new sheet

[GabrielJames]

Hi Everyone,

I've found a lot of material on this topic but can't get it to work for my purposes.

I'm working to reformat some desired data on a new sheet with a macro based on specific values in the "E" column. I'm hoping to copy over all the rows that don't have the "Fail" in the "E" column. An example of my raw data file is attached.

The final format i'm looking for on my new sheet is with the wanted "E" values in the new column "B", the original "B" values in the new column "C", and the original "C"/"D" values in new columns "D"/E" respectively.

Here's my attempt but I can't figure out what I need to do to fix it:

Please Login or Register  to view this content.

Help would be greatly appreciated, Thank you!!

[xladept]

Try this:

Please Login or Register  to view this content.

[xladept]

You're welcome and thanks for the rep!