What I need is very small and simple.
I need a excel form with 4 automatically filled out fields.
1: name of customer (taken from a list in sheet 2 of the excel work book).
2: date of creation (automatically filled out with todays date)
3: a drop down list with products (taken from a list in sheet 3 of the excel work book).
4: a running number (the order number, counting one up every time a new document is created). This is not a need to have, but a nice to have. So it can be dropped if it is too much trouble.
I will deliver the front page and the lists for sheet 2 and 3.
I know that this is very small, but I cannot get it to work properly.