+ Reply to Thread
Results 1 to 4 of 4

Populate Range with Text based on cell value

  1. #1
    Forum Contributor
    Join Date
    08-17-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    158

    Populate Range with Text based on cell value

    Hello. I have multiple columns in my worksheet but for this macro, I am only going to reference two. Column C ("LOB") & Column E ("Division")
    I have given you the column headers as well as the position of the columns on the spreadsheet. Column C is completely blank and this column is also the column I need to auto populate. Column E has certain text values in each cell. Now, based on the value of the cell in column E, I want to autopopulate the blank cell in column C.

    For example:

    If one of the cells in Column E ("Division") = FS
    Then Offset(0,-2) = Enterprise

    I have 15 different text options that are in Column E ("Division") and only 7 different text that will be autifilled based on the criteria in Column E. I need some VBA code to accomplish this task. HELP!

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Populate Range with Text based on cell value

    Ok try this (keep in mind i am guessing, modification may be neccisary. post a sample workbook.)

    Please Login or Register  to view this content.
    Also give me some more info so i can get this to work exactly how you want it. are there any spaces in column E? is there a set number of rows or does it change? For each criteria (like FS) you need to add an FS and what it is supposed to put for it.

  3. #3
    Forum Contributor
    Join Date
    08-17-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    158

    Re: Populate Range with Text based on cell value

    Awesome! This worked and I modified the code to meet all of my parameters!

  4. #4
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Populate Range with Text based on cell value

    Glad i could help, throw me some rep, I'm -2 for whatever reason.

+ 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