Thank you I will try that.
--
Thanks,
Sharon
"Dave Peterson" wrote:
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