Hello Gurus of the VBA world:
I could really use some expert help here.
I have a few hundred excel files named "SENSOR REPORT 01-MAR-19" something. The "SENSOR REPORT" is common to the workbook name, but the date changes and there is an excel file for everyday for the past several years in that format.
I'm trying to extract 2 specific columns (column B and Column H) from the 3rd worksheet (named "DATA") in the workbook. The workbook has several worksheets, but I'm looking to extract those 2 columns( columns B and H) only from the 3rd sheet named "DATA".
As a final product, I was wanting 3 columns with the File name(so that I can extract the date out of it later), Column B and Column H.
Can I paste all these files in a folder and run a macro to where I will get a 3 column output with the below information:
Output could be:
SENSOR REPORT 01-MAR-19 | NAME | DATA
which is pretty much:
"File name" "header of column B from worksheet named 'DATA"" "header of column H from worksheet named 'DATA""
I'd be grateful for your help. Thank you!