Userform with option to select which worksheet data is posted to.

I have a spreadsheet with a userform to enter data into 9 different columns. This userform only enters data on sheet 1 of my database. I have determined that it is necessary to be able to choose a new worksheet when a new month starts. Hence, 12 worksheets are required. If I understand correctly, I can use a control button for each month, or use a drop down menu to select which worksheet the corresponding data will post to. I have searched for days to find an example that I can model from. I know very little about VBA programing and the examples that I have found have only left me more confused. I would very much appreciate any assistance I can get.

I got the "Button" placed on the summary page to invoke the Userform. My first try resulted in any where I clicked on the page the Userform came up.

Jaslake,
Thanks for your assistance. What you have done is going in the general direction I am looking for. But not quiet there yet. As very obvious, this database is for a bank account which has numerous sub accounts. The work sheet named "Data" has no usefulness at all. It was only inserted when I started playing with the userform to give my entries a place to go. So in the end result, my plan is to delete that worksheet.

Yes, when I enter data with a January date, it goes to "Jan" worksheet; February date to "Feb", and so on. Here is where I have a problem with your code. My bank statement runs from week 2 of one month through week 2 of the following month. My February statement will contain dates ranging from January 14th plus or minus a few days, to February 14th plus or minus a few days. I need to be able to either choose a month from a pull down list, OR, have 12 buttons with month labels on them, so that when I choose that month the data goes to that particular month worksheet regardless of date. If I enter for example a date of 8-14-13 and press or choose the "Feb" option, I would end up with that entry in the Feb worksheet.

Attached is my latest version with some dummy dates and figures. Both "Jan" and "Feb" are completed. The next entry will be in "Mar" worksheet and have an approximate date of 2-15-13. And the "Data" sheet is gone.

I hope I haven't totally confused you. Appreciated.

Originally Posted by jaslake

Hi Zimmerray1

Try the Code in the attached. Note that the Code is not inserting a Row for each Entry to the Month Worksheet such that you'll soon run out or Rows above your Formula lines. Need help with that let me know.

You have been most helpful. Thank you so much! My wife will be tickled pink. I can insert rows manually unless you have the desire to do that. Once again thanks!