I have file config as below.
I want to read data in column APPLAN for read row4 in sheet name that start name with CONFIG row
I want to find value in every sheet and write sheet name in column50(Type Config —> Follow column in file config)
Please guide me about it.
config.xlsx (8.8 KB)
Input.xlsx (8.1 MB)