+ Reply to Thread
Results 1 to 4 of 4

Sorting data dumps

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Sorting data dumps

    Hi all,

    I have created an Excel sheet to help me manage and sort data often. I have no problem doing the work manually but i have been wondering whether or not it is possible to use a macro or VBA to make the process quicker (Apologies, I am new to excel so i have no idea how to start with this!)

    On my spreadsheet, i have 5 tabs.
    Range1-Range3 is where i would paste data from an external source (The only reason i use multiple tabs for this, is because other people would use this and it reduce the risk or errors this way given that the data could take up 1000s of rows).

    When the three Range tabs are filled, i would copy and paste all, into the Data tab, adding headers then using formulas on columns C & D to get the results i am after.

    Finally, i would copy everything on the Data tab and past into the Results tab so i can remove the duplicates from column A, ID, and sort the data according to the highest value on column D, keeping the top 10 on the list.

    Any help or ideas to make this easier would be appreciated!

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sorting data dumps

    Post Before and after examples and a clear concise explanation of what you are trying to achieve.

    I looked at 13818 in your three ranges and found 5, 18, 7 ie a total of 30

    In your Data tab I see: 13818 5 4 115

    I see no correlation.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    12-04-2019
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Sorting data dumps

    PMmehmetcik, thank you for your reply.

    I am sorry for the discrepancy, I forgot to add the entries on Range3 to the Data sheet.

    Please review the attachment on this post.

    For example, 13818:
    Shows up twice in Range1 with 2 different values in column B QTY totalling (82)
    Shows up twice in Range2 with 2 different values in column B QTY totalling (33)
    Shows up twice in Range3 with 2 different values in column B QTY totalling (18)

    The Data sheet puts all that together ad adds it up. 13818 shows up 6 times (column B) QTY totalling 133.

    Te Result sheet removes the duplicates of ID, keeping the calculated totals and sorting them into deccending order according to Total QTY.
    This sheet only shows the top 10 in the list, in this example, 13818 is top of the list.

    I hope this makes sense.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sorting data dumps

    Ok this Macro should get you started.

    I am still not sure what column B is supposed to show.

    In the attached Workbook selecting the "Run Macro" Tab will........... Run the Macro.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List the differences betweed two P6 dumps exported into Excel
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-13-2018, 08:53 PM
  2. Data Dumps compiler for matching Columns
    By iamarush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2017, 03:03 AM
  3. Replies: 1
    Last Post: 12-16-2015, 01:04 PM
  4. Userform TextBox when dumps value in worksheet cell table structure is disturbed
    By John Cruz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2014, 09:14 AM
  5. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  6. Text Data Manipulation from different dumps
    By thorrrr in forum Excel General
    Replies: 12
    Last Post: 01-14-2012, 02:17 PM
  7. Excel CSV Dumps
    By Curryman54 in forum Excel General
    Replies: 3
    Last Post: 07-26-2008, 06:33 PM

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