i have 2 worksheets that i want to link together,one has the data on it and the other has empty cells on it,i want to link the cells to the corresponding data so if i type 2 in one of the empty cells it returnes with double what is in the corresponding data box on the other worksheet and so on. I have tried using the =SUM(F3:R3)*'WORKSHEET'!C2:O2 but the data doesn't come out right i just keeps multiplying by the same amount each time.

[ This Message was edited by: h58299 on 2002-04-19 14:44 ]

[ This Message was edited by: h58299 on 2002-04-20 04:41 ]