Posts by spencer264

    Re: Convert/Transpose Values/Content inside one particular column to column heading $




    spencer264
    [INDENT]run time error 1004? and debug shows as:
    r.Columns(6).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1"), Unique:=True 'copy unique reasons to a temporary sheet
    Yes 10% paid to Ozgrid and the remaining pay to Ozgrid as well?
    Is it because I apply the Macro the actual files which has more than 10,000 rows?
    Thanks[/INDENT]

    Re: Convert/Transpose Values/Content inside one particular column to column heading $


    run time error 1004? and debug shows as:
    r.Columns(6).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1"), Unique:=True 'copy unique reasons to a temporary sheet
    Yes 10% paid to Ozgrid and the remaining pay to Ozgrid as well?
    Is it because I apply the Macro the actual files which has more than 10,000 rows?
    Thanks

    The sample file is attached.


    The yellow highlighted column F (each Reason) in the sheet2 to be placed as main header in the next column and so on as seen in the sheet 3


    If they have two similar item number with 2 different reasons or more - delete the duplicate item number and place the number in each column according to its reason as seen on row 16 on the sheet3


    If they have two number with similar reason - just sum up the number


    Thank you

    The sample file is attached.


    The yellow highlighted column F (each Reason) in the sheet2 to be placed as main header in the next column and so on as seen in the sheet 3


    If they have two similar item number with 2 different reasons - delete the duplicate item number and place the number in each column according to its reason as seen on row 16 on the sheet3

    If they have two number with similar reason - just sum up the number

    Thank youforum.ozgrid.com/index.php?attachment/58634/

    Re: move several columns and sort according to the one particular column


    Quote from smuzoen;699838

    And if there is no match the row is moved to its own row on sheet 3? If no match of data on Sheet 1 then copy to left side of Sheet 3 and if no data match on Sheet 2 then move to Right side of Sheet3? Is that correct?


    Yes it does..


    It really works awesome Thank you very much