Here is an easy one. I have a large form that prints out to be about 10 pages long. Not all of the pages are used all the time, so I have a "Table of contents" at the top of the spreadsheet that uses check boxes to hide big groups of rows (pages) that are not required. What I would like to do is have page numbers next to each check box that stay in order regardless of what boxes are selected. If boxes 2, 4, 5, and 7 are checked, the numbers next to the boxes should be 1, 2, 3, and 4 respectively. I have attached a sample spreadsheet to illustrate what I am looking for. Thanks!
Check box index example.xlsm
Bookmarks