Referencing Other Worksheets AND Using Fill Handle

izzykel

New Member
Joined
Sep 29, 2006
Messages
3
I have 2 worksheets I am using, one has numbers going horizontally:
A1 B1 C1 D1
A2 B2 C2 D2
A3 B3 C3 D3

One a second worksheet I am referencing to those cells, in a veritcal format (the refernces as follows)
A1 A2 A3
B1 B2 B3
C1 C2 C3
D1 D2 D3

I have over 40 pages of this to fill in and would normally use the fill handle, but it skips.. like this..

A1 A2 A3
C1 C2 C3
E1 E2 E3

Is there any way that I can fill these in without having to manually type in the formulas? In addition, there are spaces between every 2 sets of numbers.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

izzykel

New Member
Joined
Sep 29, 2006
Messages
3
Maybe this better explains what I want..

<center> <table border=2 width=90% cellspacing=5 cellpadding=8 cols=5>
<tr><td></td><td>a</td><td>b</td><td>c</td><td>d</td><td>e</td><td>f</td><td>g</td></tr>
<tr><td>1</td><td>1065</td><td>2005/06</td><td>31500</td><td>27405</td><td>4095</td><td>12.396</td><td>83.80</td></tr>
<tr><td>2</td><td></td><td>2006/07</td><td>29097</td><td>27410</td><td>1687</td><td>12.396</td><td>29.58</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total</td><td>113.38</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>3</td><td>1066</td><td>2005/06</td><td>39521</td><td>34384</td><td>5137</td><td>12.396</td><td>105.04</td></tr>
<tr><td>4</td><td></td><td>2006/07</td><td>36506</td><td>34389</td><td>2117</td><td>12.396</td><td>0.00</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total</td><td>105.04</td></tr>
</table></center>

Column G is coming from another worksheet: "Money."
G1 has a formula which reads "='Money'!D60+'Money'!E60 "
G2 reads "='Money'!F60+'Money'!G60 "
G5 reads "='Money'!D61+'Money'!E61 "
G6 reads "='Money'!F61+'Money'!G61 "

My problem is that I have (I was wrong earlier) over 1300 rows, of which 2 are filled, then a total of those 2 (G between 2 and 3 on this example), then an empty space, 2 filled, total, empty, etc. Instead of copy and pasting the formula into each cell, or typing in each formula, I would like use the handy fill handle to auto fill the formulas. This generally works with things like "sum" and can work when referencing other worksheets, but I have never had a horizontal to vertical transfer before.
I hope someone is able to help me.. :eek:
 

Forum statistics

Threads
1,176,126
Messages
5,901,537
Members
434,899
Latest member
powerappsjoker99

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