PDA

View Full Version : VBA to extract & combine data from multiple excel file from a specific folder



Samiul
08-17-2018, 11:51 AM
I need to extract values based on some fixed matching criteria from multiple worksheets in the same workbook and paste the values in a separate active worksheet in specific rows/columns. For example in the attached image I would like to extract data from the rows having values of direct shear test & put it in another worksheet including the mean of value of the recorded data. How can I do that using vba macro. 2272722727