I have a workbook with around 20 worksheets, all the final values get consolidated onto page#1. Page #1 has over 300 rows and several columns that have the quantities and costs brought into it by simply entering the formula (cell =sheet2!E23). However, not all 300 rows have information in them. I want to add another sheet that will automatically list only the rows that have information in them from Sheet#1 without leaving blank rows in between the rows with data. Can you tell me if this is possible and how it can be accomplished? I am a beginner in Excel so I will need a detailed explanation.
If that is not possible, can all the rows on sheet#1 without data in them be hidden automatically?
Thank you for your time and effort.
