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?