fix coding

[wyldjokre69]

Hello,

Can someone take a look at this coding and tell me why it makes some of the information I'm trying to sort disappear?

Please Login or Register  to view this content.

Attached is a sample you can use to show you what I mean and hopefully fix it to where it doesn't delete information.

CheerZ!
Wyldjokre69

Sample11062014.xlsb

P.s: the code takes the highlighted horses in Cells D & K and matches them up including the data in Cells E-O. Apply and see for yourself. If you can add a piece of coding which will keep the data that is not highlighted in pink and have it just match across all between E-O, that would be super.

[Norie]

Is the data that's disappearing the data that's been highlighted using conditional formatting?

[wyldjokre69]

yes, i don't know why though.

[Norie]

It's because the formatting applied by conditional formatting isn't being recognised as 'real' formatting so VBA thinks those cells have no fill.

So if you want to return only the data for horses in column D that don't have a match in column L then you'll need another approach.

One way would be to add a helper column to the right of the data with this formula copied down.

Please Login or Register  to view this content.

That will return 0 if the horse in column D isn't found in column K.

You could then filter on the helper column.

[wyldjokre69]

Hello Norie,

Is there a way to adjust the vba coding to read the data from the formula you just gave me?

[Norie]

Not sure what you mean.

You could use code to create the helper column and the filter it.

Please Login or Register  to view this content.