Hi

Highlight our data and chose DataFilterAutofilter
Use the dropdown on Account Name to make your selection, all rows
containing that name will be visible.

--
Regards

Roger Govier


"dinadvani via OfficeKB.com" <u22798@uwe wrote in message
news:68964b9d03e7c@uwe...
Thanks for your idea.

but the account names are similiar for more than 1 registration. So
vlookup
does not works

please help.



scheduler wrote:
In a seperate worksheet you could create a group of cells where you
could do
a "VLOOKUP" and as you place an account name in a certain cell (say
cell a1)
all your information would come up in other cells designated (such as
b1 &
b2).

Hello everyone,

[quoted text clipped - 17 lines]
Regards,
D

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1