You would need multiple formulas for that, one for each cell you want data
entered in. Formulas can only return a value in the cell that holds the
formulas

--
Regards,

Peo Sjoblom


"Baffle, Atlanta, Ga" <Baffle, Atlanta, wrote
in message ...
In excell How do I write the formula to say
If Sheet One Column A10 enter Data in B1, B2, B3 on sheet 2 Column C1,
C2,
C3