rtod2
asked on
Fill in fields using data row1
Without having to select a macro to implement, I would like to fill in column B with the items in row 1? Cell B5 contains an example of what I am trying to accomplish annotated here >> http://screencast.com/t/mdhEjeUuGrl . The sheet is also attached.
Assistance is greatly appreciated.
tos-terms-matrix-.xlsx
Assistance is greatly appreciated.
tos-terms-matrix-.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect!!
I notice that you are using a numbering system. Is that something automated that you have set up?
I notice that you are using a numbering system. Is that something automated that you have set up?
=SUBSTITUTE(IF(D5="x",", "&D$1,"")&IF(E5="x",", "&E$1,"")&IF(F5="x",", "&F$1,"")&IF(G5="x",", "&G$1,"")&IF(H5="x",", "&H$1,"")&IF(OR(I5="x",N5=
regards, barry