Hi Excel Team,
Thank you for my new registration!
I have a problem that needs solution, hence this post.
I am developing a financial planning model, and I am using 7 different worksheets in a single workbook. The first sheet is for raw data input and the rest of the sheets are linked to automatically populate the desired outcome (auto calculations). All is fine!
But my problem is: I do not want empty rows and cells in all other sheets (except 1st data entry sheet) to show in between as users will not necessarily input values in all rows in the data entry sheet as their business circumstances are different which will result in some rows being empty.
What I want is to automatically hide those unpopulated rows/cells and allow only populated rows. What can I do to solve my problem? please help me.
Thank you for my new registration!
I have a problem that needs solution, hence this post.
I am developing a financial planning model, and I am using 7 different worksheets in a single workbook. The first sheet is for raw data input and the rest of the sheets are linked to automatically populate the desired outcome (auto calculations). All is fine!
But my problem is: I do not want empty rows and cells in all other sheets (except 1st data entry sheet) to show in between as users will not necessarily input values in all rows in the data entry sheet as their business circumstances are different which will result in some rows being empty.
What I want is to automatically hide those unpopulated rows/cells and allow only populated rows. What can I do to solve my problem? please help me.
