Re: $$Excel-Macros$$ Family Tree

[P.VIJAYKUMAR]

Respected Prabhu,

The family tree is just used to find the hierarchy in the family.It shows
how the authority and relationships flow in the family.It is similar to an
organisation chart which shown the authority and responsibility flow from
the top(MD or Chairman) and to the floor level executives.

Regards,
VIJAYKUMAR


On Fri, May 31, 2013 at 5:01 PM, Prabhu Pinky wrote:

> can anyone pls tellme how this family tree works.. and what is the
> purpose..?
>
> Thanks & Regards,
> Prabhu R
>
>
> On 31 May 2013 16:25, Pravin Gunjal  wrote:
>
>> *Thanks Mr. Vijay.*
>>
>> -- Forwarded message --
>> From: P.VIJAYKUMAR 
>>  Date: Fri, May 31, 2013 at 11:52 AM
>> Subject: Re: $$Excel-Macros$$ Family Tree
>> To: "excel-macros@googlegroups.com" 
>>
>>
>> Respected Pravin,
>>
>> Please find the attached format of a family tree that is downloaded from
>> the link.Yes it is possible to make a family tree and also other process
>> flow diagrams in excel.Watch the "youtube link attached in the earlier mail.
>>
>> Regards,
>> VIJAYKUMAR
>>
>>
>> On Fri, May 31, 2013 at 9:46 AM, Pravin Gunjal  wrote:
>>
>>> Dear Mr Vijay,
>>>
>>> I am unable to download the file from the link given below.
>>>
>>> Is it possible to make family tree in an excel file?
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> -- Forwarded message --
>>> From: P.VIJAYKUMAR 
>>> Date: Thu, May 30, 2013 at 8:34 PM
>>> Subject: Re: $$Excel-Macros$$ Family Tree
>>> To: "excel-macros@googlegroups.com" 
>>>
>>>
>>> Respected Pravin,
>>>
>>> You can download the file from the following addresses
>>> http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967&Application=XL,&Version=11&Result=2
>>>  and also you have a youu tube video for that in this link
>>> http://www.youtube.com/watch?v=4Xymxie4beg.
>>>
>>> Regards,
>>> VIJAYKUMAR
>>>
>>>
>>> On Thu, May 30, 2013 at 7:56 PM, Pravin Gunjal wrote:
>>>
 HI,

 Is anybody having an example file how to make family tree.
 Suggestions / advice are welcome.

 Thanks,

 Regards
 Pravin Gunjal

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> P.VIJAY KUMAR
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>

Re: $$Excel-Macros$$ Look up value from Column and rows

[amar takale]

Dear xlstime
In file formula show #NUM! error.Pls see it.


On Fri, May 31, 2013 at 6:44 PM, xlstime  wrote:

>
> Hi Amar,
>
> PFA  or excel 2003
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, May 31, 2013 at 4:32 PM, amar takale  wrote:
>
>> Dear XLS
>> Can you give me this amazing formula in Excel 2003.I use Excel 2003
>> Regards
>> Amar
>>
>>
>> On Thu, May 30, 2013 at 2:10 PM, Chaya  wrote:
>>
>>> Thanks priti for your formula, it will be a new learning era for me with
>>> varities of formula knowledge.
>>>
>>>
>>>
>>>
>>> Regards,
>>> Chaya
>>>
>>> The excel learner  :-)
>>>
>>>
>>> On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav <
>>> prafulltjad...@gmail.com> wrote:
>>>
 Dear XLS,

 It is very useful formula and nice formula I was trying the same
 with sumproduct ...but it not happen...

 first time i have seen sumifs formula with index and match formula.

 Regards,
 Prafull Jadhav
 MIS executive.

 On Thu, May 30, 2013 at 1:57 PM, Chaya  wrote:

