Problem with fill handle function?

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29
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.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi icecoldza:

You can use the INDIRECT function to do this. see the worksheet simulation ...
Book3
ABCDEFGHI
1a_1FillintheformulainthefirstcellA1andthenyoucandragdowntoA10
2b_1
3c_1
4d_1
5e_1
6f_1
7g_1
8h_1
9I_1
10j_1
11
Sheet2
</SPAN>

Regards!
Yogi Anand
 

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29
Thanks Yogi

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

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi icecoldza:

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

Regards!
Yogi Anand
 

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29

ADVERTISEMENT

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

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top