I have a very large workbook that has columns with formulas and macros feeding other forms. There are more than 600 rows and 80 columns.


During the month it's fast and easy to use and provides valuable information. Unfortunately, the form must be "restarted" every month.

The rows require some deletion and additions and sorting alphabetically with each new month.
I have created a test form and tried a few things but every time I mess up the formulas or macros and have to undo everything.
Can anyone help?

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