I did not give enough info when i started this. I do this for months 01 - January.xlsx to 12 - December.xlsx all months. Each month has 31 days in it and i have to download the count sheet each day and put the information in manualy. With your macro i dont have to do that but will just have to change the information in the macro for the month and the day. Sorry i did not give enough detail to begin with and thank you for you help.