hi,
iam having many sheets within same workbook and i wanna have a serial number
for each sheet as a document number - for example:
sheet 1 have a serial no : 001
Sheet 2 have a serial no : 002

how to make it without entering it manually for each sheet

Hi,

Wher do you want the serial number, in a cell or as the sheet name?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Serial number in many sheets" wrote:

hi,
iam having many sheets within same workbook and i wanna have a serial number
for each sheet as a document number - for example:
sheet 1 have a serial no : 001
Sheet 2 have a serial no : 002

how to make it without entering it manually for each sheet