Convert Numbers to Text with a Source Code list

[Kyle]

I have a column of data with numbers relating to specific industries. Each
row corresponds to an individual and their affiliated industries. Some cells
contain 1 number and some contain several (separated by commas). I would like
to break this column apart into each individual industry for separate
columns. The corresponding person would have an x in the column that refers
to the industry they relate to. I have a separate sheet for what each code
(number) means. HELP!

 

[מיכ×ל (מיקי) ×בידן]

Assuming, the column. is Col. A - you can use the hereunder Event-Macro.
What ever you'll type into Col. "A" cells will be, automatically' multiplied
by 0.59
============================
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Intersect(Target, Range("A:A")) Then Target = Target * 0.59
Application.EnableEvents = True
End Sub
========
Micky

 

[מיכ×ל (מיקי) ×בידן]

Sorry...
My post, here, was misplaced.
Micky

Assuming, the column. is Col. A - you can use the hereunder Event-Macro.
What ever you'll type into Col. "A" cells will be, automatically' multiplied
by 0.59
============================
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Intersect(Target, Range("A:A")) Then Target = Target * 0.59
Application.EnableEvents = True
End Sub
========
Micky