Hi guys, I am making a new project now to help the accounting here in my small company - we basically have 4 accounts and I want to easily input what is going out and which account, category and sub-category.
I did some googling, and found that Indirect could work, but I would rather have three columns only, one column for account, one for category and one for sub-category - this already eliminates the Indirect method I found on google. Another method would be with Pivot tables, but the problem is some of the categories and sub-categories will have the same name...so that eliminates this as well I think.
Would anyone have any tips on how to do it? Here's an example of what it should look like.
In the end I will add a button that will copy all the values and add to another sheet, this I have done previously with the help of you guys - so basically I would only need help on the dropdown boxes showing only items that are dependent to their categories.
Bookmarks