rayoconnell
05-11-2007, 03:40 AM
hello all,
here is my problem, i am trying to auto fill spreadsheet that our clients give us. it has to be in a specific format. when they give it to us they have 3 headings eg.
H I J
Vessel Ferm Waste_SYS
Y
Y Y
Y
y Y
the above goes on for about 200 lines.
what i need to do is,
if there is a Y in the H column then enter "vessel" in the C column on the same row.
likewise for I, if there is a y enter "ferm" in the C column and again for "J":mkay confused please help
here is my problem, i am trying to auto fill spreadsheet that our clients give us. it has to be in a specific format. when they give it to us they have 3 headings eg.
H I J
Vessel Ferm Waste_SYS
Y
Y Y
Y
y Y
the above goes on for about 200 lines.
what i need to do is,
if there is a Y in the H column then enter "vessel" in the C column on the same row.
likewise for I, if there is a y enter "ferm" in the C column and again for "J":mkay confused please help