Formula or Macro to Assign Cell Locations
 

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

Formula or Macro to Assign Cell Locations
 

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.


"econWGR" wrote:

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