G Guest Feb 19, 2004 #1 I would like to use a form for preparing invoices, delivery notes etc. How can I keep the information for the invoices and delivery notes issued in a worksheet by just input the data once?
I would like to use a form for preparing invoices, delivery notes etc. How can I keep the information for the invoices and delivery notes issued in a worksheet by just input the data once?
B Bob Phillips Feb 19, 2004 #2 Janmy, Just add the field names in row 1, and then you can use Excel's built-in form functionality to add/update/delete (Data>Form...) on a worksheet. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Janmy said: I would like to use a form for preparing invoices, delivery notes etc. How Click to expand... can I keep the information for the invoices and delivery notes issued in a worksheet by just input the data once?
Janmy, Just add the field names in row 1, and then you can use Excel's built-in form functionality to add/update/delete (Data>Form...) on a worksheet. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Janmy said: I would like to use a form for preparing invoices, delivery notes etc. How Click to expand... can I keep the information for the invoices and delivery notes issued in a worksheet by just input the data once?