Hie guys,
i need another guide.
how can i select distinct row and transfer to another sheets?
below are the example in sheet 1:
Name | Payment | Date
-----------------------------
John | $50 | 20/04/04
Andy | $28 | 20/04/04
Andy | $10 | 21/04/04
so for sheet 2 and 3, how do i come about macro/function t
automatically create the sheet and transfer the row distinctly b
"Name"?
eg:
Sheet 2
Name | Payment | Date
-----------------------------
John | $50 | 20/04/04
eg:
Sheet 3
Name | Payment | Date
-----------------------------
Andy | $28 | 20/04/04
Andy | $10 | 21/04/04
Thanks in advance!
Cheer
--
Message posted from
http://www.ExcelForum.com