Oops. Sorry, NoSparks,
I was a very proficient Word user, but, having retired, I use it less and thus have fallen to being only reasonably proficient. In the mid 1980s I was a power user in Lotus 123, but I’ve not used it since. Although I can work in Excel somewhat, I’m a rank beginner in Excel VBA. In Word, you have to actually insert a table; I didn’t have to insert anything into Excel, it all looked like a “table,” and that was how I had been considering it. So that was an inaccurate description: I’ll have to read up on Excel tables.
What I have is a worksheet with data arranged in several columns (but I’ve not established it as a table – would this be easier if I did?), all the cells other than those in the document-number column are protected against selection or editing. The cells in that column permit selection but not editing. What does that do to your suggested solution?
Very respectfully,
an apologetic Larry
|