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
