Formula to number a line item to create an order 1,2,3 etc.

Options
Dahya
Dahya Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

I am creating a module that will be a template to import into our ERP. One of the line items is called 'Journalnum' which essentially needs to start at 1 and every line thereafter will be 2, 3 4, etc. E.g. in excel cell A1 is journal number 1 and cell A2 will be a formula to equal A1+1. There are 1000+ lines in the template.

Tagged:

Comments

  • Dahya
    Dahya Member, ALL USERS Posts: 4 New Contributor

    Thank you both for the above, I think that's you've explained it very well. I will give it a go and let you know if this answers my question. Thank you!

Categories