I was wondering if there is a way to automatically sort from an input sheet to an output sheet.
On the output sheet, there would be three different tables that the data went into, based off of their category
Categories include Office Expense - Meals, Office Expense - Groceries, and Office Expense - Office.
I want to be able to set up an Input table in a separate tab, where you can just type in Date, description (Meals, Groceries, or Office), and amount.
From there, I'd like the hard entered numbers dumped into a breakdown sheet with the three different tables.
Is this feasible?
Thanks in advance!Excel Help 3_9.xlsx
Bookmarks