Hello!
So I found this very cool thread on here called Allowing Users to Input Data into Cells Containing Formulas without Deleting the Formula. The thread was marked as solved but I am having trouble making it work for me. I am hoping someone can help me.
The thread teaches us how to override a formula in a cell and then when we delete the override, the original formula goes back. This is the explanation:
I did all of this and I am getting an error with my formula. When I clear the original cell I can type in whatever, and then when I delete that to make it go back to the original, it gives me an error and asks me to debug the error. I do that and it tells me this line is wrong: Target.Formula = Sheets("Template - Hidden").Cells(Target.Row, Target.Column).FormulaRe: Allowing Users to Input Data into Cells Containing Formulas without Deleting the Formula
I think I figured it out. I don't mean to step on your toes ChemistB, but this is a pretty sweet idea and I'd like to make it work too.
I right clicked on Template tab and made a copy. I named it Template - Hidden.
Back in VB land I pasted this onto Template's sheet. (the original)
Copy to clipboard
Then I added Conditional Formatting to C1 as formula: =NOT(Template!C1='Template - Hidden'!C1)Please Login or Register to view this content.
and then used the Format Painter to spread it everywhere else.
All that's left is to hide the 'Hidden' sheet. Did I miss anything?
What do I do???
I attached a copy of the workbook to help.
Bookmarks