Posts by bantrully

Any help from anyone?

Is there any Macro that can help me with both conditions? As in if I select A in C4 then the specific Vlookup formula will run and if I select B in C4 then it will allow me to type without changing the formula.

When I will select B in column C4 it should allow me to enter number/text manually without deleting the formula. Currently, if I select B in C4 and enter any number manually then the Vlookup formula will get deleted and when I again select A in C4 the Vlookup will not work.

Column D:H contains the formula..

Hi I want to create a file where in I want to keep the formula and allow text in the same cell but basis drop-down. I am attaching my sheet for reference. Column C has a drop-down where I have 2 values A and B. If I select A, then the formula will auto populate the data from M3:R4 in columns D:H. But if I select B, then I will have the option to enter values from D:H manually without deleting the formula. Again, if I select A then my formula should pull the data from M3:R4. Thanks in advance