fill/ remove formula based on adjacent cell value

Hi Folks,

I have a workbook that receives a daily extract from a database, from this data a bunch of calculations are performed. I need assistance in having these formula added or removed from the adjacent cells to allow for calcualations on other sheets to be correct.

In the attached workbook the two possibilities are shown where the calculations (columns AF-AH) do not go to the same number of rows as the data extracted from the database.

The easy option would be to continue correcting this on a daily basis via cut/fill, but I have had to hand this off to others, who have proven to not be as diligent in ensuring that the formula's are added or removed when neccessary.

Hence asking for assistance with a Macro better than the one that I have been able to create from browsing here.
The attached code whilst it works, takes an unworkabley long time and not all formula's work when created from the code insertion Column AO & AP in particular.

Please Login or Register  to view this content.

Any and All assistance is appreciated

Thanks in Advance
Iain

If some one is able I'd still like some help with this