Some of today's earlier posts discussed this, but I wasn't able to apply them successfully to my issue.
I have an area for comments in a sheet titled "Arbitration" (list in cells AB2:AB15--cell 2 merged with 3, 4 with 5...14 with 15).
On another sheet titled "T.O.C." I have cells C6:C12 displaying the comments entered on the "Arbitration" sheet (or "" if no comment in corresponding cell).
VBA is all but brand new to me, so I'm hoping someone can help me hide the rows in "T.O.C." that are blank. Done correctly, only rows containing words will appear in TOC.
An enormous thanks in advance--this has been bugging me for a while.
I have an area for comments in a sheet titled "Arbitration" (list in cells AB2:AB15--cell 2 merged with 3, 4 with 5...14 with 15).
On another sheet titled "T.O.C." I have cells C6:C12 displaying the comments entered on the "Arbitration" sheet (or "" if no comment in corresponding cell).
VBA is all but brand new to me, so I'm hoping someone can help me hide the rows in "T.O.C." that are blank. Done correctly, only rows containing words will appear in TOC.
An enormous thanks in advance--this has been bugging me for a while.
