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

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?

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

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

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

tlc wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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

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


"Debra Dalgleish" wrote:

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

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

tlc wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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

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

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

Form



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html