Form to auto-Format Sheets

[sowetoddid]

Is it possible in Excel to create a form that users fill in with information. Based on that information, the spreadsheet would be formatted.

The format of the spreadsheet is unique to each engine. If the user inputs a four cylinder engine, the spreadsheet would have four sections of data to input. If it is six cylinder, they would have six sections. There are several other sample differences.

In some sections of the form, they would input the name of the engine, the cylinder sizes, etc. Then when the excel sheet was formatted, this information would be put into the assigned cells.


Is this a reasonable explaination? If so, please help, even if it is basic info to get started.


Thanks!

[sowetoddid]

Is this done easier in Microsoft Access