Hey Guys,
I am trying to create a macro to help automate the data analysis process for my research. I have CSV files that are grouped in sections of 8 which all contain data which I need to consolidate and then average for further analysis. I've written the following code which effectively opens all 8 of my desired files with a pretty simple Do Loop. Ideally, I wanted all of the data to be copied directly to my worksheet titled "master" however due to continual formatting errors within Excel I have decided to create 8 different sheets which the data from each of my 8 files are copied and pasted. So far all of this is working just fine however when I try to copy each of these columns of data and paste them onto my "master" sheet nothing is being pasted. After a little trouble shooting I noticed that after all of the data is pasted to their respective sheets each of the columns containing data are still highlighted. I've tried activating individual sheets or even selecting individual cells but nothing seems to work. I've included my code below as well as my workbook to better illustrate my set up. Any helps is greatly appreciated thanks again.
Bookmarks