J
Jeff Gross
I have up to 300 rows of data with 11 columns on sheet "Data Sort 1". Column
A is filled based on some code running. Columns B-K may or may not have data
based on the fact that all of these cells have an IF formula.
What I need the data to do is search for data in the cell of each row. If
there is data, then enter the column heading on a different page ("Data Sort
1b"). The data would look like on the original sheet:
A B C D
E
Op # Op Desc Mech Risk Electr Risk Haz
Risk
10 test 1 elec 1
haz 1
10 test 2 mech 1
haz 2
10 test 3 mech 2 elec 2
10 test 4 elec 3
I need it to look like this on the second sheet in column C starting at row 2:
Electr Risk
Haz Risk
Mech Risk
Haz Risk
Mech Risk
Electr Risk
Electr Risk
Thanks for any help.
A is filled based on some code running. Columns B-K may or may not have data
based on the fact that all of these cells have an IF formula.
What I need the data to do is search for data in the cell of each row. If
there is data, then enter the column heading on a different page ("Data Sort
1b"). The data would look like on the original sheet:
A B C D
E
Op # Op Desc Mech Risk Electr Risk Haz
Risk
10 test 1 elec 1
haz 1
10 test 2 mech 1
haz 2
10 test 3 mech 2 elec 2
10 test 4 elec 3
I need it to look like this on the second sheet in column C starting at row 2:
Electr Risk
Haz Risk
Mech Risk
Haz Risk
Mech Risk
Electr Risk
Electr Risk
Thanks for any help.