Sir, please i have a data attached where i have the same data, copied and pasted three times on a sheet. The first data is A3:A12, the second is A16:A25, the third is A29:A38.
Now, what i wish for is that, when 1 is inputted in Cell B1, only the first rows should appear (A3:A12) and the other rows for the other data (A16:A38) should be hidden automatically.
When 2 is inputted in cell B1, only the first two data should appear (A3:A25) and the third data (A29:A38) should be hidden automatically.
When 3 is inputted in cell B1, all the three data should be displayed (A3:A38), nothing should be hidden. Thank You.
Microsoft Office Professional Plus 2016 is what I use
Now, what i wish for is that, when 1 is inputted in Cell B1, only the first rows should appear (A3:A12) and the other rows for the other data (A16:A38) should be hidden automatically.
When 2 is inputted in cell B1, only the first two data should appear (A3:A25) and the third data (A29:A38) should be hidden automatically.
When 3 is inputted in cell B1, all the three data should be displayed (A3:A38), nothing should be hidden. Thank You.
Microsoft Office Professional Plus 2016 is what I use