Use FIND in VBA for complex search

**rpinxt** · 10-30-2012, 05:03 AM

Hi All,

Just a quick scenario:
Say in column C I have following list:
1LAA80
1LAA90
1LAB60
1LAC10
1LC010
1LC280
1LC380
1LC710
4AA110
4AA110

My first problem then is that the macro should only look for the cells which start with 1LC.
The second problem then would be that on the lines where he finds 1LC it should look in column F if there is an amount/value.
Third step then would be that if there is an amount it should go to column H of that line and there put some formula (or word, does not matter that I can do just need to get the macro there)

Since this is smaller part of the list you understand it has to be a variable "loop" of some sort which goes thru column C in search for codes which start with 1LC.

Hope I explained good enough and hope the experts in this forum can help me

Thanks in advance.

**mike7952** · 10-30-2012, 05:14 AM

This should do it

Please Login or Register  to view this content.

**arlu1201** · 10-30-2012, 05:15 AM

Try this code - copy it into a standard module -

Please Login or Register  to view this content.

**rpinxt** · 10-30-2012, 05:22 AM

Thanks Mike!
Had to do a small correction as I had not mentioned to you that column F would not be empty but 0 (so <> 0 instead of <>"").
But works great and its a big help

Arlette also a big thanks. Your method (with same small adjustment) also worked like a charme