If value is then copy
Can someone can help me??? I need a VBA code that will say¦
if value of cell A2 is equal to x then copy G2:P2 to worksheet test2
if value of cell B2 is equal to x then copy G2:P2 to worksheet test3
etc...
if value of cell A3 is equal to x then copy G3:P3 to worksheet test2
if value of cell B3 is equal to x then copy G3:P3to worksheet test3
etc...
There has to be a faster way??? I have 6 items to check across and 350
down (more will be added. Please note row 2 may have an x in A2 and B2 but
row 3 may only have an x in B3..... Thank you in advance
|