Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Filter function Not working properly

0

The filter value is not poulating values from Raw to sheet 1

Trying to make something like the excel date filter magic video

https://www.youtube.com/watch?v=hj6JSSQIrdw

File attached

Answer
Discuss

Discussion

Hi and welcome to the Forum.

Looks like you're following Don's video tutorial Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface.

Firstly, are you sure that your all dates are integers, with no decimal (time) portion, as Don warns early in the video?

Secondly and unfortunately, your statement "File attached" is not true.  Please edit your original question and use the Add Files... button to upload a representative Excel file only (without any personal data) to show your existing data etc. It might be helpful if you describe your problem more fully too. Then we should be able to give specific help.
John_Ru (rep: 4332) Nov 17, '22 at 9:13 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login