help needed on sorting data based on multiple colums

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
Vikas Verma's picture

Query.....?

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

Hi Vikas,

i need to group the data in same sheet.

Vikas Verma's picture

Try This

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

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

give me some time..

thanks