Using a checkbox to override a formula in a existing cell with a new formula

[Burdleggz]

I have a cell "Work Hours Per Day" (M33) which the user will populate themselves. Under the labor task breakdown I have 30 some items where production hours are divided by (M33) to get the total number of days (L49:L79). This is the process for one bid item. I have 10 bid items in one workbook and they may have the same work hours per day or they may be different. I've written a code that if a this does occur, and the single checkbox is checked, then two rows are inserted where a new "Work Hours Per Day (E47) can be manually populated. Now I need (L49:L79)'s formulas to be based on (E47) NOT (M33). Is this even possible?

 

[mrshl9898]

Some screenshots might be useful here of what you need.

You can link a checkbox to a cell, it'll give a TRUE or FALSE result if checked. With it linked to A2 something like =IF(A2,yourformula/M33,yourformula/E47) might be useful