Hello omnri,

Welcome to the Forum!

You should post your workbook. Seeing the layout, formatting, formulae, and any VBA code, will guarantee a working solution. A lot of time will also be saved by eliminating guesswork and a lot questions can be answered just by workbook itself.