I have a "pair" of columns that exist in many different spreadsheets that
our group receives data in. They are always in the same order, but not
always in the actual columns, i.e. compo is always the column just before
curorg, but they don't always live in columns D and E. What I need to do is
set the value of compo based on curorg. I was trying to modify a macro given
to me for cleaning up ssn's with missing leading zeros. In other words I
would like to just select the two columns and have whatever is already in
compo replaced with the proper value, if curorg is a 1 or S or U then set
compo to '1, and so forth. There are currently 19 values that could exist in
curorg and 3 values ('1, '2, '3) that would map to those curorg's and be
inserted into the compo column.

I hope this makes sense.

Bruce