OK, hopefully this is the last question from me for today:
1. For the attached, for RoyUK's code, Add a Row needs to add ONLY to the bottom of the blue range and push the lower red range down. I can't figure out the syntax for how to limit it to just that range. Right now, the code looks for the first empty row and adds there.
2. Also for the column A of that same growing/shrinking blue range, I added a Named Range (WONum) so that I can use those column A numbers as a Data Validation List in other sheets of the workbook. Right now, the named range isn't capturing the entire blue range as I add and delete rows.
3. I read a post about adding/deleting rows from named ranges. Would naming the blue range make the code easier?
4. The blue range should be unlocked, but all the red cells should be locked. Since the blue range is changing, the cell locking/unlocking needs to change also.
Many problems on this same sheet, but this template will be used for many others. I appreciate if anyone can help fix this.
Respectfully,
Lost
Bookmarks