Help to make VBA sort, summarize and paste data into desired order/grouping

Hi

I'm fairly new to writing code in VBA, and is currently trying to replicate some previous Excel-work using VBA. I'm looking for either a hint to how I can write the wished procedures most effectively, or where I can find tutorials and learning material, that could lead me in the right direction. Any help is appreciated.

Problem:

I'm trying to figure out a way to sort my raw data into the required format of my budget. This requires me to do following sorting into groups by size and summarize values for these groups as well as paste values for the wanted rows and grouping.

I wish make a sheet looking like the sheet "Budget" in the attached file. The raw data is listed in the sheet "Data"
The grouping is based on Descending sort of "Current_value" into following groups
1: "Name_org" (biggest organisation first)
2: subgroup: "Region" (Biggest region withing organisation)

*It need to summarize the values of "Previous_Value" and "Current_Value" for these groups

*It should only paste values from rows, where either "Current_Value" and "Previous_Value" > 0

*If "Current_Value" > 0 then location is included, otherwise it is left out

I expect to use the procedure on data with around 300-500 rows.

Thanks.

The sorting seems to work nicely. Unfortunately I can't see the summations in the summary sheet?

That makes sense - I really appreciate the work done. Ideally I wanted it to make subtotals for current and previous values on to parameters "Name_org" and "Region".

Awesome. The subtotal command also does the job nicely. I'll see if I can find a way of integrating it in the module you wrote - so it's all in one procedure.