No, I want the all of the values in column G starting with G6 to start in B11 automatically. B11=G6, B12=G7, B13=G8, etc. I want excel to know what column to use (east (g) or west (h)) and also know what row to start the data in depending on the date in B4.

So by looking at B2 (east or west) and B4 (date) excel knows to input east column into B11 because the date equals B4.

Does that make sense?