I can certainly relate to the issues you are having. What exactly is it that you need help with though? Do you need help knowing what you can and cant do when formatting a worksheet? Do you need help with understanding what the code is doing? When you say formulas and macros get messed up it sounds like there needs to be a macro to "Reset" the worksheet. To do this you need to post a sample book with some of the data and the desired result so we can write something up for you.

Thanks