Need Excel VBA pro to create a Macro to do this:
Insert Value for color in column O
Insert Value for column CF (1 to 200) in rows that match column O values.
Be able to run this macro on a folder of exel XLSX files,
file is saved as an XLSX file where it was found
and also saved as a .txt file in a new folder that can be assigned in the macro
Let me know how much something like this would cost.