Hi,
I need some help with allowing for a formula OR data entry in a cell depending on the result of another cell.
If cell B7 equals "tube", I want to be able to enter data into E11 and have a formula calculated in H11. OR If cell B7 equals "sheet", I want to be able to enter data into H11 and have a formula calculated in E11.
For example
Cell H11 - IF(B7="Tube",FormulaX,Data Entry)
Cell E11 - IF(B7="Sheet",FormulaY,Data Entry)
I need the switch to be automatic depending on the value of cell B7.
There there a way to do this? Maybe using vba?
Bookmarks