# Excel spread sheet : related to formula copying

1. Jun 25, 2012

### manjuvenamma

I have a table of numbers say 12 X 12 i.e A1 cell to L12 cell. All of them have numbers filled in.

I have to create another table of identical size. first row and first column numbers are just duplicated in the new table i.e.A1 to A12 (first column) A1 to L1 (first row) cells are just copied into the new table without any changes.

All other cells of the new table are to be populated as follows:
for example: cell corresponding to b9 is to replaced by the product of three numbers (i) b9,
(ii) a9 (first element of the same row) and b1 (first element of the same column).

Another example: j6 is to replaced by the product of j6, a6 (first element of the same row) and j1 (first element of the same column).

I can do this manually by writing formula in each cell. I want to do automatically by writing a formula in one cell and copying the same in all other cells of interest.

Can this be down and how?

2. Jun 25, 2012

### phinds

it can be done very easily w/ VBA but I wouldn't know how to do it with a cell formula although I wouldn't be surprised if it COULD be done w/ a cell formula

EDIT: I've done the VBA --- if you want it, send me an email (NOT a PM)

Last edited: Jun 25, 2012
3. Jun 25, 2012

### Andre

There is a simple copy paste for that.

Write the formula in the first cell. Note that there is a little black dot in the lower right corner of the cell where the cursor is. Aim the mouse on that and the pointer changes to a small cross. Now drag the mouse over all the cells where you want the formula copied.

Note that the relative geometry of the copies stay in tact. so if you drag the formula =a6*a7 one to the right and one down, the copy will read =b7*b8 etc