# Thread: Cells across with value from other worksheet

1. ## 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. ## 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. ## 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. ## 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. ## 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
•