Fill handle question

icecoldza

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

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29
Sorry forgot to add...I want to use the fill handle function

The problem is that my info on sheet one is in row 1 from culomn a-af and i want it to be linked to sheet 2 culomn a row 1-31. Using the fill handle function. Please let me know if some more info is needed. I need it urgently..........thnks
 

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
On 2002-11-01 05:56, icecoldza wrote:
Sorry forgot to add...I want to use the fill handle function

The problem is that my info on sheet one is in row 1 from culomn a-af and i want it to be linked to sheet 2 culomn a row 1-31. Using the fill handle function. Please let me know if some more info is needed. I need it urgently..........thnks
Hi,
Select the your range in Sheet1 and press COPY, then goto Sheet2 and PasteSpecial with the TRANSPOSE option.

Eli
 

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29
Thnks Eli but with this option the cells info are not link. So when you change sheets 1 info sheet two dont change.
This message was edited by icecoldza on 2002-11-02 17:25
 

icecoldza

New Member
Joined
Aug 29, 2002
Messages
29
Thanks. I was helped by Russell Hauf. Thnks again Russell.
This message was edited by icecoldza on 2002-11-02 17:22
This message was edited by icecoldza on 2002-11-02 17:24
 

Forum statistics

Threads
1,143,920
Messages
5,721,541
Members
422,369
Latest member
redinator

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