Can I create an entry form that will feed a data sheet

[Guest]

I have a number of people who will enter data: name, date, age, gender. In
order to avoid having Joe inadvertantly change that which Bob has entered, I
would like to create a data entry form that would feed the data sheet. This
way, Joe wouldn't have access to what Bob entered but Joe's entry would be
added to the sheet that contains the data entered by both Bob and Joe. Is it
possible to create a form to enter data that will feed another worksheet?

 

[Debra Dalgleish]

There are instructions here for creating a UserForm that adds data to a
hidden worksheet:

http://www.contextures.com/xlUserForm02.html

 

[Guest]

Excel has a built in form as long as the spreadsheet has headers. Go to DATA

 

[Debra Dalgleish]

True, but it doesn't add data to another worksheet, which is one of the
specifications.