I have some data in an excel workbook.
As opposed to having it in three separate sheets, what would be neat if i could press a button, one of three, and depending on which button was pressed, would hide/show data
I have row A as a title and rows B, C and D with associated Data
Row E as a title and rows, F and G with associated Data.
Row H as a title and rows, I and J with associated Data.
I'd like a visual basic script whereby when i pressed a button, only the Row A and it's associated data was shown, and if i pressed a separate button, only B and it's associated data was shown, and so on for C
This is the equivalent of "hide" and "unhiding" data but by using buttons....anyone lol, even have a clue what i am asking? :oops: