AutoFill Function to Match Range created by Column & Row

Hi.

This is a continuation of another post I made with an ambiguous title.

To elaborate on my problem, I have a Column ("A") of dates and a Row ("1") of Titles.
I'm using the following function to draw data from another sheet to populate my range based on dates and titles.

Please Login or Register  to view this content.

My approach is to Fill this formula down, based on the count of Column A.
My problem is getting the formula to fill right, based on the Count of Row 1.
The macro I have so Far, (with a partial fix from @Norie, via my last flagged post) is below.

Please Login or Register  to view this content.

This Macro works for filling the function down "B" but it is only filling the formula in Column "B" to the right in the first row (Row 2).
I'm trying to get it to fill to the right for every row that "B" has a formula in.

Any help is greatly appreciated.

Thanks

Hey Norie.

Thanks a lot. That's so much more elegant than the approach I was trying to take. Really appreciate it.