Data Entry Form

lfellows

New Member
Joined
Nov 22, 2019
Messages
35
Hi,

I'm trying to create a data entry form which will populate cells within a table on another sheet. I am aware you can use the form button but it does not have the level of customisability that I'm after.

The workbook is used to collate scrap quantities found at different stages of a process. It contains two sheets: One sheet that will contain the data entry form and the other sheet will have the table of information.

There are 20 columns that I would like to fill:

DATESTART TIMEEND TIMEOPBATCHTYPESTART QTYPROCESS 1PROCESS 2PROCESS 3PROCESS 4PROCESS 5PROCESS 6PROCESS 7PROCESS 8PROCESS 9PROCESS 10PROCESS 11PROCESS 12END QTY

The columns which are non-bold would be a simple manual input.

The columns which are bold, if possible I would like to be able to have a drop down list to select which process the scrap goes into i.e. if there is 10 scrapped at process 7, you would select process 7 from dropdown list and input 10

I will upload an image of the sheet if it's any help.

Thank you for any assistance. I'm not even sure if what I'm asking for is achievable.

1576148070978.png
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Glad you sorted it & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top