if / copy in a macro

[mani_singh]

what i need is to be able to do this:


if b1 is less than c1 then copy a1,d1,e1,f1,g1


thank you, im not sure how to do this

 

[venkat1926]

COPY WHERE

try this small macro

Sub test()
If Range("b1") < Range("c1") Then Union(Range("a1"), Range("d1:g1")).Copy Range("a4")
End Sub

 

[mani_singh]

ok let me try again. sorry

i have reference data in cell

m9 the macro needs to check cell N9, if its more than m9 then copy cells o9,p9,q9,r9 and s9 to cell a4,b4,c4,d4 and e4 respectivly on a sheet called "shift left abuse"

finally the macro neesds to go back to the1st page "shift left data" and drop to m10 and run the copy command again unitll the data on 1st page runs out.

thanks venkat!