I am in the midst of creating a UserForm in order to assist in adding daily bank transactions. I have two comboboxes on this userform (Category & Sub-Category) and I want to have the subcategories values populate to reflect the selected category. I've attached the file that I'm working with.
I have defined names for the following:
BudgetCategories ='Monthly Budget'!$AA$76:$AA$85
BudgetSubCategories ='Monthly Budget'!$B$8:$B$12,'Monthly Budget'!$B$17:$B$26,'Monthly Budget'!$B$29:$B$38,'Monthly Budget'!$B$41:$B$50,'Monthly Budget'!$B$53:$B$62,'Monthly Budget'!$B$65:$B$74,'Monthly Budget'!$B$77:$B$86,'Monthly Budget'!$B$89:$B$98,'Monthly Budget'!$B$101:$B$110,'Monthly Budget'!$B$113:$B$122,'Monthly Budget'!$B$125:$B$134
After all of the data is filled out completely in the UserForm, I want it to transfer the data to Sheet1 ("Daily Ledger") Starting at cell B6:G6 (*under the appropriate columns). Also, each new transaction should transfer the new data to then next empty row time after time whether hitting the "OK" or "Another Transaction".
I look forward to hearing some of the best wisdom out there.
Thanks!
Bookmarks