User Input to populate Rows on separate sheet

[Karlis Peterson]

I am a newbie to Chandoo - so excuse my question. Looking for an example where I can have a sheet with a list of questions which allows a user to fill in answers freehand and with drop down (Data Validation) and once entered/submitted it will create a NEW row on another raw data sheet.

Also, is there any validation that ensures the format is current?

Thanks in advance.

 

[Luke M]

Hello, and welcome to the forum!

Debra's got some wonderful starter entry forms over at her website. I'd recommend starting here:
http://www.contextures.com/exceldataentryupdateform.html

It's a nice tutorial that shows you how to build the form, which IMO, would recommend so that you better understand how it works. But, if you're happy with the default layout, there is a download at end of article. Debra's form uses Data Validation, and stores/edits the records on another sheet.