Forum

Can we set a Macro to filter Data base on "Date" criteria For example in the sample file we want to filter in N column [ Vendor reply] Today' s...

Thansk Sunny the code that's exactly what I want , I will modify the code for application.

Wow, that's terrific and fancy, you make us like a film star on a Broadway show. Sunny, honestly you always add Bonus to our VB work, not ony that...

Sunny is always helpful...

Thanks, Sunny, the very and precise explanation. You are brilliant, and superb, above all, no selfish heart but to share with us the invaluable wh...

Sunny, What is syntex WEEKNUM(A1,2) meaning?

It' OK Sunny.. we understand that..

Pls show us the macro ? Tks!

Thanks Sunny, I think the power of this VB make interactive jobs and user happy also a lot easier to complete the tasks they desire.

Thanks millions Sunny, it works beautifully. Also thanks to pointing out the consistency in the Master record data also the layout inconsistency....

attachment

Allow me to suggest a more easy way : Simply apply sorting : By Rows Copy paste the require data Then return the rows to natural order.

Again very very clear explanation so I grasp the tricks how it works.