Blank cells issue

Hi guys,

I have 2 sheets, Sheet "Auto" where I feed and adjust with few data and sheet "Deals" where I paste only values of the data from sheet "Auto"

The problem is that on Sheet "Auto", I have "blank" cells but with formules and when I copy values to sheet "Deals", some cells just appear to be blank, but when I "go to special" and try to select only blank cells, this action does not select some blank cells that should be selected.

Does any of you know how can I fix it?

Follow attached my spreadsheet