MidNiteRaver
New Member
- Joined
- Jul 18, 2005
- Messages
- 32
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
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