Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create form to add data to Excel 40 odd columns | Excel Discussion (Misc queries) | |||
Create a data entry form | Excel Discussion (Misc queries) | |||
Drop-Down Menus in Data Entry Form? | Excel Discussion (Misc queries) | |||
a data entry form with combo box | Excel Discussion (Misc queries) | |||
How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) |