Not without writing VBA code.

Why must you avoid using formulas?

If you must use VBA, you'll need to use a worksheet_change event, check that
the change occurs in a cell that matters, and then put the value from that
cell into the other cells where you need/want it.



"holmeshouse" wrote:

If I enter a number in one cell in my workbook, I would like it to
automatically appear in several other cells. The 'destination' or 'target'
cells cannot have any formula in them.
I need to be able to enter any number in the original cell and can use
additional cells for formulas.
IE. If I key in the number 7 in cell A1, I would like that number (not a
formula) to appear in cells C5, B8, D11, etc.
Sorry, this sounds like a stupid request, but is it possible to do this?