Hi, i have sheet1 with date a:h and a1:a10 many names i want to sort by
name with their data on another sheet .

For instance
A B C D
E
Name amount diduction payed balance
2 adib 20000 200 19800 0
3 costa 20000 0 10000 10000
4 adib 600 0 0
600
5 john 14000 0 14000 0
6 costa 800 100 0
700
7 july 20000 300 10000 9700
8 adib 12000 0 0
12000

i want sheet2 all data for only for adib as it is

please help me how can i do this. Thanks:)


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73224