I have a worksheet with huge data, where a column has many dates, and I have to filter & copy the data according to the next working date.
I've written below codes, but that works for the next date instead of the next business date. What if some other day is official holiday, then the data should be auto filtered as per the next business date/day (Monday to Friday).
How can I have a userform, which will ask the date in a specific format for auto filtering the data, then perform the written codes on that date in the worksheet? I think this is how I would get the accuracy all the time without any wrong inputs.
Here below, if I use a date as 05/15/2011 or 05/15/11 instead of 5/15/2011 then auto-filter doesn't work properly. so I need a correct format of the input date.
Please Login or Register to view this content.
Please see the 'userform' in the VBA code window (ALT+F11). I am sure that someone will come up with the solution & help me out.
Workbook: MS Excel 2007
Thanks in advance!