Copying data from another sheet

[n00bz0rd2]

Hi all,

I'm trying to copy data and reformat it from one sheet to another and running into some problems.

(Note: the row/column numbers are different on my actual sheets)

I have Sheet1 setup as follows:
[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FABF8F"][/TD]
[TD="bgcolor: #FABF8F, align: right"]WK1[/TD]
[TD="bgcolor: #FABF8F, align: right"]WK2[/TD]
[TD="bgcolor: #FABF8F, align: right"]WK3[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Product 1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Value[/TD]
[TD="align: right"]£5787[/TD]
[TD="align: right"]£1211[/TD]
[TD="align: right"]£4431[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Volume[/TD]
[TD="align: right"]578[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]443[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Product 2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Value[/TD]
[TD="align: right"]£1,397[/TD]
[TD="align: right"]£1,382[/TD]
[TD="align: right"]£1,170[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Volume[/TD]
[TD="align: right"]1397[/TD]
[TD="align: right"]1382[/TD]
[TD="align: right"]914[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Product 3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Value[/TD]
[TD="align: right"]£981[/TD]
[TD="align: right"]£1,079[/TD]
[TD="align: right"]£1,144[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Volume[/TD]
[TD="align: right"]981[/TD]
[TD="align: right"]1082[/TD]
[TD="align: right"]1148[/TD]
[/TR]
</tbody>[/TABLE]


On sheet 2, I want to re-organise the data into a better format as I will need to add more information, which the design on Sheet1 doesn't allow.
[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: center"]WK1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]WK2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]WK3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Value[/TD]
[TD="align: center"]Volume[/TD]
[TD="align: center"]Value[/TD]
[TD="align: center"]Volume[/TD]
[TD="align: center"]Value[/TD]
[TD="align: center"]Volume[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Product 1[/TD]
[TD="align: right"]5787[/TD]
[TD="align: right"]578[/TD]
[TD="align: right"]1211[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]4431[/TD]
[TD="align: right"]443[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Product 2[/TD]
[TD="align: right"]1397[/TD]
[TD="align: right"]1397[/TD]
[TD="align: right"]1382[/TD]
[TD="align: right"]1382[/TD]
[TD="align: right"]1170[/TD]
[TD="align: right"]914[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Product 3[/TD]
[TD="align: right"]981[/TD]
[TD="align: right"]981[/TD]
[TD="align: right"]1079[/TD]
[TD="align: right"]1082[/TD]
[TD="align: right"]1144[/TD]
[TD="align: right"]1148[/TD]
[/TR]
</tbody>[/TABLE]

So I have a formula in sheet 2 that looks up values from Sheet 1, for both the Value and Volume figures. This works fine and I can copy the formula down for each product:
=OFFSET(Sheet1!B$3,(ROW(Sheet1!$B3)-5)*3,0) would be in B3
=OFFSET(Sheet1!B$4,(ROW(Sheet1!$B3)-5)*3,0) would be in C3

When I copy the formula across, the formula skips columns. Is there a way I can avoid this?

Hopefully this is make sense!

Thanks.