In my Worksheet2, the data are generated based on formulas that reference to data in Worksheet1, and are formatted as a list (from A1 to AS100) like below:
<tbody>
</tbody>
Some rows and columns (except the header row) in this worksheet are empty, e.g. Row 3, Row 6, Column E, Column F.
I would like to auto hide and unhide both empty rows and columns, preferably with a button.
Any assistance or suggestions would be greatly appreciated. Thank you.
A | B | C | D | E | F | ... | AS | |
1 | ID | Code | Property1 | Property2 | Property3 | Property4 | ... | Property28 |
2 | 1 | AAA | 111 | |||||
3 | ||||||||
4 | 3 | CCC | 222 | |||||
5 | 4 | DDD | 222 | |||||
6 | ||||||||
... | ... | |||||||
100 | 99 | ZZZ | 999 |
<tbody>
</tbody>
Some rows and columns (except the header row) in this worksheet are empty, e.g. Row 3, Row 6, Column E, Column F.
I would like to auto hide and unhide both empty rows and columns, preferably with a button.
Any assistance or suggestions would be greatly appreciated. Thank you.