VBA code that will re-apply my formula to the specific range of cells

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 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.

Is there a way to determine the exact range the formula needs to be applied to?

Hi Bmouse

Many thanks for a speedy response, would it help if I named the range "Sell" ?

Regards

What I mean't was - do you need to apply the formula to an entire row(s) or entire column(s), or random cells within a row(s), or random cells within a column(s), that kind of thing. Which is it?

Sorry for that, I need the formula applying to selection of rows across several coloums, One issue that I have just thought abount would be that the user can insert new lines so the ranges may increase.
Summary!$T50:$T58,Summary!$W50:$W58,Summary!$Z50:$Z58,Summary!$AC50:$AC58,Summary!$T$31:$T45,Summary!$W$31:$W45,Summary!$Z$31:$Z45,Summary!$AC$31:$AC45

Thanks for your help.

So, it seems that there is no pattern, where the formula will need to be entered, and that means all of these ranges will need to be entered in the macro manually.

In theory I have two pricing tables and four levels or pricing per table:
Table one Summary!$T50:$T58,Summary!$W50:$W58,Summary!$Z50:$Z58,Summary!$AC50:$AC58
Table two Summary!$T$31:$T45,Summary!$W$31:$W45,Summary!$Z$31:$Z45,Summary!$AC$31:$AC45

Irregular ranges are a tough pickle.

Hi TMS

I like your way of thinking, however please see the attached.

If the sales person has individual pricing the enter in to the Contact sheet C61 F61 I61 L61 these pull through to the Summary tab and the sell ranges;
Summary!$T50:$T58,Summary!$W50:$W58,Summary!$Z50:$Z58,Summary!$AC50:$AC58
Summary!$T$31:$T45,Summary!$W$31:$W45,Summary!$Z$31:$Z45,Summary!$AC$31:$AC45

Hope this helps

Due to the file size restriction I have had to delete some sheets, so some formula may error, default password "bunny"

Hi All those who have helped

It would appear that this requirement from my user is a sticky one - so I have tried to look at the issue in a different way and have identified that as opposed to reset a formula to a range of cells but to auto fill a formula on request. At the moment I have the below code which works on one column, but need to same to work with 4 different formula on four columns, can this be done?

Please Login or Register  to view this content.

Thanks in advance