Macro for merge of .csv files and segegation of currencies when subtotaling

[willman32]

Hey All,

I was trying to create a macro to merge 4 different .csv files (that change daily) when I reached the roadblock that macros made for files only apply to that specific file.

Say I have 4 files : A,B,C,D (7 columns, different numbers of rows). I want to make a brand new file with the data from each day in descending order :
A
B
C
D

Again, they all have the same number of columns(7 columns), but different number of rows.

Next Question.

Is it possible, to create a macro, after they are merged:
Sort by column C descending
Sort by column G ascending
Sort by column A ascending

Then the problem here now is , to subtotal based on date (column C), but segregate based on currencies(column G , C stands for CDN and U stands for USD).

So a subtotal for C and a subtotal for U for that date (But no subtotal for the TOTAL of that date, just the different currencies on that date).

One last thing, I have no header rows and subtotals start at row 2 for excel, is it possible to include a blank row above the data in the macro then subtotal?

Before Macro:

After Macro:

 

[willman32]

Sorry for the double post! But I just wanted to note that the format of column f needs to be to 2 decimal places with a comma separator for the thousands.