> Thank you so much Dear Xls. I was amazed you have used sum function,
> Actually i thought of sum function is used in only in numerical values
> calculation. today i came to know it is used in many calculation. thank 
> you
> for that.
>
>Thanks to all.
>
>
>
>
> Regards,
> Chaya
>
> The excel learner  :-)
>
>
> On Thu, May 30, 2013 at 1:32 PM, xlstime  wrote:
>
>> use sumifs with index and match combination..please find attached
>> solution
>>
>>
>>
>> .
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Thu, May 30, 2013 at 1:03 PM, Chaya  wrote:
>>
>>> Dear Experts,
>>>
>>>   I was trying to find the values from Rows and coumns which
>>> match the criteria from the data validation like wise in the attached 
>>> file.
>>> please suggest me the formulas, which formula might get used for finding
>>> the answer. hope that i could able to elabroate by query correctly, 
>>> please
>>> find the attachment.
>>>
>>>
>>>
>>> Thank you so much in advance.
>>> Regards,
>>> Chaya
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at
>>> http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-mac

Re: $$Excel-Macros$$ Error show while excel file opening

[amar takale]

Dear Anil,Paul,xlstime
Thanks very much for valuable guidance for solution
Regards
Amar



On Fri, May 31, 2013 at 6:47 PM, xlstime  wrote:

> Hi Amar,
>
> Just press Alt+E+K then change source or break link if no need
>
> [image: Inline image 2]
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, May 31, 2013 at 3:21 PM, amar takale  wrote:
>
>> Dear All
>> Can anybody tell me why Error show while excel file opening.when I open
>> excel file then some time to take opening & then show error like in
>> attached Screen shot sheet.
>> Pls tell me how to remove it,i think it is VBA error related.
>>
>> Regards
>> Amar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


<>

Re: $$Excel-Macros$$ Error show while excel file opening

[xlstime]

Hi Amar,

Just press Alt+E+K then change source or break link if no need

[image: Inline image 2]

.

Enjoy
Team XLS



On Fri, May 31, 2013 at 3:21 PM, amar takale  wrote:

> Dear All
> Can anybody tell me why Error show while excel file opening.when I open
> excel file then some time to take opening & then show error like in
> attached Screen shot sheet.
> Pls tell me how to remove it,i think it is VBA error related.
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


<>

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

[Paul Schreiner]

Please keep in mind that the FORUM RULES state:

3) Don't post questions regarding breaking or bypassing any security measure.


Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: danial mansoor 
To: "excel-macros@googlegroups.com" 
Sent: Fri, May 31, 2013 3:38:24 AM
Subject: RE: $$Excel-Macros$$ Re: how to crack Excel VBA password


can you send me downloadable link plz?it would be great help or can share name 
of full file name to download there are 2 3 files for download.






Date: Fri, 31 May 2013 00:10:05 -0700
From: kaursimr...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: how to crack Excel VBA password


Hi Shameer,

Many thanks for this post, it worked in less than 2 mins and saved me from 
redoing the work.


Sim

