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
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