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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating fields based on previous column values
You may use the IF-THEN-ELSE conditional statements. Below is a simple example.
To test using the macro, populate some cells in column C and D with the words you specified. Then select the adjacent cells in column F. Then run the macro. Sub checking() Dim cell As Object For Each cell In Selection.Cells If cell.Offset(0, -3).Value = "AC" Then cell.Value = "Agent's Charges" ElseIf cell.Offset(0, -2).Value = "OF" Then cell.Value = "Official Fees" ElseIf cell.Offset(0, -4).Value = "XXXX" Then 'do something else End If Next End Sub Basically, for example, for a cell F1, the "cell.offset(0,-2).value" is referring to the value of the cell in D1, i.e. 2 cells to the left. Feel free to ask if you need further assistance. : Regards, Edwin Tam http://www.vonixx.com "MMH" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating fields based on previous column values
why don't you just use a VLOOKUP function?
"MMH" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating fields based on previous column values
Thanks Edwin - that does exactly what I wanted it to.
MMH "Edwin Tam" wrote: You may use the IF-THEN-ELSE conditional statements. Below is a simple example. To test using the macro, populate some cells in column C and D with the words you specified. Then select the adjacent cells in column F. Then run the macro. Sub checking() Dim cell As Object For Each cell In Selection.Cells If cell.Offset(0, -3).Value = "AC" Then cell.Value = "Agent's Charges" ElseIf cell.Offset(0, -2).Value = "OF" Then cell.Value = "Official Fees" ElseIf cell.Offset(0, -4).Value = "XXXX" Then 'do something else End If Next End Sub Basically, for example, for a cell F1, the "cell.offset(0,-2).value" is referring to the value of the cell in D1, i.e. 2 cells to the left. Feel free to ask if you need further assistance. : Regards, Edwin Tam http://www.vonixx.com |
Reply |
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 |