Coping To next sheet based on cells

[Starrpro]

Can I write a formula to copy a entire row to the next sheet on the second of
each month if say cell A1 does not equal "x" then automaticlly change cell A1
to "Z"

 

[Frank Kabel]

Hi
as a starting point:
http://www.rondebruin.nl/copy5.htm