Drag and autofill
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Drag and autofill

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I don't know whether it is a silly question but i really can't solve it.
    in Sheet1:
    in Cell A1 I input formula ='Sheet2'!$A1
    in Cell A2, ='Sheet2'!$A4
    I want to use Select and drag to autofill the subsequent. But fail. I have also added a series 1,4,7 to the series. I have used Macro to solve this problem, but how to use select and drag to auto fill the formula?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try with:

    =INDIRECT("Sheet2!A" & (3*ROW(A1)-2))

    and drag down.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    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

    Here's another way... that will leave the simplest formula in these cells.

    1. Enter "Sheet2!$A1" (without the quotes) in cell Sheet1!A1 (or wherever).
    2. Enter "Sheet2!$A4" in cell Sheet1!A2.
    3. Select cells A1:A2 and drag the fill handle down the column as far as needed.
    4. Select column A:A and choose the Edit | Replace... menu command replacing all instances of "Sheet2" with "=Sheet2".

    [ This Message was edited by: Mark W. on 2002-02-26 06:59 ]

    [ This Message was edited by: Mark W. on 2002-02-26 07:15 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks!!! Juan and Mark. Both of your methods works fine!!

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    20 Minutes outside Manhattan
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    q

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
  •  

 

 
DMCA.com