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???