Data > Form Invoice. And an OpenOffice Calc Question

[MidNiteRaver]

Hi Board

I have an invoice that has the usual headings (logo, name, address, Bill to, Ship to, Qty, Unit, Description, Price, extension) and usual stuff at the bottom (Freight, Tax, Total, Comments, etc).

The invoice has 10 lines for entry ( I use vlookup and the cat# to reference another sheet for data that fills in description & price).

Is there any way that I can use DATA>FORMS to enter the line items and use it to expand pass the 10 line items to the point where it makes additional pages, while retaining the data at the bottom of the invoice (Freight, Tax, Total, Comments, etc)?

Presently I have to make two versions of the invoice, 2 page and a 1 page, as I don't trust the users to add rows with formulas.

Secondly does anyone know if Calc OpenOffice has a similar feature Excel's to DATA>FORM. We have 3 CPU that have OpenOffice installed and not MS Office.

Any help would be greatly appreciated.

MidNiteraver

 

[Smitty]

Why not just add a button that will inset a new row?

ActiveCell.EntireRow.Insert

Your formula range will automatically expand that way.

Note that's not necessarily the most reliable though. You'd probably be better off finding the end row of the data entered and enter a new row there. You can use that with End(xlDown). If you post the range in question someone can come up with the appropriate code.

HTH,

 

[MidNiteRaver]

Just decided to review all my posts and I notice that I didn't thank you.

Sorry for the delay but thanks for the rsponse. Greatly appreciated.

MidNiteRaver