Hi and thanks for the quick replies.

The data comes from an ms sql server, so i cannot simply add rows with 0

i cannot share the worksheet either cause its a lot of cofidential stuff sorry
but feel free to ask anything