Hi Everyone,
I am hoping someone can help me out on this one. I have a table similar to below, only larger. Headers are dates usually 6 months or so, but each column is a week. The rows are items. This table is on one worksheet. On a separate sheet I want to have a dynamic monthly total sheet, there will be a drop down to select the month. From past history Excel doesn't like to recognize date formats when they are used in a table header, I will need to look for text "month" in any searches. I am sure there is a combination of sumifs and lookups, maybe a macro is easier.
<tbody>
</tbody>
Example of what I am looking for:
If I chose Oct as the month this should be the result, it should populate a list with only items that actually have totals greater than 0
<tbody>
</tbody>
Thanks
I am hoping someone can help me out on this one. I have a table similar to below, only larger. Headers are dates usually 6 months or so, but each column is a week. The rows are items. This table is on one worksheet. On a separate sheet I want to have a dynamic monthly total sheet, there will be a drop down to select the month. From past history Excel doesn't like to recognize date formats when they are used in a table header, I will need to look for text "month" in any searches. I am sure there is a combination of sumifs and lookups, maybe a macro is easier.
A | B | C | D | E | |
1 | ITEM | Oct 20 2018 | Oct 27 2018 | Nov 3 2018 | Nov 10 2018 |
2 | 6.01 | 5 | 0 | 0 | 1 |
3 | 6.02 | 3 | 1 | 0 | 2 |
4 | 7.01 | 0 | 0 | 0 | 4 |
5 | 7.02 | 0 | 2 | 1 | 2 |
<tbody>
</tbody>
Example of what I am looking for:
If I chose Oct as the month this should be the result, it should populate a list with only items that actually have totals greater than 0
A | B | |
1 | MONTH | OCT |
2 | ||
3 | ITEM | MONTHLY TOTAL |
4 | 6.01 | 5 |
5 | 6.02 | 4 |
6 | 7.02 | 2 |
<tbody>
</tbody>
Thanks