Posts by chirag050675

    Re: Excel macro- first sort on col.a,then b,then,c +subtotal of d,e,f based on each


    Dear Sir,


    I agree that I make a Cross Post ...but believe me I am not in intense
    to hurt anyone who hard work for my answer.... I also don't want
    to someone give their valuable time to give answer in just pressurised situation
    that "if another place , already asked and answered of this question so why I give my time???"...
    I already agree that point....but...this is negative aspect to help peoples.....this concept
    leads to nothing. Any one can't get anything...just questions stand there...


    so what is the positive aspect of cross posting???


    if cross posting happened...many people get options
    for their problems..& thus...both forums get increasing possibilities of readers ...and finally
    who satisfied??... many peoples... like searchers, readers , members, moderators newsgroups...etc..
    thus totally win-win environment created in society & improvement their knowledge's &
    incredible chances to grown-up....


    all forum's core concept is "maximum try to Help People"....if masters really want to help
    others ...they try to it without any negative thinking that " if someone already answered it..."
    this fear destroy all positivity, confidence,,,& humanity...good nature....from society..


    i just don't want to take answer & escape from here like a theft , but
    i maximum try to stay & help peoples from my obtained answer ..
    who really thirsty for their problems...


    i promise that tomorrowi will put this thread link in another forums. Where i already asked
    this questions... just because i want to give options to searchers...
    who really want ...& i must believe that they get right solutions from here &
    anywhere where this linked...posted....

    Hope you understands my helping aspect & leave open mind
    for my answer...for which i am in waiting..i attached my Excel file
    for just simple VBA macro

    Regards,
    Chiragforum.ozgrid.com/index.php?attachment/70236/

    [ATTACH=CONFIG]70230[/ATTACH]


    Dear Sir,


    first please see attached JPG Screen shot which I need via VBA Macro


    subject:- EXCEL MACRO- FIRST SORT ON COL.A,THEN B,THEN,C +
    SUBTOTAL OF D,E,F BASED ON EACH CHANGES IN A THEN EACH CHANGES IN COLUMN B


    I am in search for Excel macro
    for above requirement.


    Data Position


    (1) Total database just spread in in columns A to F
    (2) Columns A's Data's End not fix (Dynamic)
    (3) first-require macro for whole data Sort on A then Sort on B
    (4) Requirement Subtotal should be in Columns D,E,F
    (5) first of Each changes in Columns A-->> Subtotal columns D,E,F then by
    (6) Each changes in Columns B-->> Subtotal columns D,E,F

    that's it...Very simple & basic situation ...Require VBA Macro for above .


    can anyone help me??
    Regards,
    Chirag

    Re: VBA-SORT COLUMNS A,B,C,(Ascending) & SUBTOTAL COLUMN A WISE, THEN BY B WISE


    Dear Stephen sir,


    Thanks for your co-operation..& give time to reply me..
    how do I delete my above thread that declare I am also member of other forum??
    if I delete it so for people can help me...
    (you are right.... though I want to help people...but sometime deep declaration of things ...can stop the help
    towards coming to me...)
    waiting your reply.


    regards,
    Chirag


    MOD EDIT:
    Thread closed - Reposted

    Dear Sir,


    VBA-SORT COLUMNS A,B,C,(Ascending) & SUBTOTAL COLUMN A WISE, THEN BY B WISE

    Data Position
    columns A's Data end not fix (Dynamic-How many rows there, should be auto select),
    Columns after A right side , not fix (Dynamic)-Should be auto realized by excel.
    first level whole data Sort on A
    then 2nd level whole Sort on B
    Subtotal Base of Columns A in columns D,E,F then by
    Subtotal Base of Columns B in columns D,E,F
    both are stay there with Clickable Expand Collapse button on left side as regular..


    that's it...Require VBA Macro for above .


    can anyone help me??


    I am heartily & thankfully say that I am also member of MrExcel's Excel's forum below
    & also put this question for get answer...
    ("http://www.mrexcel.com/forum/e…ria-multiple-columns.html")
    & I also forever be thankful that forum for provide me solutions in excel..
    I become member also this forum ..but only intense to help other people (like Mr. Dave Hawley's
    (founder of ozgrid forum) desire to help...peoples)
    to learn Excel VBA as possible as many options available them..on searching on the web,
    for which their thirst for VBA solution ...I just create options for get solution for them to become
    member of OZGRID...to help people....hope you understand my feelings.
    & hoep your co-operation.


    Chirag...