Populate group of cells

[excelrealnoob]

Is there a way that i can take a value in one cell and have it populate a group of cells in the same column when the value is greater than zero?

[Palmetto]

=if($A$1>0,A1,"")

[ChemistB]

IF you're looking to automate, VBA can be written or IF formulas can be used (e.g.)

Please Login or Register  to view this content.

If you want to do it manually;
Hold down the CNTRL key and choose all of your other cells where you want this transferred to including your cell with your value.
Then "Tab" back to the cell of interest and hit F2 then CNTRL Enter.
Your value will appear in all of those other cells.