Forum Discussion
Create drop down menu and be able to plug in dollar amount
I need help. I want to be able to have a cell with a drop down menu that lets me pick what card I used and plug it the dollar amount.
I have multiple credit cards and want to be able to pick the card # from the list but also let me plug in a dollar amount.
2 Replies
Create a list of credit card numbers in a range of cells.
Select the cell or cells where you want the drop down list.
On the Data tab of the ribbon, click Data Validation.
Select List from the Allow drop down.
Click in the Source box and point to the range with the credit card numbers.
Activate the Error Alert tab.
Clear the check box 'Show error alert after invalid data is entered' (this will make it possible to enter a dollar amount).
Click OK.
Thank you !!
