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

Charlieee

New Member
Joined
Apr 13, 2009
Messages
6
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!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Charlieee

New Member
Joined
Apr 13, 2009
Messages
6
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,421
Messages
5,596,033
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top