Hello Damien2407 and Welcome to Excel Forum.
Not to say that I can help solve, however it may be easier for someone to help if we could see a sample file.
Information on attaching a file to your next post is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.