AutoFill Destination: not working as it shou

Hi,

I have a worksheet which runs daily performance each week.

My Table looks like on a Monday:

BX..........BY........BZ........CA........CB...........CC
03-Mar......CSO......CSO.....Overall..Overall....(Formula)

On a Tuesday the data will increase by 1 column and look like:

BX..........BY........BZ........CA........CB...........CC
03-Mar......CSO......CSO.....Overall..Overall....(Formula)
04-Mar......CSO......CSO.....Overall..Overall....(Formula)

I've created a VB code which populates the formula within column CC and then it autofills down. This works only when i have more than 1 days worth of data can anyone advise why and what i need to change?

Please Login or Register  to view this content.

I have used the below which i think works better

Please Login or Register  to view this content.