Hello everyone !!
In order to help my team at work, I'm trying to add some VBA in our files.
Each month, we have a powerpoint presentation to do, which means lots of exports, filters, copy/paste but also potential errors due to the number of operations by hand etc
The datas we are interested in come from exports so the main goal of my macros is to filter, copy/paste datas from one worksheet to another (In the same Workbook).
These datas contain Reference, names, dates, status
In my workbook, i have 3 macros that I activate with buttons:
1- filter and copy/paste datas from sheet 2 to sheet 1 (using AutoFilter)
2- clear the table (erase datas in sheet 1 for aesthetic purpose)
3- clear filters (remove autofilter applied in sheet 2)
What I'm currently trying to achieve:
I would like to use a dropdown list as a filter criteria in VBA:
My goal is to be able to filter Creation Dates in sheet 2 following this method:
1- select month in dropdown list in sheet 1
2- launch macro with button in sheet 1
3- having the month selected in the dropdown list used as a criteria in a function like AutoFilter in my VBA macro
As an example I made this Workbook, the datas have no particular meaning but all 3 macros are functionnal.
Extract button will filter 2 types of "Bill Statuts" in Sheet 2 and return the datas I want in Sheet 1.
For the date filter, I would like to filter months only (1 to 12), on my export in Sheet 2 the dates are displayed as dd/mm/yyyy
However, If I filter the Creation date column in sheet 2, it displays months names directly (from january to july)
I also made the dropdown list already, it goes from 1 to 12 but you can make it go from "January" to "December" (text) too if that helps (months names are also displayed in the workbook I attached).
I heard of combobox but it's not what I'm looking for, sorry.
I think that's it, as a french fellow I hope I made myself clear enough and that my english is OK, thanks a lot for reading and for your time !
Bookmarks