It might help if you gave example of the data and what determines if it is
to be copied, and where it is to be copied
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"ramzi" wrote in message
...
hi,
how to create macro for me to copy only cell with contains.
let say range from a1 to c8.
1st copy let say a1 to c4 only have cotains value and for next copy the
value at
a1 to c6.
the contains of cell keep on changing but within a1 to c8.

how to do this,...
thanks in advance....