Conditional Copy

P

pambear

I want to copy a row of data only if the value in column
B is a particular customer's name. How do I
conditionally copy data?
 
G

Grey Newt

I need more info really - but assuming your code is walking down a load of rows - a simple IF would do the job.

If lcase(Range("B" & activecell.row).value)="fred bloggs" the
....do the cop
els
activecell.offset(1,0).selec
end if
 
Top