Gunnerrecall1776
New Member
- Joined
- Aug 17, 2016
- Messages
- 11
i have a financial tracking sheet i developed that works fairly well for me. but have run into a wall on it when someone asked me to make a change.
so here's what i have:
on a quarterly basis, spending amounts and their categories from each week are entered on separate sheets, and there is a totals sheet at the beginning of the workbook that details how much in each category was spent in each week. there is an overview sheet that shows the totals of all categories that have been entered in the workbook, meant as a cleaner way to review the spending amounts.
however, someone has asked me if i could enable a selection range based on entries from varying weeks to show the totals between the dates selected in FROM and TO drop down lists.
i have tried figuring out how to do this on my own but im at a loss of what function i could use or how to manipulate data validation to accomplish it. i would like to have an overview sheet where you will be able to select FROM and TO dates, and have the table reference the totals that are in the columns of my totals sheet. the totals sheet is set up to have categories on the right, a date on the top of each column, and the sums of amounts spent in those within each weekly period.
lord let there be someone out there who can help. if you need further explanation or examples i am more than happy to accommodate. thank you anyone in advance.
so here's what i have:
on a quarterly basis, spending amounts and their categories from each week are entered on separate sheets, and there is a totals sheet at the beginning of the workbook that details how much in each category was spent in each week. there is an overview sheet that shows the totals of all categories that have been entered in the workbook, meant as a cleaner way to review the spending amounts.
however, someone has asked me if i could enable a selection range based on entries from varying weeks to show the totals between the dates selected in FROM and TO drop down lists.
i have tried figuring out how to do this on my own but im at a loss of what function i could use or how to manipulate data validation to accomplish it. i would like to have an overview sheet where you will be able to select FROM and TO dates, and have the table reference the totals that are in the columns of my totals sheet. the totals sheet is set up to have categories on the right, a date on the top of each column, and the sums of amounts spent in those within each weekly period.
lord let there be someone out there who can help. if you need further explanation or examples i am more than happy to accommodate. thank you anyone in advance.
