Ask Experts Questions for FREE Help !
Ask
    dragster1090's Avatar
    dragster1090 Posts: 24, Reputation: 1
    New Member
    		  
    #1

    Oct 5, 2010, 06:43 AM
    I need to auto generate sequential numbers based on the adjacent cell info
    For instance: When I have info in CELL B4 I need an auto generated number in CELL B5 starting with 2000
    CELL B4 CELL B5
    PFP 2000
    PL 2001
    STD 2002
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 5, 2010, 08:13 AM

    I think you meant when you type in B4, you want a number to appear next to it in C4, yes?

    Put the first number 2000 in C4 manually.
    Then in C5 put this formula and copy down as far as you wish:

    =IF(B5="", "", C4 +1)
    dragster1090's Avatar
    dragster1090 Posts: 24, Reputation: 1
    New Member
    		  
    #3

    Oct 5, 2010, 08:25 AM
    I am trying to auto number cell d4 when info is put into c4
    dragster1090's Avatar
    dragster1090 Posts: 24, Reputation: 1
    New Member
    		  
    #4

    Oct 5, 2010, 08:27 AM
    Comment on JBeaucaire's post
    I am trying to auto number cell D4 when info is put into cell C4
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #5

    Oct 6, 2010, 12:45 AM

    Adjust the formula given to the references in your columns. That formula watched column B and was placed in column C, so give it a try. What would the formula change to if the formula was in D4 instead?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

What two prime numbers, if multiplied, would generate a 400-digit number? [ 3 Answers ]

What two numbers, if multiplied, would generate a 400-digit number?

Auto Generating Sequential Numbers in Excel 2003 [ 2 Answers ]

Hello All I would like to have sequential Auto Generated Numbers in column A of my Excel 2003 Spreadsheets e.g A1=1, A2=2, A3=3 etc. But I would like Excel to auto generate this number, rather than input?

Auto-Generate a number [ 3 Answers ]

Hello. I am having an issue figuring out a way to go about this. Here's my scenario: The company I work for uses forms that we can put products, purchased by other companies for each order made. Each form has its own unique WT number. I've been assigned the task of making this form as an excel...

View more questions Search