Hello,
I have created such a VBA userform and module, which works on any table, reading the headings and offering a simple way to edit the columns' value in a row by row (record) base. Unfortunately I have no the option to upload files, so if you want to get an idea, send me a message and I will upload a few screenshots to see how it looks like. The useform has 2 tabs, one for editing (row by row), which shows the fields (columns) of one record (row) each time, and a second one which can be used for searching rows with specific criteria (1 or more). The useform window is resizable and contains scroll bars to facilitate handling many columns and/or lengthy values.
Of course there are things which need adjustment to meet your needs: The image must be included and the listboxes for the new columns' potential values must be filled in. I can do that in 1 day. I will need the file for editing as well as the sheet which contains the possible values for the extra, new columns. Which Excel version are you using? (there are minor differences in VBA syntax, that's why I'm asking).
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs of any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
chriskerpini