I have an Excel file with two sheets. Sheet1 has a list of items, which looks like that:
Sheet2 has columns, which are named like that:
Item1 Item2 Item 3 ... Item 2000
I need to write a code which for each item in the sheet1 will find the location of the column (i.e. its number or its letter code).
This probably can be done with formulas, but I need a code, as I would like to develop it further.