VBA If function help

[kdm]

Hello,

I need to use an If function to search for a text sring in one column and then copy the results from another column on to another worksheet.

For example:

1 A
2 B
3 C
4 D

I need to search in the first column for numbers > 2 and then copy the true results from the second column. In this exmaple, B, C and D would be copied.

I am a beginner, so this may be easier than I think, nonetheless I am still struggling and can't find much help online!

Any help would be much appreciated.

Thanks,

kdm

 

[kdm]

Yes.

Thanks,

kdm