If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
EXCEL Mask for data entry
I don't have MS Access but I want to create an Access
type Entry Mask for the entry of data into appropriate cells within a background work sheet. I want to create this as a simple entry form for non Excel users. The form would have 6 column and there would be a need for a look up table so when I entered an equipment asset number, its appropriate serial number would auto insert? Am I being too hopeful that such a facility exists within Excel? If by chance it does, where would I look for instructions? Hopefully Bill |
#2
|
|||
|
|||
This is very possible in Excel but there are a few things
to understand first. The simplest way is simpy to modify a worksheet so that only some cells are not locked and have validated values (look up 'protecting sheets' , locking cells and cell validation in help if you do not know how to do this). You will then need to have some hidden cells to create the values you need. These would use lookups (probably VLOOKUPs) to find the relevant data from a reference table, probably on another worksheet. Again look up 'vlookup' in help. I would not recommend you to start using forms in excel utnil you have a good grasp of visual basic etc.. -----Original Message----- I don't have MS Access but I want to create an Access type Entry Mask for the entry of data into appropriate cells within a background work sheet. I want to create this as a simple entry form for non Excel users. The form would have 6 column and there would be a need for a look up table so when I entered an equipment asset number, its appropriate serial number would auto insert? Am I being too hopeful that such a facility exists within Excel? If by chance it does, where would I look for instructions? Hopefully Bill . |
#3
|
|||
|
|||
Hi
some things you have to do :-) See the following links for some direction: 1. Create a listbox: http://www.contextures.com/xlDataVal01.html 2. Autofill the serial - number: http://www.mvps.org/dmcritchie/excel/vlookup.htm 3. Dataform: http://j-walk.com/ss/dataform/index.htm -- Regards Frank Kabel Frankfurt, Germany "Bill" schrieb im Newsbeitrag ... I don't have MS Access but I want to create an Access type Entry Mask for the entry of data into appropriate cells within a background work sheet. I want to create this as a simple entry form for non Excel users. The form would have 6 column and there would be a need for a look up table so when I entered an equipment asset number, its appropriate serial number would auto insert? Am I being too hopeful that such a facility exists within Excel? If by chance it does, where would I look for instructions? Hopefully Bill |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Macro help please: Excel data to word doc | anna-maria | General Discussion | 5 | June 30th, 2004 11:53 PM |
Excel 2000 crushed | Sue | General Discussion | 3 | June 30th, 2004 12:25 AM |
Field code to pick up Excel sheet | Lyndie | Mailmerge | 1 | June 2nd, 2004 11:57 AM |
Error opening an excel file from explorer | Wah | Setting up and Configuration | 3 | February 17th, 2004 03:28 PM |