Attached is a sheet which my group at work uses to sign off on data. A user will input data, which he or she will write along the rows. That person will then click the first button in that row, and someone will later verify that row by clicking the adjacent button.
I created this sheet to leave ample space for many possible lines, such that no one would need to modify the sheet to add more buttons.
My request would be to set this sheet up such that rows can be added or removed, leaving the blank rows out of the sheet when they are not needed. The way I have the sheet now is with a lot of VBA, making the blank file size larger than it should be.
Also, if you have a way to modify my purple boxes, let me know. I was going to go with checkboxes, but I cannot make the boxes larger, so this setup may be all that works. I also locked the input/verify part of the sheet as a safety measure - if you can recommend something better, please let me know.
Thank you very very much for your help in advance. Let me know if I can clarify anything further for you.
Bookmarks