Forms in Excel

RobK · Mar 30th, 2004, 05:01 PM

Sorry for the simple question ... it is probably something taught in Excel 101, but I am at a loss.

Suppose I use an Excel worksheet (protected sheet, conditional formatting etc) as a user form. How do I:

a) place the entered information as a record in the last row of a database on a separate sheet?
b) allow the user to continue to subsequently enter new records (reset the form and continue to add records until finished?

Mar 30th, 2004, 05:01 PM	#1
RobK Join Date: Mar 2004 Posts: 21	Forms in Excel Sorry for the simple question ... it is probably something taught in Excel 101, but I am at a loss. Suppose I use an Excel worksheet (protected sheet, conditional formatting etc) as a user form. How do I: a) place the entered information as a record in the last row of a database on a separate sheet? b) allow the user to continue to subsequently enter new records (reset the form and continue to add records until finished?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode