sorting data in another sheet

A

adib

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

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1
Locating values in a range and bringing up the corresponding price 3
find number in a data base 5
Finding the corresponding value in a range? 4
Filtering sheet data in another sheet 3
To find the same price in another sheet 2
Please help to get cross reference with another sheet 1
Sorting data in group 1

Top