Check range another sheet excel?

Now I check value in column FYP and compare with sheet that start text config as below.
and column Type_config = sheetName that found value APPLAN follow red text)

test.xaml (22.8 KB)
Data Campaign_65 old map.xlsx (1.5 MB)

But DataRow have 10K , It take time to run.

Please guide me about it. (Fast)
@Ramya_K can you guide me for edit code?


It’s clear until the sheet part but not sure what to check in other sheet…