I hope someone can help.

I have an excel document with two work sheets, the first is for ongoing activities and the second is completed activities.


What I need is to be able to assign a (macro)button so that when a task is complete once pressed it will cut out of the first worksheet and into the second worksheet(i'll do a button for each row.)

Now this is all fine I can do this but the problems I can't get round is that when I run the macro I want it to find the next available line to copy the text into, i can only tell it to go to a specific line which is no good. can excel recognise that say A10 has data in it and therefore put it in A11

Please help if you can, i'm going crazy