Hello.
Im a newbie so please bare with me! I'm sure i'm just being silly but I cant seem to get data into a combo box (made from the control toolbox) from another sheet. The sheet im trying to get the data from is (unoriginally) called Data and the cells are A4:A7
Ive tried going into properties, linked cells and putting Data!A4:A7 but I get nothing. I don't mind if i have to put it in manually but I just can't seem to find any information on how to do this.
Thanks in advance
Katie
Im a newbie so please bare with me! I'm sure i'm just being silly but I cant seem to get data into a combo box (made from the control toolbox) from another sheet. The sheet im trying to get the data from is (unoriginally) called Data and the cells are A4:A7
Ive tried going into properties, linked cells and putting Data!A4:A7 but I get nothing. I don't mind if i have to put it in manually but I just can't seem to find any information on how to do this.
Thanks in advance
Katie