Bafuller83
New Member
- Joined
- Dec 17, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
- Mobile
I made a Excel sheet that has a drop down list of different forms of payments and to the left of that is the amount that was paid.
I then have a second table (direct payment) which have the headers of each type of payments. And the amounts below.
I have been inputting the amounts manually to the second table. How can I transfer the payment amount automatically based on the drop down payment type to the designated payment type in the second table.
I attached a screenshot of the excel sheet from my phone.
example: if payment type from the drop down list is “Zelle”, transfer the payment amount the the Zelle column of the Direct Payment table.
thanks for your help, I know very little lol
I then have a second table (direct payment) which have the headers of each type of payments. And the amounts below.
I have been inputting the amounts manually to the second table. How can I transfer the payment amount automatically based on the drop down payment type to the designated payment type in the second table.
I attached a screenshot of the excel sheet from my phone.
example: if payment type from the drop down list is “Zelle”, transfer the payment amount the the Zelle column of the Direct Payment table.
thanks for your help, I know very little lol