Hi , 

I have a requirement wherein i  need to identify all the column names which may appear in any of the row column combination .

for example : Sheet A  : Column starts from C10 to Z10 

                    Sheet B  : Column starts from B5 to K5 

                    Sheet C  : Column starts from A14 to L14 and so on . 

How do i get the row index number ? 

Attaching a sample file for reference . (C6 to Z6 are the column headers that i need to identify )