+ Reply to Thread
Results 1 to 12 of 12

vba for arranging large data

  1. #1
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    vba for arranging large data

    dear sir

    please help me to arranging the data in excel which i am doing manually to analyze

    and data is very huge which takes lot of time

    i have created the sample excel with 2 sheets

    please let me know is it possible

    regards

    harish
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: vba for arranging large data


    Hi,

    first as it can be so easily done manually in two steps (so often no need any VBA procedure) :

    1. sort the data

    2. Use the Excel feature Sub Total and well answer to the Assistant.

    If really a VBA procedure is really necessary you can redo the same operations
    just activating before the Macro Recorder in order to get your own code base …

  3. #3
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: vba for arranging large data

    thank you sir for your valuable reply

    as i am learning thing dont know its so easy

    one more thing

    how to arrange the highest to lowest sub total in an organized manner

    regards

    harish

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: vba for arranging large data


    The result should be in the source worksheet or in another one like 'Final' ?

    In case it's on the Final worksheet do you really need a blank row between each SYMBOL ?
    Last edited by Marc L; 10-14-2021 at 09:19 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: vba for arranging large data

    Hello harishb63,

    you should read up on pivot tables
    check some youtube video's on the topic that is all you need
    no vba
    Attached Files Attached Files
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  6. #6
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: vba for arranging large data

    thankyou for your valuable reply sir

    pivot table is fine but how to arrange the largest to lowest of sub total

    and defiantly i am learn the excel as its a must

    regards harish

  7. #7
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: vba for arranging large data

    actually i need in a final sheet suppurate

    and a blank line will help me more

    thankyou sir

  8. #8
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: vba for arranging large data

    right click on the total and sort from big to small

  9. #9
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: vba for arranging large data

    thankyou sir its done

    but how did you create new pivot table in new sheet if i am trying its getting something else

    any simple way if you can explain

  10. #10
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: vba for arranging large data


    Quote Originally Posted by harishb63 View Post
    actually i need in a final sheet suppurate
    So according to post #8 you already have a non VBA way : Think Excel Before VBA !

  11. #11
    Forum Contributor
    Join Date
    02-04-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: vba for arranging large data

    yes thank you sir

    as you told first i will arrange things and then record which will make my work more easy

    one more doubt even the creating the pivot table can be recorded in macro

    and sorry for asking silly thinks

  12. #12
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: vba for arranging large data


    As nothing was silly, you very don't need to be sorry !

+ 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] Arranging the data
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-27-2020, 01:52 PM
  2. Need help with data arranging
    By eqeq.eq in forum Excel General
    Replies: 2
    Last Post: 05-25-2019, 01:16 PM
  3. Replies: 8
    Last Post: 01-02-2019, 04:55 AM
  4. [SOLVED] Arranging Data
    By QSAlan in forum Excel General
    Replies: 9
    Last Post: 11-19-2018, 01:33 AM
  5. [SOLVED] Re-arranging data
    By yorkuvir in forum Excel General
    Replies: 15
    Last Post: 05-31-2017, 12:52 PM
  6. re-arranging large amount of data using Excel 2007
    By RobertY in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2007, 06:18 AM
  7. [SOLVED] re-arranging the data
    By Lan in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 11:55 AM

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