Custom Data Entry and Edit Form 1

[Tripp]

Say I have a project where I need to design 10 steel beams. I can create a spreadsheet that will do all the design checks for a given set of input data, thats no problem, but after designing 10 beams I would have 10 different spreadsheets.

I would like to create a workbook where I can enter the input data sets using a custom form which would store the data in a table on one of the other worksheets in the same workbook. Then in my calculation sheets I would select which data set to calculate on using a combo box to pick the data set.

I have no probelm using the combo box to lookup the data in the table, but does anyone know of a simple (i.e. no VBA) way to create a form that will allow me to enter and edit the data in my data table?

Thanks for your help.

Tripp

 

[Mala]

Try setting up the design data in the form of an Excel list (Database), select any cell within the list and then use Data>Form from the menu to edit/enter data for individual beams in the list.
Good Luck!