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.
Bookmarks