• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

User Input to populate Rows on separate sheet

Karlis Peterson

New Member
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.
 
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.
 
Back
Top