sorry but i need help :-(

[nanooksky]

Hi,

First time here (WHAT A GREAT SITE)

I have a set of addresses on tab 1, divided into two coloums (D:1 D:60) (house number) and (E:1 E:60) (street name)

now...


On tab 2 i have a sheet i have to fill in using the info from tab 1 but the addresses go (C:7 BJ:7) for the house number and (C:8 BJ:8) for the street name.

when i try to link the cells and "pull" the formula accross it all goes wrong and for the life of me i cant figure out why i've played around using the "$" too.

hope you can help thanks



Nanook

 

[Andrew Poulsom]

The $ fixing won't work because you are tranposing the data. You can use:

=INDEX(Sheet1!$D1:$D60,COLUMN(C7)-COLUMN($C7)+1)

or you can select C7:BJ7 type:

=TRANSPOSE(Sheet1!D1:D60)

and press Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround this array formula with curly braces {}.

 

[nanooksky]

Andrew.....You ARE the Man!!!


Thankyou very much its appriciated.


Nanook