I looked in your attached macro module and do not see where you included the
loop to delete rows by year.
Can you send me some sample data as well so I can test/debug the macro you're
using? Paul-
“Do all the good you can,
By all the means you can,
In all t
Dear Mr.Paul,
Thanks for your reply.
I tried using this code in the existing macro of the file and observed
that, it deletes only the year 2012 and not 2011.
Also it has deleted the header row apart from old years, which shouldn't do.
The existing macro is attached for your immediate reference. P
