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.
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.
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
Bookmarks