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

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

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" wrote:

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

know of an alternative to automatically take data from one sheet to
another
if a cell says a certain thing?


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hentzer" wrote in message
...
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" wrote:

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