Good day,
Its been a long time since I have last posted, I have missed this forum!
Anyway,
I have to populate a cell with different types of data, based on the code is in an adjacent cell. For example if the code in the adjacent cell reads "GL", I then have to populate the cell with the "owners name" the "size", other codes require different variables.
All the information needed for each variable (i.e. owners name) is on the same line as the cell I am trying to populate.
I am trying to think of the best way to do this, there are about 33 codes, each with different variable requirements, some requiring up to 8 different variables.
I was going to use a "Select Case" method, where it sees the code, it then selects that case, and with in the code it steals the variable data from the proper cells.
Another method I was going to use, was what I just mentioned, but have a second select case for the variables, instead of if statements.
Thank you for any tips!!
Kavy
Its been a long time since I have last posted, I have missed this forum!
Anyway,
I have to populate a cell with different types of data, based on the code is in an adjacent cell. For example if the code in the adjacent cell reads "GL", I then have to populate the cell with the "owners name" the "size", other codes require different variables.
All the information needed for each variable (i.e. owners name) is on the same line as the cell I am trying to populate.
I am trying to think of the best way to do this, there are about 33 codes, each with different variable requirements, some requiring up to 8 different variables.
I was going to use a "Select Case" method, where it sees the code, it then selects that case, and with in the code it steals the variable data from the proper cells.
Another method I was going to use, was what I just mentioned, but have a second select case for the variables, instead of if statements.
Thank you for any tips!!
Kavy