Results 1 to 5 of 5
  1. #1
    The Robber
    Guest

    Cells across with value from other worksheet

    G'day,

    Similar problem to earlier. I'm half way there using Offset. I need to fill cells going across one worksheet continually using information from the second worksheet. The info on the second worksheet's info goes down the sheet and will be added as it comes to hand throughout the year. The info will always be 25 cells below the last cell. EG. G6 = 'Sheet 2'!C14 G7 = 'sheet 2'!C39. Is there a formula to be able to do this without having to manually fill in a whole years worth?

    Thanks in advance. Rob

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells across with value from other worksheet

    Rob,

    This is a very similar problem to the other one. The formula would be something along the lines of:
    G6 = Offset('Sheet2'!C14,(row()-6)*25,0)

    Jon

  3. #3
    The Robber
    Guest

    Re: Cells across with value from other worksheet

    John,

    We are getting there. It picks up the correct cell for G6 but I need to be able to paste it along the 6 row so as the other cells pick up what is 25 cells below Sheet 2!c14. The results that are coming up are all over the place. I can't seem to find any common factor.

    Cheers Rob

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cells across with value from other worksheet

    I think it should be something like

    G6 = Offset('Sheet2'!$C$14,(column()-6)*25,0)

    The second argument moves down 1 row for every column you move across and the $'s in $C$14 make sure that the first argument stays at c14 when you copy it across the row.

    Ian.

  5. #5
    The Robber
    Guest

    Re: Cells across with value from other worksheet

    As per the last note on the other problem. Cheers Jon

    Rob

Posting Permissions

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