Results 1 to 8 of 8

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

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Denmark
    MS-Off Ver
    2010
    Posts
    4

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] macro to grouping data and sort
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2015, 05:23 AM
  2. Replies: 1
    Last Post: 02-26-2013, 05:07 AM
  3. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  4. Excel 2007 : Data Sort with Two Row Grouping?
    By jisbell5 in forum Excel General
    Replies: 5
    Last Post: 09-13-2011, 03:31 PM
  5. Set copied data from closed workbook, paste into desired location.
    By Kenji in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2009, 11:28 AM
  6. Replies: 1
    Last Post: 10-11-2005, 01:05 PM
  7. Pls. reply Sort Data and copy to next coulmn when sort order chang
    By shital shah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1