VBA code that will reapply my formula to the specific range of cells

[glenn0004]

Hi All

I have an ongoing requirement that I'm trying to resolve within a sales order workbook. If Sales person has agreed a fixed price for subsequent sales order lines they enter the price in to sheet 1, and the pricing is pulled through to each order line on sheet 2. However if the Sales person has not agreed a fixed price for subsequent sales order line they manually enter the price in to the second sheet and overwrite the formula that was originally pulling through the price.

My problem is now that the formula is overwritten and the workbook is now erroneous if reused to create another order as some order lines will contain the will contain the formula and some will not. Is there a VBA code that will reapply my formula to the specific range of cells that the user can run.

Many thanks in advance.

 

[pjmorris]

Hi Mike,

That would work perfectly. I think I offered my version because I didn't think very hard about it and, perhaps, it is easier to read.

Regards

 

[glenn0004]

Thanks for this, however there a few if's and buts to accommodate my vast usergroup.

However in trying to accommodate my vast usergroup, it's been suggested to try and auto fill the required formula as opposed to reset a formula to a range of cells. At the moment i have the below which works on one column, but need to adapt the code to run different formula over different columns. any idea?

Sub FillFormula()
Range("T32").Formula = "=Contract!$C$61"
Range("T32", "T" & Cells(Rows.Count, 1).End(xlUp).Row).FillDown
End Sub

Thanks in advance