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

 

[Stephan Hoenselaar]

Help requested...

Nanooksky,
Try on Sheet2 cell C7:"=INDIRECT(ADDRESS(COLUMN()-2,ROW()-3,4,1,"Sheet1"))"
Good luck...

 

[ravishankar]

Hi

You can simply copy D1:E60 and paste special at sheet2 C7 and click transpose option.
Ravi