Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Autofill worksheet numbers

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Surfers Paradise
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have spread sheet I am designing that has columns with the following formula in them

    =Sheet(2)$c$20
    =Sheet(3)$c$20

    This can run through to 100 sheets is there a way I can Autofill the Sheet numbers.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-07 16:21, Lewy2 wrote:
    I have spread sheet I am designing that has columns with the following formula in them

    =Sheet(2)$c$20
    =Sheet(3)$c$20

    This can run through to 100 sheets is there a way I can Autofill the Sheet numbers.
    I assume you mean...

    =Sheet2!$C$20
    =Sheet3!$C$20

    If so, you could enter "Sheet2" into a cell (e.g., A1) and fill down by dragging the Fill handle. In an adjacent column (e.g., B1) enter the formula, ="="&A1&"!$C$20".

    Now, you can select, Copy and overlay the formulas in column B with their resulting values by using Paste Special... Values. Finally, with column B still selected use Edit | Replace... to replace = with =.

    [ This Message was edited by: Mark W. on 2002-04-07 16:45 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •