Dave,

I haven't used macros much, so i am trying to work off the sample workbook
that was used in the website you sent me to...I am just trying to figure out
how to clear the drop down boxes and make them regular empty cells.
--
Thanks,
Sharon


"SHARON" wrote:

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