Generate a list from single cell input

[trixdarabbit]

Hello, ive been tryin to figure out how to do the next thing. I am creating a tool for my workers where there could be a single cell where they enter the amount they spend and in the next cell they select from a drop down list the type of expense (transport, food, hotel, airplane, etc...) click enter and then it resets and they could input a diferent value from a diferent drop down list and excell creating the list from the inputs, and with formulas i can calculate how much this person is spending in every type of expense. i know they could just do the list manually but i want this to be as much friendly posible, so my idea was a single cell for the amount spent next to the dropdown list cell and thats it. Any suggestions??

 

[trixdarabbit]

Pleeeeassseee help

 

[My Aswer Is This]

Hello, ive been tryin to figure out how to do the next thing. I am creating a tool for my workers where there could be a single cell where they enter the amount they spend and in the next cell they select from a drop down list the type of expense (transport, food, hotel, airplane, etc...) click enter and then it resets and they could input a diferent value from a diferent drop down list and excell creating the list from the inputs, and with formulas i can calculate how much this person is spending in every type of expense. i know they could just do the list manually but i want this to be as much friendly posible, so my idea was a single cell for the amount spent next to the dropdown list cell and thats it. Any suggestions?? Now I can read this

 

[My Aswer Is This]

There are probable a thousand ways to set up a financial sheet.
I use a UserForm with several text boxes for things like date amount spent a drop down list for category and a textbox for comments. All these values are then entered into the worksheet when I click the OK button.