Closed Thread
Results 1 to 3 of 3

Applying formula to dynamic range.

  1. #1
    Registered User
    Join Date
    07-19-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Applying formula to dynamic range.

    Greetings.

    I have two dynamic ranges, Columns A and B. I want add to my macro so that column C is automatically populated with
    Please Login or Register  to view this content.
    for C3,
    Please Login or Register  to view this content.
    for C4, and so on and so forth for the entire range of A and B. That is, if A and B expand and contract, C should match. I have been able to define the dynamic ranges by using the Name editor, but I do not know how to apply a specific cell-by-cell formula to the new range.

    Any help would be appreciated.

    Thanks

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,642

    Re: Applying formula to dynamic range.

    You have XL2010 ? Then use the Table feature - Named ranges will not be necessary

    First select the range formed by col A and B - Select the Insert Ribbon - Click "Table" and follow the instructions
    Next, in col C add a header if needed - in the cell next to 1st row of data col A and B, enter your formula, it will expand automatically to the last value of col B
    Now when you add or delete values to or from col B, the formula in col C will follow without you having to do anything

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Applying formula to dynamic range.

    Hello willist, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

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