Forum Discussion
How to auto-populate an expense form based on a given month
Hello, I would like some ideas on how to make excel populate an expense form based on the month I select from my drop down. For my example I selected the month of February. The expense form s...
If you can post the actual spreadsheet, I (or somebody else) could give you some more help. In the absence of that, I would suggest that you research the FILTER function (requires one of the newer versions of Excel). Here are two good places to start:
https://exceljet.net/excel-functions/excel-filter-function
and
https://www.youtube.com/watch?v=9I9DtFOVPIg
To post your actual spreadsheet, use either OneDrive or GoogleDrive and post a link here.