Cell References

[Guest]

I have 2 separate work sheets. I want to copy the values of cells in work
sheet A to cells in Work sheet B. The values in A are separated by at least
4 rows. Cells in B where I want those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
Is there a formula to add columns or rows such as cell A1+3 = cell D1 or
cell A1 + 3 = cell A4

 

[Paul Sheppard]

I have 2 separate work sheets. I want to copy the values of cells i
work
sheet A to cells in Work sheet B. The values in A are separated by a
least
4 rows. Cells in B where I want those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
Is there a formula to add columns or rows such as cell A1+3 = cell D
or
cell A1 + 3 = cell A4

Hi Gman

On sheet b insert 3 extra rows then do the copy and paste, then delet
the 3 row

 

[Morrigan]

Not sure if this will do what you want, but give it a try.

Let's say A1, A5, A9, etc contains your data in Sheet A. Then in Shee
B:

A1 = OFFSET('Sheet A'!$A$1,(ROW()-1)/2*4,0)


Hope it helps.