Dear Shane Devenshire
what you have suggested is working but there is problem that i making the
counting in Rows and in the end it make total right but write jan in the end
of total as 23-jan and i am making sheet for the month of Feburary so it is
the previous month being printed. i hope you can help
cheers
waiting for urgent response from you
thanks alot