Home » Forums » Open Source Learning Center » Question and Answer

help needed on sorting data based on multiple colums

Submitted by sridhar13reddy on 22 March, 2014 - 06:23

can anyone please help me in solving the below problem using VBA code.

is it possible to group the rows based on Multiple columns using VBA Code ? i have data from A1 to K1050 ( Data may change) column D as Account, column G as tracer, column H as wirn ( reference ),
column G reference would be generally populated in either G or D or H, now i need to group the transactions based on reference ( column H or Column G or column D)

AttachmentSize
Book1.xlsx10.44 KB
‹ VBA and combo box filtering INDEX / MATCH Table Values ›
»
Vikas Verma's picture

Query.....?

Submitted by Vikas Verma on 22 March, 2014 - 07:28.

Hi Dear,

You want to group the same type of the transactions on the same sheet or on the another one.?

Thanks

»

Hi Vikas,I need to group the

Submitted by sridhar13reddy on 23 March, 2014 - 06:44.

Hi Vikas,

i need to group the data in same sheet.

»
Vikas Verma's picture

Try This

Submitted by Vikas Verma on 23 March, 2014 - 17:02.

Hi Sridhar,

Please visit : http://excelexperts.com/solution-help-needed-sorting-data-based-multiple...

Hope this will help you.

thanks

»

help needed on sorting data based on multiple colums

Submitted by sridhar13reddy on 25 March, 2014 - 05:26.

Hi Vikas,
thank you for providing the solution, i did tried to test the macro. i find this is grouping the transactions as required however i could see few duplicate transactions are getting created. the total items after running the macro is more than the actual items before running macro.
and it would be great if you can insert a blank row for the every group of transaction. can you please help me in fixing the issues.
thank you.

»
Vikas Verma's picture

ok

Submitted by Vikas Verma on 25 March, 2014 - 06:44.

give me some time..

thanks

»