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

Autofilter for adib.

Copy visible cells to sheet2


Gord Dibben MS Excel MVP

On Mon, 9 Mar 2009 20:56:17 +0000, adib wrote:


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:)

Hi,

You can also use Advanced filters. Use the critera as Adib. Please read up
on Advance filters in the Help menu.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"adib" wrote in message
...

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