Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,421
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I have a formula in a sheet named summary containing the following formula in Cell C3 =Sheet1!AG152 if I copy this formula to D3, it must appear as =Sheet1!AF152 etc

    Your assistance in developing a formula that will allow me to do this when copying will be appreciated

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You try something like this:

    =OFFSET(Sheet1!$AG$152,-ROW()+3,0)

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I suspect you mean

    =OFFSET(Sheet1!$AG$152,0,-COLUMN()+3)


    Placed in D3 and then Copy RIGHT.



    Andrew

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes i did

Posting Permissions

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