On Saturday, February 20, 2010 10:57:18 PM UTC+5:30, SHAM wrote:
To crack the password of an VBA Macro / coding first download an HEX
>Editorits available from the site http://www.chmaas.handshake. 
>de/delphi/freeware/xvi32/ xvi32.htm
>(its a very small file of 0.5 MB capacity)
>Close the workbook and open the workbook file in the hex editor. Find
>the string "DPB" and change it to "DPx" (x is in small letter). Save
>the file. Open the workbook and click OK until the workbook is open
>(one or more dialogs are displayed describing various problems with
>the VBA project). Press ALT+F11, choose the menu command Tools-
>>VBAProject Properties, navigate to the Protection tab, and change the
>password but do not remove it (note the new password). Save, close,
>and re-open the workbook. Press ALT+F11 and enter the new password.
>Choose Tools->VBAProject Properties, navigate to the Protection tab,
>and remove the password. Save the workbook.
>Now open the same workbook, You can use the password that you already
>given.
>SHAMEER P, KERALA, INDIA
>On Feb 20, 8:50 pm, sunil sasidharan 
>wrote:
>> Hi,
>>
>> I wont be able to send the file as it has some confidential data of our
>> organisations.
>>
>> Please let me know how do i go about cracking the password.
>>
>> Regards,
>> Sunil
>>
>>
>>
>> On Sat, Feb 20, 2010 at 10:04 AM, ankur  wrote:
>> > send ur file
>> > Have A Nice Time & Enjoy Life
>>
>> > Regards:
>> > CMA Ankur Pandey
>> > (Someone Different)
>>
>> > I'm not the best but i'm not like the rest~~
>>
>> >  On Sat, Feb 20, 2010 at 5:16 AM, JsinSk  wrote:
>> > > Post the file here and someone will crack it for you.
>>
>> > > On Feb 19, 9:24 am, sunil sasidharan 
>> > > wrote:
>> > >> *Hi All,*
>> > >> **
>> > >> *I need to edit an excel macro file but the VBA coing is protected and
>> > >> nobody is aware of the password.*
>> > >> **
>> > >> *Could you please help me on how do i crack the excel password or is
>> > there
>> > >> any free software available?*
>> > >> **
>> > >> *Thanks in advance for your help
>>
>> > >> Regards,
>> > >> Sunny
>> > >> *
>>
>> > > --
>>
>> > -- -- 
>>--
>> > > Some important links for excel users:
>> > > 1. Follow us on TWITTER for tips tricks and links :
>> >http://twitter.com/ exceldailytip
>> > > 2. Join our Facebook Group @
>> >http://www.facebook.com/ group.php?gid=287779555678
>> > > 3. Excel tutorials athttp://www.excel-macros. blogspot.com
>> > > 4. Learn VBA Macros athttp://www.quickvba. blogspot.com
>> > > 5. Excel Tips and Tricks athttp://exceldailytip. blogspot.com
>>
>> > > To post to this group, send email to excel-...@googlegroups.com
>>
>> > > <><><><><><><><><><><><><><><> <><><><><><><>
>> > > HELP US GROW !!
>>
>> > > We reach over 6,800 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 Facebook Group @
>> >http://www.facebook.com/ group.php?gid=287779555678
>> > 3. Excel tutorials athttp://www.excel-macros. blogspot.com
>> > 4. Learn VBA Macros athttp://www.quickvba. blogspot.com
>> > 5. Excel Tips and Tricks athttp://exceldailytip. blogspot.com
>>
>> > To post to this group, send email to excel-...@googlegroups.com
>>
>> > <><><><><><><><><><><><><><><> <><><><><><><>
>> > HELP US GROW !!
>>
>> > We reach over 6,800 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
>> >ht

$$Excel-Macros$$ Orentation issue in excel 2010 using VBA

[Chandra Shekar]

Hi,

I tried this code for aligning X axis to Minus(-)30 degree but its not
working in excel2010.

Could you please let me know whats wrong in the below code.


With ActiveChart.Axes(xlCategory).TickLabels
.Alignment = xlCenter
'.Offset = 100
.ReadingOrder = xlContext
.Orientation = -30
End With


Regards,

Chandru

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Error show while excel file opening

[Paul Schreiner]

It's not VBA related.
Somewhere in the file is a formula that refers to data in another file,
and the other file does not exist.

If you choose "Edit Links", it will show you what file is not available.
If you then "break" the link and save your file, the reference will no longer 
cause a problem.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: amar takale 
To: excel-macros@googlegroups.com
Sent: Fri, May 31, 2013 5:52:18 AM
Subject: $$Excel-Macros$$ Error show while excel file opening


Dear All
Can anybody tell me why Error show while excel file opening.when I open excel 
file then some time to take opening & then show error like in attached Screen 
shot sheet.
Pls tell me how to remove it,i think it is VBA error related.

Regards
Amar
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Charts create

[Chaya]

Hi Experts,

  I have been trying to plot a chart for the attached datas. i have
tried so many charts, like bar, line pie etc and etc, i am unable to plot
the chart in meaningful way.

  Can somebody please suggest me to plot the chart such that everyone can
easily understand in one attempt.
Experts pfa.

Thanks
Regards,
Chaya

The excel learner  :-)

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Graphs.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Family Tree

[Prabhu Pinky]

can anyone pls tellme how this family tree works.. and what is the
purpose..?

Thanks & Regards,
Prabhu R


On 31 May 2013 16:25, Pravin Gunjal  wrote:

