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