Hello experts, I use the following loop to replace values
For Each c In Range("R2", Range("R" & Rows.Count).End(xlUp))
If c.Value = "Fra" Then c.Value = "FGX"
If c.Value = "In" Then c.Value = "I"
If c.Value = "" Then c.Value = "T"
Instead of inserting the values in the code I was wondering if I can use a config-sheet in which I report:
Column A ; Column B ; Column C ; Column D
Orginal Value ; Revised Value ; Column letter concerned by the change; Sheet concerned by the modification
Based on my example The config-sheet should be composed as following
I supposed that my for each statement is incomplete as the letter column and the sheet concerned by the change and reported in the config-sheet could be different.
Thank you again for your help