Need help: two csv's, pivot tables, hiding rows etc.

[Charlieee]

Every month I receive 2 big csv files with about 500-750 rows in each. Both of them have the same headers and both with sum of all the columns at the last row. The name of this row is "Summa". I would like to merge the first csv with the second one by deleting the sum-row and starting from row 2 in csv file two and again deleting the sum-row.

Now I would like to make this to a pivot table and make a new sheet from the preset filters and auto count the number of columns to add a sum row at the very right containing simple formulas like A1*B2 etc.

Hope I've made myself somwhat clear and I hope someone can help me. Thanks alot!

 

[Charlieee]

Bump

 

[Charlieee]

Obviously didn't make myself clear since I'm not getting any help.

I'd like to have a macro which automates all this. And since the csv's are of different sizes every month that'd have to be dynamic.

Thanks