Not very sure .. but perhaps you might want to quick browse this recent
thread (similar angle query) with responses for 2 approaches:
http://tinyurl.com/ddo6m
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nancyk4544" wrote in message
...
I'm working on a worksheet with 2 pages. The first worksheet has rows that
move to the other worksheet daily. Instead of copying them and pasting
them
and deleting them is there a formula that will move that row to the next
page?

I am using excel office 2003.