Building a Form

Henry

Board Regular
Joined
Mar 7, 2002
Messages
180
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Henry:

In addition to valuable suggestion by Anne(Dreamboat), I suggest you post your sample data that you have to work with, and then let us look at which of the Excel features, such as Data Validation, INDEX, MATCH, VLOOKUP, ... can be best utilized for your situation.

Regards!
Yogi Anand
 

Watch MrExcel Video

Forum statistics

Threads
1,127,240
Messages
5,623,565
Members
415,981
Latest member
Baltwin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top