ultraclean
New Member
- Joined
- Jul 7, 2005
- Messages
- 2
I use Excel for invoicing a book keeping.
I want to keep an up to date Stock list for our business.
I use an exact copy of our order form for making invoices, ie each item is listed as per the order. These are generated as a new Excel file for each invoice.
I have another Excel file with all our stck listed.
I just want to update this each time an invoice is completed.
I could put a SUM in each box, but that only works when you have the invoices completed.
All invoices are named 'invoice***' ***=number.
Can i enter a formula to look at all invoices between no: 1 & 99999?
The cell location never alters, only the file names.
Thanks.
I want to keep an up to date Stock list for our business.
I use an exact copy of our order form for making invoices, ie each item is listed as per the order. These are generated as a new Excel file for each invoice.
I have another Excel file with all our stck listed.
I just want to update this each time an invoice is completed.
I could put a SUM in each box, but that only works when you have the invoices completed.
All invoices are named 'invoice***' ***=number.
Can i enter a formula to look at all invoices between no: 1 & 99999?
The cell location never alters, only the file names.
Thanks.