|
I'm not sure I understand the first question. Do you mean you want it, when you create a new worksheet that it will automatically know that cell A1 should have a certain formula in it?
But yeah, I may just be fried (it has been a rough day) but I can't think of any way of doing either half that doesn't involve macros.
|