P pambear Apr 8, 2004 #1 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?
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 Guest Apr 8, 2004 #3 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
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
