I have an excel workbook with 3 worksheets, all with the same table consisting of the same columns. Each workbook has the capacity to have 20 rows of information filled in.
I need to be able to copy all the information from each three sheets onto the forth sheet after the corresponding heading.
However, is there a way to only copy the filled in rows to save large gaps on the forth page?
Thanks in advance