Newbie - Help with Fill Command??

  • Thread starter Thread starter Patrick
  • Start date Start date
P

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
 
Hi
post your exact formulas :-)
Using INDIRECT probably will solve this. But also< provide the exact names
of your referenced worksheets
 
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
 
Back
Top