T
trawets
Hi Guys
Could someone help with my problem, I have a simple defect recording spreadsheet, I would like to create a data entry form which I can do using the excel form command, however I would like to expand the functionality by having
the number being displayed and being auto-number. some other fields I wouldlike them to be list selection and dates (a calendar block would be nice).I know all this can be quite easily done using access but I'm not allowedto use this due to licencing restrictions
below is a full list of the fields in the sheet
DEFECT NUMBER _ Auto-number
COMPARMENT
DEFECT
DEFECT CODE /TRADE
PRIORITY _ List
DATE RAISED
Week No
RAISED BY _ List
STATUS _ List
DATE CLEARED
CLEARED BY _ List
Could someone help with my problem, I have a simple defect recording spreadsheet, I would like to create a data entry form which I can do using the excel form command, however I would like to expand the functionality by having
the number being displayed and being auto-number. some other fields I wouldlike them to be list selection and dates (a calendar block would be nice).I know all this can be quite easily done using access but I'm not allowedto use this due to licencing restrictions
below is a full list of the fields in the sheet
DEFECT NUMBER _ Auto-number
COMPARMENT
DEFECT
DEFECT CODE /TRADE
PRIORITY _ List
DATE RAISED
Week No
RAISED BY _ List
STATUS _ List
DATE CLEARED
CLEARED BY _ List