Hi Need Help With Fixing My Excel Sheet .
I want each Dropdown Under tab May Transactions
UNDER TAB : MAY TRANSACTIONS
Rules : 1) Locate Each Dropdown under Cell ( Source of income ) & Locate Cell ( Total Collected CAD ) to load into
TAB : YEARLY INCOME STATEMENT
Rules : 2) Automatically calculate and find (Total Collected CAD) & ( Source Of Income ) & Load into Yearly Income Statement Tab automatically, without manually sorting dropdown + amount to find total amount .
I attach Sample.