For sure you'd get more answers in an Excel related news group. this one is
for Outlook.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sat, 29 Sep 2007 16:16:00 -0700 schrieb Bobbykm:

I am entering info into Excel Sheet1 A1, B1, C1, D1. I want to click a
button (Submit) to move info to Sheet2 A1, B1, C1, D1. After I click
button
I would like Sheet1 to be ready for new entries which when Submit is
clicked
again will be moved to next rows on Sheet2 (A2, B2, C2,D2).

thanks
Bobby