Worksheet Data Entry Form in Excel

With a bit of programming, you can make it easy for users to enter data in an Excel workbook, and keep them away from the stored data.

Sample Data Entry Form

Dave Peterson created a sample workbook with a worksheet data entry form.

Data Entry Features

In the worksheet Data Entry form, there are data validation drop down lists in cells D5 and D7.

The quantity number is typed in cell D9.

After you fill those 3 cells, click the Add to Database button.

A macro runs, and your new record is added at the end of the database, which is a list stored on a different sheet.

View the Stored Records

In Dave’s workbook, you could click the View Database button to go to the database sheet, and review or edit the existing order records.

Worksheet Scroll Buttons

In some cases you might prefer to hide the database sheet, to protect the records, but still allow users to view the existing data.

I’ve added a few buttons to Dave’s workbook, to allow users to scroll through the existing records.

Navigation Buttons

The navigation buttons take you to the first, previous, next or last record.

Or, you can type a record number in the yellow cell, to go to a specific record.

Go To Database Button

In the updated workbook, I left the “Go To Database” button on the data entry worksheet.

You could remove that button, and hide the PartsData sheet, if you prefer, so users are less likely to change the data.

Download the Sample File

The zipped sample workbook can be downloaded from the Data Entry Worksheet Form page on my website.

In the Download section, look for Version 2 – Navigation Arrows.

More Articles on the Worksheet Data Entry Forms

New Improved Excel Data Entry Form

How to Customize the Excel Data Entry Form

Delete Orders with Excel Data Entry Form

Check Excel Database Before Adding New Item
___________________________