Hey everyone,
I'm wondering if it is possible to consolidate data from multiple workbooks into 1 workbook through VBA. Every day, client files are dropped on to our server and right now we're having to manually open each file and copy and paste the column we need into a master workbook. My vision is to have a macro on the master workbook that will go through each file in the folder, and add column B from each workbook to the master file. Does this sound like a possibility?