Creating a loop that copies values from one sheet to another based on an index function.

[ndrobinson]

Or at least, index is how I'd understand it in non-VBA terms.

The set-up is as follows:

I have a worksheet named "Schedule" that has a list of names in column E, and a list of dates in ROW 2 (1 through 31). Each cell in the matrix either has a "W" or "Off" indicating what a particular person is doing on each date.

The dates on the schedule (running across row 2) correspond to individual worksheets (named "1", "2", "3", etc.). Those worksheets all have the same template, in which Column C has a bunch of empty cells designated for the names on the "Schedule" sheet. I'd like to write a loop that sorts through each name in column E of the "schedule" sheet, checks to see if the intersection between that name and the date has a "W", and then pastes all of those values into column C of the corresponding day (without any blank rows in between values)

I've attached a simplified version in case I'm not explaining this well.

Thanks for your time.

[ndrobinson]

Scratch that; found a round-about way to accomplish the same thing. I'd still be interested in finding a VBA loop method, but that's strictly for educational purposes at this point.