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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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,141,757
Messages
5,708,346
Members
421,566
Latest member
7Nabisco

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