Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help
Hello everyone,
I have an excel sheet that has some registration nos., account names, reference nos and revenue collected against each reference no. Some what like in this format: Registration No. Account names Reference no. Revenue collected 12 ABC 01 1000 18 ADC 04 500 Now I have to prepare a window wherein if I click any account names, then it should display all the regestrations nos. reference nos and revenue amount. Please help me, as I don't have any clue about this. Regards, D -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help
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). "dinadvani via OfficeKB.com" wrote: Hello everyone, I have an excel sheet that has some registration nos., account names, reference nos and revenue collected against each reference no. Some what like in this format: Registration No. Account names Reference no. Revenue collected 12 ABC 01 1000 18 ADC 04 500 Now I have to prepare a window wherein if I click any account names, then it should display all the regestrations nos. reference nos and revenue amount. Please help me, as I don't have any clue about this. Regards, D -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help
Try using a pivot table. Select Data, PivotTable and PivotChart Report,
Select the first option "Microsoft Office Excel list or database, select the range of data and click finish. Place the items on the pivot table in the areas you want. Gary "dinadvani via OfficeKB.com" wrote: Hello everyone, I have an excel sheet that has some registration nos., account names, reference nos and revenue collected against each reference no. Some what like in this format: Registration No. Account names Reference no. Revenue collected 12 ABC 01 1000 18 ADC 04 500 Now I have to prepare a window wherein if I click any account names, then it should display all the regestrations nos. reference nos and revenue amount. Please help me, as I don't have any clue about this. Regards, D -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|