Hi: This is new to me so bear with me.
I was originally using a .doc to create a Template Form, but the .doc template is not easy to use with calculations, so it was suggested I use an Excel .xlt. So.......
I've created a Drop Down List (DDL) of 50 Names. You see this on the .xlt.
I've also used the Index Function translate the DDL choice to replace the DDL number with the corresponding choice. This result is in a separate cell. The problem is, when you look at the Form, you see both the DDL choice as well as the result from using the Index.
I'm trying to set this up so that when you select from the DDL, that result can be used in Calculations, such as price x quantity.
I only want the result to show; therefore, cleaning up the Form. I looked an Excel Book but there form is really cluttered.
Did I confuse you? Suggestions!!!!!!!
MT
I was originally using a .doc to create a Template Form, but the .doc template is not easy to use with calculations, so it was suggested I use an Excel .xlt. So.......
I've created a Drop Down List (DDL) of 50 Names. You see this on the .xlt.
I've also used the Index Function translate the DDL choice to replace the DDL number with the corresponding choice. This result is in a separate cell. The problem is, when you look at the Form, you see both the DDL choice as well as the result from using the Index.
I'm trying to set this up so that when you select from the DDL, that result can be used in Calculations, such as price x quantity.
I only want the result to show; therefore, cleaning up the Form. I looked an Excel Book but there form is really cluttered.
Did I confuse you? Suggestions!!!!!!!
MT