Hi, I have been given a code but I can't get it to work. I would appreciate if someone could finish setting it up for me. I would like the code left in a similar style so I can modify it for other macros, I realize there are much better ways to do the code but I'm a novice and don't understand loops etc. The countifs values populate a report template which would be on the new sheet created, it is not on the sample, I assume it is not required. Help will be much appreciated.