## Excel spread sheet : related to formula copying

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?
 Recognitions: Gold Member 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)