How you can get an atomatic serial number in a particular columnClosed

Question

Hello,
Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2....... 
Now if you entered an amount in D1 cell, how you can obtain an atogeneration number (say 101) in E1 cell (invoice numver). Again you entered an amount in D5 cell, how you can obtain next serial number (102) in E5 cell (invoice numver, and so on.
Thanks

Zohaib R · Answer

Hi newazz,

Use this formula in F2 and then drag using Microsoft Excel's fill handle till the end of data:

=TEXT(ROW(A1),"100")

This formula will populate the respective cells with serial number starting from 101. You can replace "100" with your desired sequence.

Do reply with results.

rizvisa1 · Answer

Since first invoice is in D1 and 2nd in D5, and you want numbers to be 101 and 102 respectively, you would need a macro to do that. 

From you question it seems to me that you want number to be generated when a cell in D column is populated. Will there be any thing else in D column (lets say in D2) for which you do not want auto number to be present in E2.

How you can get an atomatic serial number in a particular column

2 responses

Similar discussions

Subscribe To Our Newsletter!