Hi everyone,
I'm trying to design an expense form on Sheet 2 and I have 4 types of expenses in a drop down list in merged cells F-G17 with "categories" of Office, Executive, Meeting, Conference.
What I would like to do is once they choose the "category" of their expenses, merged cells I-O17 would populate another drop down list for different accounts of expenses (IE hotel, meals, etc) and in merged cells Q-R17 it would populate the account to be credited to.
All my tables with with names and account numbers are located in a table on sheet 3.
Is this at all possible, and if so how can I format this?
Thanks for your time in reading this.
I'm trying to design an expense form on Sheet 2 and I have 4 types of expenses in a drop down list in merged cells F-G17 with "categories" of Office, Executive, Meeting, Conference.
What I would like to do is once they choose the "category" of their expenses, merged cells I-O17 would populate another drop down list for different accounts of expenses (IE hotel, meals, etc) and in merged cells Q-R17 it would populate the account to be credited to.
All my tables with with names and account numbers are located in a table on sheet 3.
Is this at all possible, and if so how can I format this?
Thanks for your time in reading this.