Sorting inputted data into specific sheets

[davek804]

Hey guys, sorry for the double post. I posted this in the wrong forum, gonna go see if I can delete the other one now.




I am working on a project for a pseudo-accounting book. The goal is simple, to have the user input a single entry of expenses. Basically, that expense can be sourced from a bunch of different accounts - with each having its own tab.

So there are tabs for each account + one tab for the user to enter their data on. I want to have a drop down list (I've done this through data validation lists) that the user selects the name of the tab that the expense entry should be sorted onto.

Then the user describes the expense in each column with attributes like date, description, etc etc. When the user finishes entering this information, I want to have a SUBMIT button that then takes that row of data (which is a single entry expense-wise) and move it over to the proper tab (which should be able to be found out by looking at what is selected in the drop down menu).

Can anyone help me set up this submit button? I've spent a couple of days trying to figure out the visual basic code with no luck.

Thanks a lot!