Hi all,

Gravely need some assistance to write a macro that can do the
following:
Where A1,A2,C3 etc are values (in this case, A2,B2,C2 and D2 as well as
A3,B3,C3,and D3 "belong" to A1 and A6,B6,C6 and D6 belong to A5 and a
blank row seperates A1 family and A5 family

Sheet1

A B C D E F
1 A1
2 A2 B2 C2 D2
3 A3 B3 C3 D3
4 (blank row)
5 A5
6 A6 B6 C6 D6
7 (blank row)
8

I need a macro that can trigger the values from this sheet to be copied
to Sheet2 where the family the values belong to are sorted in Column D
as below

Sheet2 output should be
A B C D E F
1 (blank row)
2 B2 C2 D2 A1
3 B3 C3 D3 A1
4 B6 C6 D6 A5
5

Can anyone please help? This is rather urgent.

Thanks!

Stanley


--
stanleysi
------------------------------------------------------------------------
stanleysi's Profile: http://www.excelforum.com/member.php...fo&userid=8893
View this thread: http://www.excelforum.com/showthread...hreadid=544747