Hi all,
I need a macro to set the value of cell E$ based on the LIKE VALUE of V$.
Example, V$ are product codes follow the convention of:
"Prod group, *, 4-6 digits (1234 are an example)"
"2*1234" = Prod group1
"3*1234" = Prod group2
"4*1234" = Prod group3
I need to set the value of cell E$ to "Prod group1, Prod group2, Prod group3" based on the above example:
I looked at the RANGE function but that isnt working for me.
Can anyone assist in this,
TIA
I need a macro to set the value of cell E$ based on the LIKE VALUE of V$.
Example, V$ are product codes follow the convention of:
"Prod group, *, 4-6 digits (1234 are an example)"
"2*1234" = Prod group1
"3*1234" = Prod group2
"4*1234" = Prod group3
I need to set the value of cell E$ to "Prod group1, Prod group2, Prod group3" based on the above example:
I looked at the RANGE function but that isnt working for me.
Can anyone assist in this,
TIA