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 information from those workbooks just by selecting the excel files?
PS: The original documents are much more complex.
Would appreciate the help. Thanks
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 information from those workbooks just by selecting the excel files?
PS: The original documents are much more complex.
Would appreciate the help. Thanks