First of all I have minimal experience with VBA. I'd like this to be a learning experience stepwise if this is possible with a single forum thread. So either I could be given chunks of code and learn that way as we go or the whole code and I could ask questions as to how each part works. I've grasped creating macros with simple tasks and with the files open on the desktop in front of me. I need to progress to these operations on whole folders without opening them and closing them manually. Thank you in advance. Sidenote: forums are awesome. I've worked on my car and learned to shave with a straight razor from forums.
I've been writing small macros to copy/paste columns of data from one open .csv file to a common worksheet in a separate workbook. For example a single folder has a .csv file for each month of data. I open the Jan.csv file, copy column D, paste column D to open AllMonths.xlsx workbook sheet 1. Close Jan.csv file (keeping AllMonths.xlsx workbook open), open Feb.csv file, copy column D, ... ... ...
Please inform me what you, the experts, need for me to start progressing on creating macros or will it be a VBA code to run operations on whole folders of data.
I've attached an example .csv file and an example master workbook that I need all column Ds from all .csv files in a folder pasted to.
Thank you tons in advance.
Bookmarks