I have two sheets in a book and got the following problem. In sheet 1 row 1 I have info from culomn a to af but in sheet two i want to link this same info but in column a from row 1 - 31. How do I go about after i linked cell a1 in sheet 2 to a1 in sheet 1
I try to link it as follows
sheet 1 a1 to sheet 2 a1
sheet 1 b1 to sheet 2 a2
sheet 1 c1 to sheet 2 a3
but when I use the copy link command and the fill handle excell does this
Sheet 1 a1 to sheet 2 a1
sheet 1 a2 to sheet 2 a2
sheet 1 a3 to sheet 2 a3
how do you let excel know that it must use the info from sheet a1 to af1 and link it to sheet 2 from a1 to a31
Sound easy but i can't.....help please.....
I try to link it as follows
sheet 1 a1 to sheet 2 a1
sheet 1 b1 to sheet 2 a2
sheet 1 c1 to sheet 2 a3
but when I use the copy link command and the fill handle excell does this
Sheet 1 a1 to sheet 2 a1
sheet 1 a2 to sheet 2 a2
sheet 1 a3 to sheet 2 a3
how do you let excel know that it must use the info from sheet a1 to af1 and link it to sheet 2 from a1 to a31
Sound easy but i can't.....help please.....