Newbie - Help with Fill Command??

[Patrick]

Hi all

I am not sure if this is able to be done, but I will explain what I am
trying to do:

I have the following cells:

Worksheet 0

A B C D E
1
2
3
4
5

A B C D E
6
7
8
9
10



Where: A1 = Calculation in row 1 worksheet 1
B2 = Calculation in row 1 worksheet 2
C3 = Calculation in row 1 worksheet 3
D4 = Calculation in row 1 worksheet 4
E5 = Calculation in row 1 worksheet 5 and

A6 = Calculation in row 2 worksheet 1
B7 = Calculation in row 2 worksheet 2
C8 = Calculation in row 2 worksheet 3
D9 = Calculation in row 2 worksheet 4
E10 = Calculation in row 2 worksheet 5



I need to fill down the column so the calculations correspond to the
correct cells in the other worsheets, however the problem is that when I
use the fill command, where A6 for example should = worksheet 1 row 2,
it is referencing is referencing worksheet 1 row 7 because that is the
original fill pattern if that makes sense.

Is there anyway of making a custom fill pattern based on the above.

Any help is much appreciated.

Please email (e-mail address removed) if you need a copy of the spreadsheet in
question to help.

Regards

patrick

 

[Frank Kabel]

Hi
post your exact formulas
Using INDIRECT probably will solve this. But also< provide the exact names
of your referenced worksheets

 

[Guest]

get rid of Excel, start using Access.

you can cartesian data and do crossjoins in Access.. the best thing is that
it doesn't take more STORAGE to have different views of numbers