Auto Populate Serial Number From Total number

Auto generate Serial number from to total number. Please download Attach sample copy

Not clear to me what you require:

=COUNTA(A3:A100)

will count number of sheets

Columns A to C are automatically incremented by dragging down

Put this in A3:

=IF(ROWS($1:1)>F$1,"","JRP101-P85-J00-"&TEXT(ROWS($1:1),"000"))

Put this in B3:

=IF(ROWS($1:1)>F$1,"","SURVEY SHEET NO: "&ROWS($1:1))

Put this in C3:

=IF(ROWS($1:1)>F$1,"",ROWS($1:1)&" of "&F$1)

and then copy those formulae down.

Hope this helps.

Pete

Column C is not: do you want this to update to "m" of "n" ?

in Column C (C3)

=ROWS($3:3) & " of " &$F$1

You have answer from Pete_UK

I need required result column A:C

Pete's answer gave you this.

Ohh yes it's work, Thank you every one for replay. Especially thank to pete.

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you should know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

@John,

Congratulations on reaching 1000 posts.

Pete

@Pete,
Thanks ... about matches my age (or feels that way sometimes!).