Macros

[Hentzer]

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

 

[Don Guillett]

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

 

[Hentzer]

Sorry but thats doesnt make much sense to me, I need it to come from a check
box i.e when I check a certain box it jumps to next free row on a certain
worksheet, can I also point out I am using excel 2000, p**p I know but its
all I got at present ;oD

 

[Don Guillett]

know of an alternative to automatically take data from one sheet to