Conditional Copy
 

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?

Conditional Copy
 

Hi
have a look at
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"pambear" schrieb im Newsbeitrag
...
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?

Conditional Copy
 

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