Hi there,
Wonder if any one can help me with this issue,
I have a spreadsheet with data which i need to divide between 3 people. So what I thought I should do is color format every row a different color.
ex. Row 1 = Red
Row 2 = Yellow
Row 3 = Blue
Row 4 = Red
Row 5 = Yellow
Row 6 = Blue etc.
Then add four buttons on the sheet ex. Koos, Piet, Jacob and Unhide All
The idee is when Koos presses his button all Piet and Jocobs rows should be hide and when the Unhide all button is pressed then all the rows should be unhide.
I have found code that will delete the rows with a specific color format and I don't know how to undo it and show all the line that has been delete again.
Hope someone can help
Regards
Foxy Lady
Wonder if any one can help me with this issue,
I have a spreadsheet with data which i need to divide between 3 people. So what I thought I should do is color format every row a different color.
ex. Row 1 = Red
Row 2 = Yellow
Row 3 = Blue
Row 4 = Red
Row 5 = Yellow
Row 6 = Blue etc.
Then add four buttons on the sheet ex. Koos, Piet, Jacob and Unhide All
The idee is when Koos presses his button all Piet and Jocobs rows should be hide and when the Unhide all button is pressed then all the rows should be unhide.
I have found code that will delete the rows with a specific color format and I don't know how to undo it and show all the line that has been delete again.
Hope someone can help
Regards
Foxy Lady