creating a sheet 1 of

  • Thread starter Thread starter Lenny
  • Start date Start date
L

Lenny

I am creating an excel form (2003). Because of the format, I cannot use
excels worksheet automatic numbering. I have set up two cells, side by side
to hold the entries: SHEET | OF | is there a way that Excel can
automatically number the sheet and correctly enter the number of total
worksheets in the file?

This is a no brainer in Word, I would just use the pageno and numpages
fields but this is new for me using Excel.

An explanation or help is always greatly appreciated

Lenny
 
Lenny wrote:
Don: my thanks for taking the time to respond, however, what do I do with
the information you provided below? Is it a formula? Where does it get
added (what cell(s)) and to which sheets in a multi sheet workbook? I
assume(?) that once placed on any of the worksheets, it will move when a
worksheet is copied?

Sorry - but this is real newbie territory for me. Things just don't seem to
work the way they do in Word tables..... regards
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top