Invoice Numbers
in [Functions]
|
From: MIKEY on 28 Feb 2010 07:18 Hi all I want to automate Invoice numbers to my spreadsheets. I have saved the file as Read Only. When I open my Excell 2003 I enter client details. I want an invoice number allocated to this client upon being saved. When I open this client file the next day to update details I don't want the Invoice number to change. Is it possible to numeric Invoice numbers from a Read Only File, as I will only access this file when dealing with a new customer, and this is when I need the next invoice number Many thanks if you can help Mike
From: Mike H on 28 Feb 2010 07:44 Hi, The best methods are described here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "MIKEY" wrote: > Hi all > > I want to automate Invoice numbers to my spreadsheets. I have saved the > file as Read Only. When I open my Excell 2003 I enter client details. I > want an invoice number allocated to this client upon being saved. When I > open this client file the next day to update details I don't want the Invoice > number to change. > > Is it possible to numeric Invoice numbers from a Read Only File, as I will > only access this file when dealing with a new customer, and this is when I > need the next invoice number > > Many thanks if you can help > Mike
|
Pages: 1 Prev: protect marker Next: Conditional Format to highlight rows |