Data Entry Form

As I am doing my graduation internship right now, my assignment is to setup a measurement system. After some problems and questions on this excel forum, a lot is solved.

Unfortunately, I ran into another problem again.

The operators in the factory are writing down their performances on sheets for me, and their bosses will enter the data into excel.

To enter the data, I created a data entry form in Excel. As in the picture shown below (Just an example, not the actual one).

Image-7a.png

The problem I ran into today is that Excel says: ''Too many fields in the data form'' and therefor the data form will not be created and can not be filled with data.

Obviously, the most simple answer would be: Delete some columns and my problem is fixed. Unfortunately, I can not delete any columns since they all provide data that I need to analyze. My columns go from A to AK right now.

My question is: Is it possible to create something similar to the data entry form, to make data entry easy? Or is there a solution to create 1 chart from multiple PivotTables that have data from different worksheets with different column names.

I tried to figure it out myself, but just couldn't find it.

I hope you guys can help me. Thank you.

Originally Posted by MarvinP

Hi Jompje,

There is an Enhanced Data Entry Form that is free and downloadable from John Walkenbach at:

http://spreadsheetpage.com/index.php/dataform/home

See if this one works for you. Why build another tool that has already been created. You can buy the code for a very small amount if you need the VBA.

Thank you for your reply MarvinP. This is indeed a solution, but I'm not sure if I'm allowed to download 3rd party extensions or software, because of security reasons. I will ask, but until then I will need another solution.