Guys,
I am looking at the best way to write this code.
I have created a randomn excel files with some data in it.
In sheet 1, the selection takes place. In sheet 2, lines gets hidden according to the selection in sheet 1.
The code can be written in two ways.
If the data are setup like in sheet 3, it is easy to right the code, but it takes time to put those "X".
On the other hand, if the data are setup like in Sheet 2, it is easy to see the data, but the code can be a bit tricky, and that is where I need some help.
Have you encountered similar subject?