Formula or Macro to Assign Cell Locations

[econWGR]

What I want to do is create some formula that I could copy that would add
just one row assignment.

Here is the example:

in columm d I want to copy the value in cell c2 to the next 8 rows in d.
Then copy the values from cell c3 to the next 8 rows in d and so on for 1,000
rows. I want something that I can just copy over and over for various
worksheets.

Any ideas???

 

[JMB]

Assuming your data starts in C2 and this formula is entered in D2, try:

=INDEX(C:C,INT((ROW()-ROW(D$2))/8)+ROW(C$2))

modify the range references as needed and copy down.