Hi All,
My first post here and a novice at VBA. Please can you help me with this.
1. I have a sheet called "Control", in that sheet I have a 'starting date' in cell "K2" (01/04/2022) in DD/MM/YYYY format and 'ending date' in cell "K3"
2. I have a set of data in another sheet called "Data Q" between Columns "A" to "J", around 9000 rows.
3. I am trying to filter "Data Q" column "J" using the date range from the 2 cells mentioned in point 1
Please help
My first post here and a novice at VBA. Please can you help me with this.
1. I have a sheet called "Control", in that sheet I have a 'starting date' in cell "K2" (01/04/2022) in DD/MM/YYYY format and 'ending date' in cell "K3"
2. I have a set of data in another sheet called "Data Q" between Columns "A" to "J", around 9000 rows.
3. I am trying to filter "Data Q" column "J" using the date range from the 2 cells mentioned in point 1
Please help