View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elaine Elaine is offline
external usenet poster
 
Posts: 106
Default Repeat Cell Based on the Value-Excel 2003

Hello,

I want to repeat a formula based on the value in another cell.
Example:
Formula/Result located in Cell B8
Value 5 located in Cell A2

How do I repeat the formula in cell B8 based on the value in cell A2? In
this example, the end result would have the formula in cell B8 repeated in
cells B9, B10, B11, B12, & B13. The number in cell A2 varies.

--
I thank you in advanced for all of your support... Elaine