Hi Everyone!
I have 3 separate folders named A,B & C, each contains 2 files with a filename starting with folder name it is saved into and the date ( for ex.: A 14110221 & A 07112021). Each workbook has only one worksheet with two columns in it with lots of rows (up to 500k). What I am trying to do is:
Step1 - Open each workbook starting from the folder named A and merge the columns into one in each worksheet of each of the workbook (columns may have empty cells, so must delete them);
Step2 - Vlookup data from the workbook with the most recent date (as per the filename) against the workbook with more older date;
Step3 - Paste the unique data into the separate workbook (containing macro) Sheet 1;
Step4 - Paste the duplicate data into Sheet 2 (same workbook with macro);
Step5 - Run the macro which I have in order to create csv files from Sheet 1 and the Sheet 2;
Step6 - Repeat the above for the workbooks from the folders B & C;
I would really appreciate if someone could help me out with the VBA macro for the above as this is a lot of manual work to do...
I have 3 separate folders named A,B & C, each contains 2 files with a filename starting with folder name it is saved into and the date ( for ex.: A 14110221 & A 07112021). Each workbook has only one worksheet with two columns in it with lots of rows (up to 500k). What I am trying to do is:
Step1 - Open each workbook starting from the folder named A and merge the columns into one in each worksheet of each of the workbook (columns may have empty cells, so must delete them);
Step2 - Vlookup data from the workbook with the most recent date (as per the filename) against the workbook with more older date;
Step3 - Paste the unique data into the separate workbook (containing macro) Sheet 1;
Step4 - Paste the duplicate data into Sheet 2 (same workbook with macro);
Step5 - Run the macro which I have in order to create csv files from Sheet 1 and the Sheet 2;
Step6 - Repeat the above for the workbooks from the folders B & C;
I would really appreciate if someone could help me out with the VBA macro for the above as this is a lot of manual work to do...