I'm trying to see if there's an efficient way to pull from a list of values in one worksheet and have those values repeat every 7 rows in another worksheet before pulling the the 2nd value in the original list and having that value repeat for 7 rows.

In other words, I need to figure out how to customize my fill down option so that the value from the first row in worksheet1, say it's a list containing values (ABC, DEF, GHI in one column), and I want the value "ABC" to repeat for 7 rows in worksheet2, and then the 8th row pulls the 2nd value from the column "DEF." So on and so forth.

Is VBA the best way to go or is there a formula that I can use? I've been looking at the OFFSET formula, and have also been writing some VBA code, but would appreciate any help.