data entry form

Question

I want to make a data entry form in excel

id no:
name:
father name:
order date:
contact no:
amount:
payment method:

these entries on the form and if I enter id no in front of id no it shows all data of of relevant id no and am update this data as per my requirements

Answer 1

Hi, @Muhammad Asif

You can use the following steps to add data entry form to quick access toolbar:

1. Right click on existing icons in the quick access toolbar,
2. Click on 'Customize Quick Access toolbar',
3. In the 'Excel Options' dialog box that opens, select the 'All commands' option from the drop-down,
4. Scroll down the list of commands and select 'Form',
5. Click on the 'Add' button,
6. Click OK.
   Then you can select the table which contain all the data and click the icon.
   If you want to update the data, you can use find function and change the data in the table.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread.