form help

[dreamdragon]

i have a spreadsheet with info in it as follows:-
column A has employees ID numbers.
column B has christian names.
column c has surnames
column d has amount of products sold.

What i want to do is create a form on sheet 2 which i will name 'Form' and this will be used to add details ie id, christian name, surname and products sold to sheet 1 which i will name employees, can any one tell me how to do this please,

 

[DominicB]

Good morning dreamdragon

This sounds like the kind of job for a UserForm – basically a user defined dialog box which can interact with your spreadsheet. The problem? It’s not that easy to do what you require and will require a lot of learning and hard work on your part and probab;y frequent visits to sites such as this. To design a userform, from Excel press Alt + F11 and go to Insert > UserForm.

An easier solution would be to use Excel’s built in data entry form – go to Data > Form.

HTH

DominicB