I have a request to do two tasks in excel:
1. Working with large financial models often creates 30-50 sheets in a workbook. Therefore, navigation becomes very tough. What i would like to do is create a macro that would be identicle to the "Group" function that is available for rows and columns. However, i would like to create it for the sheets in the macro. Is that possible?
2. Also, I would like to be able to go through the active sheet, and see if any cells that are null or empty have dependents. This will help trace errors. However, a cell having a value of zero does not qualify as null or empty.