Linking Problem

[teenkoo1978]

how to link the cells which are in a row but data are followed by the blank cell to adjacent cell in a different work book
Let be the data Like Table-1
Table-1

	A	B	C	D	E	F	G
1	Good		Better		Best		Wrong
2

<tbody>
</tbody>

Now I have to get these data like Table-2 using formula or dragging method
Table-2

	A	B	C	D	E	F	G
1	Good	Better	Best	Wrong
2

<tbody>
</tbody>

Please help me in this regard
Thanking You

 

[deanst]

Hi - assuming there is always data followed by one blank cell and not varying numbers of blank cells in between the following will work.

Let's assume your data is on Sheet1 from cell A1 and you want to put the formula in cell A1 of Sheet2.

=OFFSET(Sheet1!$A$1, 0, (COLUMN(Sheet2!A1) - 1)*2)

Fill to right and it should work.

Hope this helps.
Dean.

 

[teenkoo1978]

Thank You deanst it work perfectly