Problem with fill handle function?

[icecoldza]

Hi can someone help with the following problem?

Start a new workbook and complete from a1 to j1 1 to 10. Ok now go to sheet 2 and link a1 to sheet1 a1. Next Link sheet2 a2 to sheet1 b1. Now using the fillhandle function complete the rest of sheet2 a1 to a10.

Nope it don't work. Excel don't recognize what I wan't to do. So please to the excel wizards in here, how can I do this in general.

 

[Yogi Anand]

Hi icecoldza:

You can use the INDIRECT function to do this. see the worksheet simulation ...

Book3
	A	B	C	D	E	F	G	H	I
1	a_1		FillintheformulainthefirstcellA1andthenyoucandragdowntoA10
2	b_1
3	c_1
4	d_1
5	e_1
6	f_1
7	g_1
8	h_1
9	I_1
10	j_1
11
Sheet2

</SPAN>

Regards!
Yogi Anand

 

[icecoldza]

Thanks Yogi

I just wish I asked this question before I've spend +- 16 hours linking differen't cell's !!!! -)

 

[Yogi Anand]

Hi icecoldza:

Better late than never -- and see you would have had more time to relaxe.

Regards!
Yogi Anand

 

[icecoldza]

Yogi I still have a problem with this function. I don't know how to use this offset function. I want to link sheet2 d3 to sheet1 b2 ; sheet2 d4 to sheet1 c2 ; d5-d2 ; d6-e2 ; d7-f2 Sorry but new with excel..-)

 

[Juan Pablo González]

On 2002-11-02 23:30, icecoldza wrote:
Yogi I still have a problem with this function. I don't know how to use this offset function. I want to link sheet2 d3 to sheet1 b2 ; sheet2 d4 to sheet1 c2 ; d5-d2 ; d6-e2 ; d7-f2 Sorry but new with excel..-)

In Sheet2!D3 put

=OFFSET(Sheet1!$A$2,0,ROW(A1))

then you can drag down. The OFFSET formula works something like this:

Starting from Sheet1!A2 move 0 rows down, 1 row to the right (In the case of D3, because ROW(A1) = 1), which leaves you in Sheet1!B2. In D3 is something similar: Begin in Sheet1!A2, move 0 rows down, and 2 (ROW(A2) = 2) columns to the right, ending in Sheet1!C2

Hope that helps you.

 

[Yogi Anand]

Hi icecoldza:

For Sheet2!D3 to Sheet1!B2
goto Sheet1 -- in cell B2 enter =Sheet2!D3
For Sheet2!D4 to Sheet1!C2
goto Sheet1 -- in cell C2 enter =Sheet2!D4

For Sheet2!D5 to Sheet1!D2
goto Sheet1 -- in cell D2 enter =Sheet2!D5

For Sheet2!D6 to Sheet1!E2
goto Sheet1 -- in cell E2 enter =Sheet2!D6

For Sheet2!D7 to Sheet1!F2
goto Sheet1 -- in cell F2 enter =Sheet2!D7

I have intentionally listed individual links -- feel
free to observe the patterns, or use formulas and
then use copying / dragging.

Regards!
Yogi Anand