Merge the Male & Female sheet. And fill the empty cell will correct values for *Cat'y* *Pincode* *Area*
And use Pivot tabale for getting subset of the search critiria. if you don't know the Pivot table, please search in net & explore yourself. thanks Srinivasan Ethirajalu On 8/4/10, Maries <talk2mar...@gmail.com> wrote: > > Find the attached file..... > > Rgds,Maries > > > On Wed, Aug 4, 2010 at 3:57 PM, Nikhil Shah <nikhil201...@gmail.com>wrote: > >> Dear Friend, >> >> O.K. Half Problem is Resolved. >> >> Columns Add_1 ; Add_2 ; Add_3 ; Tele( c ) ; Tele ( r ) and mobile No. - >> all are empty >> >> >> ex. ... in above case, I want all the four names at once as I select Area >> "Navrangpura" and the category "Female" with all related columns filled. >> >> >> For Pl see Main menu.. >> >> Regards, >> >> Nikhil >> >> >> >> >> On Wed, Aug 4, 2010 at 4:49 PM, Maries <talk2mar...@gmail.com> wrote: >> >>> Dear Mr.Nikhil, >>> >>> Find the attached file... I hope that, this file will fulfill your >>> requirements... >>> >>> Regards, >>> >>> Marieswaran >>> >>> >>> On Wed, Aug 4, 2010 at 11:15 AM, Nikhil Shah <nikhil201...@gmail.com>wrote: >>> >>> >>>> Hi Dave >>>> >>>> Recd your E-mail.. Thanks for sending excel sheet.. >>>> >>>> but still there is something missing to Address - Excel sheet, there is >>>> an error in Main sheet.. >>>> >>>> Error... >>>> >>>> Suppose I select Area : "Navrangpura" & Category is "Female", then, here >>>> you can see that only one & the same name of Female Doctor is coming >>>> repeatedly and other columns are empty, >>>> >>>> You can see that in the Doc - Famale Sheet , there are total four >>>> Doctors in the selected area with information in other columns: >>>> >>>> So, actually I want to get all the cells of the selected data, >>>> >>>> ex. ... in above case, I want all the four names at once as I select >>>> Area "Navrangpura" and the category "Female" with all related columns >>>> filled. >>>> >>>> I am sending once again my address book - Excel sheet for your ref. >>>> >>>> pl help me out of this query.. >>>> >>>> Regards >>>> Nikhil >>>> >>>> >>>> >>>> On Wed, Aug 4, 2010 at 4:56 AM, Dave Bonallack < >>>> davebonall...@hotmail.com> wrote: >>>> >>>>> Hi, >>>>> Please have a look at the attached. >>>>> Regards - Dave. >>>>> >>>>> ------------------------------ >>>>> Date: Mon, 2 Aug 2010 17:45:28 +0530 >>>>> Subject: $$Excel-Macros$$ Address Book Problem >>>>> From: nikhil201...@gmail.com >>>>> To: excel-macros@googlegroups.com >>>>> >>>>> >>>>> Dear All Members, >>>>> >>>>> Here i am sending One Address Book - Excel Sheet.It contains ( 1 ) Main >>>>> Menu ( 2 ) Doc - Male Data ( 3 ) Doc - Female Date. >>>>> >>>>> Address Execution Mode :- >>>>> >>>>> On Main Menu First I Select Area , Then I Select Category through Pop >>>>> up list.. >>>>> >>>>> Now coming to query, >>>>> >>>>> ( 1 ). Suppose I select Category : Male... , then All Data should come >>>>> From Doc - Male Database >>>>> Female , then All Data >>>>> Should come From Doc - Female Database. >>>>> >>>>> Pl help me out for my query, as you can see it is Huge Database..it is >>>>> being updated regularly.. >>>>> >>>>> Awaiting Reply >>>>> >>>>> Nikhil Shah >>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>>> >>> >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 7000 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >>> >> >> >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > -- Srinivasan Ethirajalu, +919840544295 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe