I am trying to take information from one sheet to another in the same workbook.
However, I would like the positive cells to be imported to the sub sequential sheets with the name of their column.
| Example1 | Example2 | Example3 -----------+-----------+----------+---------- List One | x | | x List Two | x | x | List Three | x | |
So I would like
in Sheet2 - List One
In Sheet3 - List Two
In Sheet4 - List Three
Hope that makes some kind of sense to someone! Sorry for the terrible coding, rusty rusty rusty!