stronik814
New Member
- Joined
- Jan 22, 2014
- Messages
- 5
Hi,
I'm trying to auto - filter column 2 "Frequency" by today's current date, Cell A1 & by the word "Daily". I'm trying to make this happen automatically once the user opens the workbook.
For example, if the user opens the workbook on a Wednesday, the Frequency table should be filtered to only show Wednesday & Daily. I looked on other forums and posts and have not been able to figure it out. Any help would be greatly appreciated, thank you!
<TBODY>
</TBODY>
I'm trying to auto - filter column 2 "Frequency" by today's current date, Cell A1 & by the word "Daily". I'm trying to make this happen automatically once the user opens the workbook.
For example, if the user opens the workbook on a Wednesday, the Frequency table should be filtered to only show Wednesday & Daily. I looked on other forums and posts and have not been able to figure it out. Any help would be greatly appreciated, thank you!
A1 | =today() -> Tuesday Oct 7, 2014. | |
Line Item | Frequency | |
1 | Tuesday | |
2 | Daily | |
3 | Daily | |
4 | Wednesday | |
5 | Wednesday | |
6 | Daily | |
7 | Monday | |
8 | Tuesday & Thursday | |
9 | Monday | |
10 | Tuesday | |
11 | Tuesday |
<TBODY>
</TBODY>