Shneederling
New Member
- Joined
- Apr 26, 2019
- Messages
- 9
Hi all,
Pretty new to VBA, trying to work things out for myself, but I've become stuck.
Basically every Monday my colleague downloads a spreadsheet of direct sales (Main Tab), I then create a summary (Summary Tab) where I have every date of the year which is split into weeks. Next to each week I created a formula that counts how many lines from the main tab are within that week (using latest date on the main tab).
What I want to do now is, double click on the 1st date of a particular week, and the main sheet auto-filters to the dates in that week.
I am unable to upload the spreadsheet as its blocked on our system, but any help is much appreciated. Column M on main tab is what needs to filtered, I'm not sure if need to know cell numbers of every 1st date, but basically the weeks run from 31/12/2018 to 06/01/2018 and so on starting in cell A4, 5 weeks in column A, 5 weeks in column C and so on until 2 week in column U.
Many thanks in advance
Pretty new to VBA, trying to work things out for myself, but I've become stuck.
Basically every Monday my colleague downloads a spreadsheet of direct sales (Main Tab), I then create a summary (Summary Tab) where I have every date of the year which is split into weeks. Next to each week I created a formula that counts how many lines from the main tab are within that week (using latest date on the main tab).
What I want to do now is, double click on the 1st date of a particular week, and the main sheet auto-filters to the dates in that week.
I am unable to upload the spreadsheet as its blocked on our system, but any help is much appreciated. Column M on main tab is what needs to filtered, I'm not sure if need to know cell numbers of every 1st date, but basically the weeks run from 31/12/2018 to 06/01/2018 and so on starting in cell A4, 5 weeks in column A, 5 weeks in column C and so on until 2 week in column U.
Many thanks in advance
