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