I am looking for a macro that loops through a column of data as follows. The data begins in row 2 of column D and the range is 2 thru 200. If the cell's background is VBYellow, I would like to grab the corrsponding column of data, paste it into column C, call another procedure, and then move on to the next cell. Cell 2 corresponds with column F, cell 3 with column G, cell 4 with column H... etc. If the cell is not VBYellow, I would like to move on to the next cell.

Example: loop checks to see if cell 2 is VBYellow. If yes, column F is grabbed and pasted into column C and another procedure is called (Call test). If cell 2is not VBYellow, it moves on to cell 3. If cell3 is VBYellow, column G is grabbed and pasted into column C and another procedure is called... all the way through cell 200.