| SUM by Color macro Column Adjustment |

Hi everyone.

Im not a pro in xls editing, i have an xls made for me, but i had to add some columns and it messed up the functions
I would like to ask a humble voulanteer to help me out with this issue

2 Files attached

This_is_just_for_reference.xls - Here the functions still work.

This_needs_fixing.xls - This is the broken file which i would like to work with.

What i would like to achieve:

Összes export - Sums up all the red numbers on the item movement area

Összes import - Sums up all the green numbers

Készlet - Deduct Red from Green and give you the leftover. It would be nice to have a double click feature to hide all the rows which has zero in it. This double click thing already works on the other columns but hide only the empty cells not the zeros, if this could be changed to hide zero-s aswell i would be greatful

The "Újraszámolás" button, re-counts the Import and export column, the xls was too slow with autocount, this method gives good performance.

Thanks for your time guys, help would be appretiated

-Viktor

This_is_just_for_reference.xlsThis_needs_fixing.xls

actually adjusting the macro to work with the new columns would be more than enught, if anyone have the knowledge please help me out

I can offer a small little service fee, if you help me