I hope I explain this right:
To keep usage statistics of a variety of databases my company subscribes to, i have a main user form where you enter the month and year then click a button that represents a database. This opens another user form for that database. I enter the info, click submit and the data fills a worksheet for that database, putting the data in the cells of the chosen month and year. Using IF and THEN statements, I can get the first year to work fine, but any subsequent years nothing happens. I'm probably missing something with nesting but can't figure it out. Below is an example of the first two years. The 2011 statements work, but when I choose 2012, the 2011 statement runs again.
I've tried "Else if", "Or" and "And" but get errors that I can't resolve. I'm no programmer so there may be better ways to write the IF statements like variables or something, but I don't know how to do them. The statements work, so that was good enough.
Any help would be greatly appreciated.
Bookmarks