> *Thanks Mr. Vijay.*
>
> -- Forwarded message --
> From: P.VIJAYKUMAR 
> Date: Fri, May 31, 2013 at 11:52 AM
> Subject: Re: $$Excel-Macros$$ Family Tree
> To: "excel-macros@googlegroups.com" 
>
>
> Respected Pravin,
>
> Please find the attached format of a family tree that is downloaded from
> the link.Yes it is possible to make a family tree and also other process
> flow diagrams in excel.Watch the "youtube link attached in the earlier mail.
>
> Regards,
> VIJAYKUMAR
>
>
> On Fri, May 31, 2013 at 9:46 AM, Pravin Gunjal  wrote:
>
>> Dear Mr Vijay,
>>
>> I am unable to download the file from the link given below.
>>
>> Is it possible to make family tree in an excel file?
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: P.VIJAYKUMAR 
>> Date: Thu, May 30, 2013 at 8:34 PM
>> Subject: Re: $$Excel-Macros$$ Family Tree
>> To: "excel-macros@googlegroups.com" 
>>
>>
>> Respected Pravin,
>>
>> You can download the file from the following addresses
>> http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967&Application=XL,&Version=11&Result=2
>>  and also you have a youu tube video for that in this link
>> http://www.youtube.com/watch?v=4Xymxie4beg.
>>
>> Regards,
>> VIJAYKUMAR
>>
>>
>> On Thu, May 30, 2013 at 7:56 PM, Pravin Gunjal  wrote:
>>
>>> HI,
>>>
>>> Is anybody having an example file how to make family tree.
>>> Suggestions / advice are welcome.
>>>
>>> Thanks,
>>>
>>> Regards
>>> Pravin Gunjal
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> P.VIJAY KUMAR
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive

$$Excel-Macros$$ Urgent requirement for .Net Developer in Austin, TX and Boise, Idaho

[Tina Davis]

Hi Associates,

We are looking for  well qualified  .Net Developer who has a desire&
commitment to work on project located in Austin, TX and Boise, Idaho.
Please do send the
resumes of your candidates.

*Qualifications and Education Requirements*

· Minimum 7 years experience coding in .NET with emphasis on C# as
a programming language, ASP .Net, ADO.Net and SQL Server 2000/2005/2008.

· Strong hands-on object oriented and domain design and development
experience using C# in an architecture role is preferred.

· Provides technical consulting on complex strategic initiatives in
one or more phases of application development.

· Establish and ensure compliance with technical architecture
standards, processes, principles, and methodologies.

· Experience in research and development of new technologies is
preferred.

· Desire and commitment to work on projects that extends.

· Strong interpersonal, written, and oral communication skills
required.

· Experience in the Agile methodology is preferred but not required.

· Excellent problem solving and interpersonal communication skills
are required.

· Experience working within a distributed team environment is
preferred.

· Must excel at working with peers within a team environment.

· Bachelor’s Degree in Information Technology, Computer Science,
Engineering, or related field or equivalent work experience. Relevant job
experience will also be considered in lieu of a degree.

* *

*Preferred Skills*

· Experience with large-scale enterprise applications deployed
using .NET.

· Commitment to continuing professional development and domain
expertise.

Looking forward to hear from you.

 Thanks and Regards.

Tina

   *Tina Davis ESOLVIT Inc *
Director of Operations (Serving IT Over 15
Years )


*Fax:* 512-628-6256

*Email:* t...@esolvit.com
*Web: *www.esolvit.com

**http://www.linkedin.com/in/tinaesolvit

*Esolvit Inc*
Synergy Plaza North, Suite #190, 11940 Jollyville Rd,
Austin,
TX 78759 USA

***

We respect your online privacy. This is not a unsolicited mail. under Bill
s.1618 title III passed by the 105th US. Congress this mail cannot be
considered Spam as long as we include Contact information and a method to
be removed from your mailing list. If you are not interested in receiving
e-mails from Esolvit Inc. then please reply with a remove in the subject
line and mention all the e-mail addresses to be removed with any e-mail
addresses which might be diverting the e-mails to you. Sorry for the
inconvenience.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Look up value from Column and rows

[amar takale]

Dear XLS
Can you give me this amazing formula in Excel 2003.I use Excel 2003
Regards
Amar


