I have a table of financial data. The data is organized with a transaction date in column A, expense category in B, and amount in C. I would like to organize the data in a separate table that shows only the category and total amount associated with that category, and allow the user to input two dates, a start and end, and the table will update and show only data that falls within that range. Is this possible? I have been playing around with pivot tables, but have not gotten the results that I am looking for. Any help is appreciated, thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Dynamic Table based on Date Range
- Thread starter bujaman
- Start date
-
- Tags
- date range dynamic table
Similar threads
- Solved
