I have a workbook that has a defined list of months and years, along with a 2 different date columns that are not currently named. I need to be able to put a month/year on sheet1 from dropdown lists, and have the corresponding dates populate from those 2 different columns. Below is a sample idea of what I currently have:
Main table:
<tbody>
</tbody>
Date column table:
<tbody>
</tbody>
So if I choose 'August' and '2018' from the main table, it would return results like this:
<tbody>
</tbody>
Can someone help me achieve this? Hopefully my goal makes sense. Thanks for all help in advance!
Main table:
Month(Dropdown) | Year(Dropdown) |
Datecol1 | Datecol2 |
<tbody>
</tbody>
Date column table:
Datecol1 | Datecol2 |
07/20/2018 | 07/27/2018 |
08/03/2018 | 08/10/2018 |
08/17/2018 |
<tbody>
</tbody>
So if I choose 'August' and '2018' from the main table, it would return results like this:
August | 2018 |
08/03/2018 | 08/10/2018 |
08/17/2018 |
<tbody>
</tbody>
Can someone help me achieve this? Hopefully my goal makes sense. Thanks for all help in advance!