On Thu, May 30, 2013 at 2:10 PM, Chaya  wrote:

> Thanks priti for your formula, it will be a new learning era for me with
> varities of formula knowledge.
>
>
>
>
> Regards,
> Chaya
>
> The excel learner  :-)
>
>
> On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav 
> wrote:
>
>> Dear XLS,
>>
>> It is very useful formula and nice formula I was trying the same with
>> sumproduct ...but it not happen...
>>
>> first time i have seen sumifs formula with index and match formula.
>>
>> Regards,
>> Prafull Jadhav
>> MIS executive.
>>
>> On Thu, May 30, 2013 at 1:57 PM, Chaya  wrote:
>>
>>> Thank you so much Dear Xls. I was amazed you have used sum function,
>>> Actually i thought of sum function is used in only in numerical values
>>> calculation. today i came to know it is used in many calculation. thank you
>>> for that.
>>>
>>>Thanks to all.
>>>
>>>
>>>
>>>
>>> Regards,
>>> Chaya
>>>
>>> The excel learner  :-)
>>>
>>>
>>> On Thu, May 30, 2013 at 1:32 PM, xlstime  wrote:
>>>
 use sumifs with index and match combination..please find attached
 solution



 .

 Enjoy
 Team XLS



 On Thu, May 30, 2013 at 1:03 PM, Chaya  wrote:

> Dear Experts,
>
>   I was trying to find the values from Rows and coumns which match
> the criteria from the data validation like wise in the attached file.
> please suggest me the formulas, which formula might get used for finding
> the answer. hope that i could able to elabroate by query correctly, please
> find the attachment.
>
>
>
> Thank you so much in advance.
> Regards,
> Chaya
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may n

$$Excel-Macros$$ Re: Look up value from Column and rows

[Prince]

we can do the same in another way with a simple approch just Insert a 
columns at A1 then Concatenate Column(Abcde)
and apply this formula

=INDEX($A$1:$AF$83,MATCH($Z$8&$AA$8&AD10&$AE$8,$A$1:$A$83,0),MATCH($AB$8,$A$1:$F$1,0))

Regards
Prince

On Thursday, May 30, 2013 1:03:11 PM UTC+5:30, chaya moni wrote:
>
> Dear Experts,
>
>   I was trying to find the values from Rows and coumns which match the 
> criteria from the data validation like wise in the attached file. please 
> suggest me the formulas, which formula might get used for finding the 
> answer. hope that i could able to elabroate by query correctly, please find 
> the attachment.  
>
>
>
> Thank you so much in advance.
> Regards,
> Chaya
>
>
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Error show while excel file opening

[अनिल नारायण गवली]

Dear amar,


Its Reference file will no more valid means its reference file is no loger
exists.

Warm Regards,
Gawli Anil


On Fri, May 31, 2013 at 3:21 PM, amar takale  wrote:

> Dear All
> Can anybody tell me why Error show while excel file opening.when I open
> excel file then some time to take opening & then show error like in
> attached Screen shot sheet.
> Pls tell me how to remove it,i think it is VBA error related.
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Count Names City Wise

[Prince]

Hi Deepak,

Without using array formula you can try this one also.

=SUMPRODUCT(--($F$4:$F$13=A4)*($G$4:$G$13<>""))

Just Paste the above formula in B4 Cell And Drag the Same.

Regards
Prince

On Friday, May 31, 2013 12:59:10 PM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> I need a formula to count names of managers city wise, attached
>
> Pls advise
>
> Regards,
> Deepak
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Problem in Line Graph

[Chandra Shekar]

Hi,

Thanks for you reply I tried that option too but I will not get graph when
I do that and even I dont want to use this option as I am plotting multi
graphs in different sheets.

Regards,

Chandra Shekar B

On Thu, May 30, 2013 at 9:05 PM, xlstime  wrote:

>  Hi Chander,
>
> Change Switch Row/Column
>
> Right click in chart then go to select data then Switch Row/Column
>
> Hope it's fulfill your requirement
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I have issue with line graph *X axis title* and same is attached.
>>
>> In sheet1 I have only one record and X axis shows A2 & A3 but in Sheet2 I
>> have many records and it shows value as per column 1. Kindly let me know
>> what I am doing is correct or anything need to be changed
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Count Names City Wise

