I'd start at Debra Dalgleish's site:
http://contextures.com/xlForm02.html



SHARON wrote:

Please help....

I am creating a "form" on sheet one and inputting text in 5 cells
Column A Column B
ex. Input Serial #: ____________
Input location: ____________
etc...

How can i get the text in those column b cells to move over to sheet 2 in a
columnar spreadsheet.

Ideally my thought is to have a "button" you would press that would say
"complete" and then the data from those 5 cells would move to sheet 2 columns
a-f row 1, and then those 5 cells would clear in sheet 1 to be able to enter
more data in those same 5 cells which would move to columns a-f row 2.

Hope this is clear enough for you to understand, if not just ask for further
clarification. Thanks!

--
Thanks,
Sharon

--

Dave Peterson