Continuous subform in Excel?

Hello!

I am familiar with MS Access and the construct of continuous subforms where you can add/change/delete records, but I have never done them in Excel.

For my project, the user has a big piece of equipment (ex, car) and then needs to enter data for any parts that need replaced.

The final report would look like:

Car

Line Item Number - Qty - Description - Part Nuumber - Material - Batch Number.

So, if one part is needed, only one row would be devoted to this. If many parts need repair, devote more rows.

Before I start banging this out, is there something like this setup already out there?

V/R,

Lost

All,

This thread solution is summarized by the following thread:

http://www.excelforum.com/excel-prog...ot-blanks.html

At the bottom of that thread, you will find two workbooks: one which adds rows at the bottom of a sheet, and another which adds rows in a middle section of a sheet.

99.9% of the tough stuff was by virtue of the Excel geniuses in this forum. Thanks all for helping complete a project which will make work easier for many, many people!

Respectfully,

Lost