[Deepak Rawat]

Thanx !!

Regards,
Deepak


On Fri, May 31, 2013 at 1:20 PM, priti verma wrote:

> have u enter it with CSE,
> PFA for better clarification
>
>
> On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote:
>
>> its giving 1 for delhi rather than 3
>>
>> Kindly check
>>
>> regards
>>
>>
>> On Fri, May 31, 2013 at 1:08 PM, priti verma wrote:
>>
>>> use this
>>>
>>> =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0))
>>>
>>>
>>> On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat 
>>> wrote:
>>>
 Hi,

 I need a formula to count names of managers city wise, attached

 Pls advise

 Regards,
 Deepak

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1)

Re: $$Excel-Macros$$ Count Names City Wise

[priti verma]

have u enter it with CSE,
PFA for better clarification


On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote:

> its giving 1 for delhi rather than 3
>
> Kindly check
>
> regards
>
>
> On Fri, May 31, 2013 at 1:08 PM, priti verma wrote:
>
>> use this
>>
>> =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0))
>>
>>
>> On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat 
>> wrote:
>>
>>> Hi,
>>>
>>> I need a formula to count names of managers city wise, attached
>>>
>>> Pls advise
>>>
>>> Regards,
>>> Deepak
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question

Re: $$Excel-Macros$$ Count Names City Wise

[Deepak Rawat]

its giving 1 for delhi rather than 3

Kindly check

regards


On Fri, May 31, 2013 at 1:08 PM, priti verma wrote:

> use this
>
> =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0))
>
>
> On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat wrote:
>
>> Hi,
>>
>> I need a formula to count names of managers city wise, attached
>>
>> Pls advise
>>
>> Regards,
>> Deepak
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ Re: how to crack Excel VBA password

[danial mansoor]

can you send me downloadable link plz?it would be great help or can share name 
of full file name to download there are 2 3 files for download.



Date: Fri, 31 May 2013 00:10:05 -0700
From: kaursimr...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

Hi Shameer, Many thanks for this post, it worked in less than 2 mins and saved 
me from redoing the work.  Sim
On Saturday, February 20, 2010 10:57:18 PM UTC+5:30, SHAM wrote:To crack the 
password of an VBA Macro / coding first download an HEX
Editorits available from the site 
http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
(its a very small file of 0.5 MB capacity)
Close the workbook and open the workbook file in the hex editor. Find
the string "DPB" and change it to "DPx" (x is in small letter). Save
the file. Open the workbook and click OK until the workbook is open
(one or more dialogs are displayed describing various problems with
the VBA project). Press ALT+F11, choose the menu command Tools-
>VBAProject Properties, navigate to the Protection tab, and change the
password but do not remove it (note the new password). Save, close,
and re-open the workbook. Press ALT+F11 and enter the new password.
Choose Tools->VBAProject Properties, navigate to the Protection tab,
and remove the password. Save the workbook.
Now open the same workbook, You can use the password that you already
given.
SHAMEER P, KERALA, INDIA
On Feb 20, 8:50 pm, sunil sasidharan 
wrote:
> Hi,
>
> I wont be able to send the file as it has some confidential data of our
> organisations.
>
> Please let me know how do i go about cracking the password.
>
> Regards,
> Sunil
>
>
>
> On Sat, Feb 20, 2010 at 10:04 AM, ankur  wrote:
> > send ur file
> > Have A Nice Time & Enjoy Life
>
> > Regards:
> > CMA Ankur Pandey
> > (Someone Different)
>
> > I'm not the best but i'm not like the rest~~
>
> >  On Sat, Feb 20, 2010 at 5:16 AM, JsinSk  wrote:
> > > Post the file here and someone will crack it for you.
>
> > > On Feb 19, 9:24 am, sunil sasidharan 
> > > wrote:
> > >> *Hi All,*
> > >> **
> > >> *I need to edit an excel macro file but the VBA coing is protected and
> > >> nobody is aware of the password.*
> > >> **
> > >> *Could you please help me on how do i crack the excel password or is
> > there
> > >> any free software available?*
> > >> **
> > >> *Thanks in advance for your help
>
> > >> Regards,
> > >> Sunny
> > >> *
>
> > > --
>
> > --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group @
> >http://www.facebook.com/group.php?gid=287779555678
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > To post to this group, send email to excel-...@googlegroups.com
>
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
>
> > > We reach over 6,800 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 Facebook Group @
> >http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-...@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 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
>
> --
> Regards,
> Sunny









