Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating fields based on previous column values
Hello
I am trying to populate the cells in a column (column F) based on information in columns B, C and D. Unfortunately I do not know how to code this. For example, I want to say that for all the rows where column C equals "AC", column F should say "Agent's Charges". Then for all the rows where column D has "OF", column F should say "Official Fees". And so on. Could someone please tell me how I would write this in VBA. Thank you in advance. MMH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
Populating a cell based on a range of values (Part III) | New Users to Excel | |||
Populating a Cell based on a Range of Values (Part II) | New Users to Excel | |||
Populating a cell based on a range of values | New Users to Excel | |||
Populating a field based on lookup values | Excel Worksheet Functions |