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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

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
Back
Top