Hello, everyone
I am trying to compare 2 sheets and get the information of a specific column, and paste that information from one sheet to another. Problem is that date isn't formatted correctly so I tried to filter it with Day/Month/Year command, for some reason my code doesn't work. Perhaps I did something wrong. It is my first time dealing with macros, usually I only did formulas in the sheet. But since it's an array formula it is really tedious to apply formula to every cell separately.
Below is my macro code.
Bookmarks