View Single Post
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

Try this:

=(ROW()<=$A$1+2)*$A$2

And copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jane" wrote in message
...
I need to populate a limited # of cells in a column with a set value.

Cell A1 contains the # of cells that should be populated down column
starting at A3.
Cell A2 contains the values that is to be populated.
Once the # of cells is populated, the cells below that shopuld be populated
with 0

any suggestions?
thank you in advance ! jane