Code to check and match not working

[endoskeleton]

Hi

I have the following code that is supposed to check cell AC for "YES" , if that is correct then put data into AH:AT from the row immediately above it.

What am I doing wrong?

Thanks
Jon

Please Login or Register  to view this content.

[davegugg]

What's the Rw variable? Shouldn't that be LR???

[endoskeleton]

Hi Dave

I'm very new to VBA, but on a steep learning curve.

I see what you mean but when I replace the Rw with LR, the macro runs but nothing happens.

It seems like it is finding no instances of "YES" within col AC.

The "YES" in Column AC is actually generated by a formula

Please Login or Register  to view this content.

and then copied down the column does that make a difference ?

Cheers

Jon

[davegugg]

Your code only looks at the last cell in Colum AC. If you want to look at every cell in the column, you have to loop through each of them:

Please Login or Register  to view this content.

[endoskeleton]

Hi Dave,

Ahh I see,.

Didn't work the way at wanted at first until I realized that is was actually overwriting where I already had data. Once I changed the destination range it worked like a dream.

Thanks so much for your help.

Jon