+ Reply to Thread
Results 1 to 3 of 3

AutoFill Function to Match Range created by Column & Row

  1. #1
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    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

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: AutoFill Function to Match Range created by Column & Row

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    Re: AutoFill Function to Match Range created by Column & Row

    Hey Norie.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1