Hello
I have a formula which produces a cell address (in the form $C$10). Is it then possible to populate the resultant cell (in this case C10) with a number or something using a formula or does it have to be a macro? Eg, the formula produces cell A1 and A1 gets a 1 put in it. The formula then generates address B15 and cell B15 has a 1 put in it.
Thaaaaanks!
James
I have a formula which produces a cell address (in the form $C$10). Is it then possible to populate the resultant cell (in this case C10) with a number or something using a formula or does it have to be a macro? Eg, the formula produces cell A1 and A1 gets a 1 put in it. The formula then generates address B15 and cell B15 has a 1 put in it.
Thaaaaanks!
James