L
LJ
here is my situation,
I have some information on two sheets...sheet 1 and sheet 2...in sheet 1,
colum A i would like to the cell to show the number for sheet 2 colum
B...Here is the thing, i would like to drag and use the fill fuction but i
want it to display the following column not the next cell on the row...
this is what i have
Ex
Sheet 1, cell A1, (=Sheet2!B1)
if i drag and use the fill fuction the following cell give me
(=Sheet2!B2)(=Sheet2!B3) etc...i would like it to read
(=Sheet2!C2)(=Sheet1!D2) etc...
any suggestions...
thanks for the help in advance
LJ
I have some information on two sheets...sheet 1 and sheet 2...in sheet 1,
colum A i would like to the cell to show the number for sheet 2 colum
B...Here is the thing, i would like to drag and use the fill fuction but i
want it to display the following column not the next cell on the row...
this is what i have
Ex
Sheet 1, cell A1, (=Sheet2!B1)
if i drag and use the fill fuction the following cell give me
(=Sheet2!B2)(=Sheet2!B3) etc...i would like it to read
(=Sheet2!C2)(=Sheet1!D2) etc...
any suggestions...
thanks for the help in advance
LJ