This could be incorporated into a worksheet_change event within the sheet
module to make it truly automatic.
sub copyif()
if range("a2")="move" then range("a3").copy sheets("sheet2").range("a3")
end sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hentzer" wrote in message
...
Hiya


I am trying to conect a macro to a check box but I want the macro to go to
the next free line on a certain workbook page, how do I do this? Or do
you
know of an alternative to automatically take data from one sheet to
another
if a cell says a certain thing?

Thanks

Angi