Tillie, this will get you to the next row in column A
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select

and something like this to clear the data
Sheets("sheet1").Range("A1:C10").ClearContents

post back if you need anymore help with this


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Tillie Rose" wrote in message
...
I am tracking daily information with a formula for weekly results. I then
want these results to enter into another worksheet to track monthly
results.
My problem is I can not get it to go to the next line/week on the
spreadsheet. It just replaces the previous week. Is there a macro that
will
tell it to go to the next week line on the monthly worksheet and then
clear
out the data to start a new week on the 1st worksheet?
Thanks