I have a sheet that has data set up like this, for example:
I want my Active sheet to scan the above table from the Source tab and copy it into my Active Sheet if the row containing data is not completely zero or blank. Thus, the resulting table copied over into the Active sheet will be only Oranges, Bananas, Kiwis because Apples and Mangos are all completely zero
Apples | 0 | 0 | 0 | 0 |
Oranges | 1 | 0 | 1 | 0 |
Bananas | 1 | 1 | 0 | 0 |
Kiwis | 0 | 0 | 1 | 1 |
Mangos | 0 | 0 | 0 | 0 |
I want my Active sheet to scan the above table from the Source tab and copy it into my Active Sheet if the row containing data is not completely zero or blank. Thus, the resulting table copied over into the Active sheet will be only Oranges, Bananas, Kiwis because Apples and Mangos are all completely zero
Oranges | 1 | 0 | 1 | 0 |
Bananas | 1 | 1 | 0 | 0 |
Kiwis | 0 | 0 | 1 | 1 |