-- 

Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

 

FORUM RULES

 

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

Re: $$Excel-Macros$$ Count Names City Wise

[priti verma]

use this
=SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0))


On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat wrote:

> Hi,
>
> I need a formula to count names of managers city wise, attached
>
> Pls advise
>
> Regards,
> Deepak
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Count Names City Wise

[Deepak Rawat]

Hi,

I need a formula to count names of managers city wise, attached

Pls advise

Regards,
Deepak

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Count Names.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Changing Data Source

[xlstime]

you can define range name using Name Define manager

.

Enjoy
Team XLS



On Fri, May 31, 2013 at 10:31 AM, Amit Desai (MERU)  wrote:

>  I have multiple Pivots in which I need to change the data table range
> all together..
>
> ** **
>
> Is there any shorter way to do that all at a time?
>
> ** **
>
> ** **
>
> 
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


<>

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

[Simran K]

Hi Shameer,
 
Many thanks for this post, it worked in less than 2 mins and saved me from 
redoing the work.
 
 
Sim

On Saturday, February 20, 2010 10:57:18 PM UTC+5:30, SHAM wrote:

> To crack the password of an VBA Macro / coding first download an HEX
> Editor
>
> its available from the site 
> http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
> (its a very small file of 0.5 MB capacity)
>
> Close the workbook and open the workbook file in the hex editor. Find
> the string "DPB" and change it to "DPx" (x is in small letter). Save
> the file. Open the workbook and click OK until the workbook is open
> (one or more dialogs are displayed describing various problems with
> the VBA project). Press ALT+F11, choose the menu command Tools-
> >VBAProject Properties, navigate to the Protection tab, and change the
> password but do not remove it (note the new password). Save, close,
> and re-open the workbook. Press ALT+F11 and enter the new password.
> Choose Tools->VBAProject Properties, navigate to the Protection tab,
> and remove the password. Save the workbook.
> Now open the same workbook, You can use the password that you already
> given.
>
> SHAMEER P, KERALA, INDIA
>
> On Feb 20, 8:50 pm, sunil sasidharan 
> wrote:
> > Hi,
> >
> > I wont be able to send the file as it has some confidential data of our
> > organisations.
> >
> > Please let me know how do i go about cracking the password.
> >
> > Regards,
> > Sunil
> >
> >
> >
> > On Sat, Feb 20, 2010 at 10:04 AM, ankur  wrote:
> > > send ur file
> > > Have A Nice Time & Enjoy Life
> >
> > > Regards:
> > > CMA Ankur Pandey
> > > (Someone Different)
> >
> > > I'm not the best but i'm not like the rest~~
> >
> > >  On Sat, Feb 20, 2010 at 5:16 AM, JsinSk  wrote:
> > > > Post the file here and someone will crack it for you.
> >
> > > > On Feb 19, 9:24 am, sunil sasidharan 
> > > > wrote:
> > > >> *Hi All,*
> > > >> **
> > > >> *I need to edit an excel macro file but the VBA coing is protected 
> and
> > > >> nobody is aware of the password.*
> > > >> **
> > > >> *Could you please help me on how do i crack the excel password or is
> > > there
> > > >> any free software available?*
> > > >> **
> > > >> *Thanks in advance for your help
> >
> > > >> Regards,
> > > >> Sunny
> > > >> *
> >
> > > > --
> >
> > > 
> --
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > > To post to this group, send email to 
> > > > excel-...@googlegroups.com
> >
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > HELP US GROW !!
> >
> > > > We reach over 6,800 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 Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to 
> > > excel-...@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 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
> >
> > --
> > Regards,
> > Sunny
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. For