Hi Noobie,
I think you have some kind of data or formula in the column...opening stock which is pushing your last row down...