I want to know if it is possible to retrieve data from excel sheets automatically without making any changes.
For Ex: Lets say i have 100 workbooks of same type with titles Name, Location, Age, ID, Salary.
Now, is there anyway that i can trigger excel to retrieve only the Name and Salary...