Automated invoice numbers

**pcspike** · 12-15-2011, 10:51 AM

Hi,
I have a sheet that lists my customer’s records including invoices, with a pre-existing column of consecutive invoice numbers in place. Would it be possible to have these invoice numbers appear automatically as I enter invoice details rather than the pre-existing column on the sheet?

**royUK** · 12-15-2011, 02:40 PM

Need to see an example

**pcspike** · 12-15-2011, 06:24 PM

Sorry but difficult to describe.
If my invoice numbers were to be displayed in column C, and the start number was 192 in C1, I’m looking to column C2 to automatically display 193 when I start inputting information in row 2 at B2 for example and the same for C3 and so on.
Hope that’s bit clearer

**ATufts** · 12-15-2011, 06:55 PM

This is not exactly what you are looking for, but you don't have to put all of the values in manually. You can enter a few, and then highlight the filled cells and drag to the right and excel should autofill the next numbers. Alternatively, in cell 1 of column B:

=if(B2="","",A1+1)

Would require the first value in the sheet (A1) to be put in manually, but all of the others would autofill if you copied it across.

**pcspike** · 12-16-2011, 09:18 AM

Originally Posted by ATufts

This is not exactly what you are looking for, but you don't have to put all of the values in manually. You can enter a few, and then highlight the filled cells and drag to the right and excel should autofill the next numbers. Alternatively, in cell 1 of column B:

=if(B2="","",A1+1)

Would require the first value in the sheet (A1) to be put in manually, but all of the others would autofill if you copied it across.

Had a few goes with this but unable to get a result. Can you provide more info please?

**martindwilson** · 12-16-2011, 09:22 AM

in c2 =if(B2="","",c1+1) dragged down

**pcspike** · 12-16-2011, 09:48 AM

Hi,
Managed to find something that does exactly what I want at this link http://spreadsheetpage.com/index.php...ist_numbering/ I would appreciate some help in adapting it to my sheet.

In my sheet the invoice numbers start at 192 in column C at C5 with details in column B