$$Excel-Macros$$ Help me in Dashboard

[Chandra Shekar]

Hi,

Am trying to do dashboard here If I click on Radio button automatically
graph need to get change. Could you please help me on this.

Thanks,

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.
For more options, visit https://groups.google.com/d/optout.


Dboard.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Inserting Scroll Bar

[Chandra Shekar]

In the attached file when I click on scroll bar for each 5 row data should
change. Could you please let me know how do it?

Thanks,

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.
For more options, visit https://groups.google.com/d/optout.


ScrollBar.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Inserting Scroll Bar

[Chandra Shekar]

Thank you Ravinder :)


On Wed, Mar 12, 2014 at 5:07 PM, Ravinder wrote:

> PFA
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, March 12, 2014 5:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Inserting Scroll Bar
>
>
>
> In the attached file when I click on scroll bar for each 5 row data should
> change. Could you please let me know how do it?
>
>
>
> Thanks,
>
>
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ PivotTable_Calculated Field

[Chandra Shekar]

Thank you very much :)


On Tue, May 13, 2014 at 11:16 AM, Amit Desai (MERU)  wrote:

>  Hi
>
>
>
> Does this also work on column containing Non-Numeric data?
>
>
>
> Regards,
>
> *Amit*
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi
> *Sent:* 05-Mon-2014 19:43
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ PivotTable_Calculated Field
>
>
>
> Hi
>
>
>
> Refer: http://www.contextures.com/excel-pivot-table-calculated-field.html
>
>
>
> CHeers!!
>
>
>
> On Mon, May 12, 2014 at 7:08 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi,
>
>
>
> How to add calculated field in the attached file here I need to calculate
> Grand Total/Y.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
>
>
> Chandra
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>  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

$$Excel-Macros$$ On time Issue

[Chandra Shekar]

Hi,

am trying to refresh pivot every one minute but its running first time and
its not enter there after may I know what is problem in the code.

Thanks in advance.

Sub PivotsRefresh()
Dim sh As Worksheet
Dim pt As PivotTable
MsgBox "Enter..."
For Each sh In ActiveWorkbook.Sheets
'sh1 = sh.Name
   For Each pt In sh.PivotTables
   pt.PivotCache.Refresh
   Next
Next
End Sub

Sub Ontime_PivotRefresh()
Application.ScreenUpdating = False

Application.OnTime Now() + TimeValue("00:01:00"), "PivotsRefresh"
End Sub


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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ On time Issue

[Chandra Shekar]

Thanks for your replies


On Mon, Aug 11, 2014 at 8:11 PM, Vaibhav Joshi  wrote:

> see this att for ref.
>
> Cheers!!
>
>
> On Mon, Aug 11, 2014 at 8:09 PM, Vaibhav Joshi  wrote:
>
>> Hi
>>
>> In first code add at the end this line..
>>
>> Call Ontime_PivotRefresh
>>
>>
>> Cheers!!
>>
>>
>> On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> am trying to refresh pivot every one minute but its running first time
>>> and its not enter there after may I know what is problem in the code.
>>>
>>> Thanks in advance.
>>>
>>> Sub PivotsRefresh()
>>> Dim sh As Worksheet
>>> Dim pt As PivotTable
>>> MsgBox "Enter..."
>>> For Each sh In ActiveWorkbook.Sheets
>>> 'sh1 = sh.Name
>>>For Each pt In sh.PivotTables
>>>pt.PivotCache.Refresh
>>>Next
>>> Next
>>> End Sub
>>>
>>> Sub Ontime_PivotRefresh()
>>> Application.ScreenUpdating = False
>>>
>>> Application.OnTime Now() + TimeValue("00:01:00"), "PivotsRefresh"
>>> End Sub
>>>
>>>
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>  --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ VBA Interview Question

[Chandra Shekar]

Hi,

One of my colleague went for an interview and they asked How many types of
variables are there in VBA?

Could you please let me know answer to this question and can anyone share
VBA questionaries for interview?

Thanks in advance.

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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ VBA Interview Question

[Chandra Shekar]

Hi,

Thanks for your reply :)


On Wed, Aug 27, 2014 at 7:38 PM, Paul Schreiner 
wrote:

> In my opinion, a person that asks this type of question (especially in an
> interview) seems to be more interested in "book" knowledge instead of
> "practical" knowledge.
>
> To me, it's not as important that you know the answer to a question like
> this, but that you know where to FIND the answer to a question like this!
>
> I've got over 20 years experience in programming and have written and
> maintain over 120,000 lines of VBA code, and I had to LOOK UP the answer to
> your question.  Because I don't KNOW how many types there are, but I know
> when to use them!
>
> If you simply type "data types" in the vba help box, you'll find that
> there are 13 types:
>
> Boolean
> Byte
> Currency
> Date
> Double
> Integer
> Long
> LongLong
> LongPtr
> Object
> Single
> String
> Variant (default)
>  As for interview questions:  simply Google:
> vba interview questions and answers
>
> there are 82,000 hits...
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, August 27, 2014 9:09 AM
> *Subject:* $$Excel-Macros$$ VBA Interview Question
>
> Hi,
>
> One of my colleague went for an interview and they asked How many types of
> variables are there in VBA?
>
> Could you please let me know answer to this question and can anyone share
> VBA questionaries for interview?
>
> Thanks in advance.
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 con

$$Excel-Macros$$ Sum Product with Time

[Chandra Shekar]

Hello,

Could you please let me know what is the issue with sumproduct formula
where result should be 3 but its giving as 7.

Thanks in advance.

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.
For more options, visit https://groups.google.com/d/optout.


Time - Copy.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Sum Product with Time

[Chandra Shekar]

Hello Vaibhv,

It seems formula is wrong count should be 4 but its giving as 7. Could you
please check it.

Thanks in advance.

Regards,

Chandru

On Thu, Sep 11, 2014 at 8:34 PM, Vaibhav Joshi  wrote:

> chk this...
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Could you please let me know what is the issue with sumproduct formula
>> where result should be 3 but its giving as 7.
>>
>> Thanks in advance.
>>
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Unique values based on two conditions

[Chandra Shekar]

Hello,

How to get unique values based on two conditions. Could you help me in the
attached file.

Thanks in advance

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.
For more options, visit https://groups.google.com/d/optout.


Unique.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Sum Product with Time

[Chandra Shekar]

Thanks a lot

On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi  wrote:

> Chk this..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello Vaibhv,
>>
>> It seems formula is wrong count should be 4 but its giving as 7. Could
>> you please check it.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandru
>>
>> On Thu, Sep 11, 2014 at 8:34 PM, Vaibhav Joshi  wrote:
>>
>>> chk this...
>>>
>>>
>>> Cheers!!
>>>
>>> +
>>> *I did not do this for you. God is here working through me for you.*
>>>
>>> On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> Could you please let me know what is the issue with sumproduct formula
>>>> where result should be 3 but its giving as 7.
>>>>
>>>> Thanks in advance.
>>>>
>>>> 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.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>  --
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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 tit

Re: $$Excel-Macros$$ Unique values based on two conditions

[Chandra Shekar]

Thanks a lot. but its there any single formula to do this?

Regards,

Chandra

On Fri, Sep 12, 2014 at 5:31 PM, Ashish Kumar 
wrote:

> Vaibhav Bhai, Its superb.
>
>
> Regards
> Ashish
>
> On 12 September 2014 15:38, Vaibhav Joshi  wrote:
>
>> Chek this..
>>
>> Cheers!!
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> How to get unique values based on two conditions. Could you help me in
>>> the attached file.
>>>
>>> Thanks in advance
>>>
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 uns

Re: $$Excel-Macros$$ Unique values based on two conditions

[Chandra Shekar]

Ohk but am using 2010.

On Fri, Sep 12, 2014 at 9:51 PM, Vaibhav Joshi  wrote:

> hi
>
> yes, if you have excel 2013 you can try DISTINCT function, this will
> reduce length of formula...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 7:53 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Thanks a lot. but its there any single formula to do this?
>>
>> Regards,
>>
>> Chandra
>>
>> On Fri, Sep 12, 2014 at 5:31 PM, Ashish Kumar 
>> wrote:
>>
>>> Vaibhav Bhai, Its superb.
>>>
>>>
>>> Regards
>>> Ashish
>>>
>>> On 12 September 2014 15:38, Vaibhav Joshi  wrote:
>>>
>>>> Chek this..
>>>>
>>>> Cheers!!
>>>>
>>>> +
>>>> *I did not do this for you. God is here working through me for you.*
>>>>
>>>> On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar <
>>>> chandrashekarb@gmail.com> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> How to get unique values based on two conditions. Could you help me in
>>>>> the attached file.
>>>>>
>>>>> Thanks in advance
>>>>>
>>>>> 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.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>>  --
>>>> 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://g

Re: $$Excel-Macros$$ Amazing Excel formulas...

[Chandra Shekar]

Thanks Vaibhav

On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi  wrote:

> Hi,
>
> No posts since morning thought of sharing amazing excel formulas by Bill
> Jelen aka Mr. Excel.
>
> Cheers!!
> +
> *I did not do this for you. God is here working through me for you.*
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Line & Stacked Line

[Chandra Shekar]

Hello,

What is the difference between Stacked Line with Markers & Stacked line
with Markers.

Thanks in advance.

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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Line & Stacked Line

[Chandra Shekar]

Thank you

On Sun, Nov 2, 2014 at 4:41 AM, joseph camill 
wrote:

> Hi Chandra,
>
> If I have understood your question right, you want to know the difference
> between stacked line with marker and 100% stacked line with marker.
>
> 1. Stacked line and stacked line with markers Displayed with or without
> markers to indicate individual data values, stacked line charts are useful
> to show the trend of the contribution of each value over time or ordered
> categories. If there are many categories or the values are approximate, you
> should use a stacked line chart without markers.
>
> 2. 100% stacked line and 100% stacked line with markers Displayed with or
> without markers to indicate individual data values, 100% stacked line
> charts are useful to show the trend of the percentage each value
> contributes over time or ordered categories. If there are many categories
> or the values are approximate, you should use a 100% stacked line chart
> without markers.
>
> The above definitions have been taken from "
> http://www.anychart.com/products/anychart/docs/users-guide/Line-Spline-Step-Line-Chart.html
> "
>
> Hope this helps.
> Thanks,
>
> Joseph
>
> On Thu, Oct 30, 2014 at 8:11 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> What is the difference between Stacked Line with Markers & Stacked line
>> with Markers.
>>
>> Thanks in advance.
>>
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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

$$Excel-Macros$$ Changing value to percentage

[Chandra Shekar]

Hello ,

I need to display value as percentage could you please help me on attached
file.

Thank you,

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.
For more options, visit https://groups.google.com/d/optout.


Percentage.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Changing value to percentage

[Chandra Shekar]

Hello All,

I want it as value not text and am not adding with any value just I need to
display it as value with percentage.

Thanks in advance.

Regards,

Chandru

On Mon, Nov 24, 2014 at 6:51 PM, Paul Schreiner 
wrote:

> As a percentage of WHAT?
>
> is your value already a calculation?
>
> That is:
> if your "value" is a number in a column of numbers
> and you want to show what percent it is of the total,
> you' add a formula to an adjacent cell like:
>
> =A1/SUM(A:A)
>
> then, simply format the cell as "%".
>
> if the cell already IS the value, just change the cell format.
>
> otherwise, we're going to need more information.
>
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 24, 2014 7:11 AM
> *Subject:* $$Excel-Macros$$ Changing value to percentage
>
> Hello ,
>
> I need to display value as percentage could you please help me on attached
> file.
>
> Thank you,
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 respon

Re: $$Excel-Macros$$ Changing value to percentage

[Chandra Shekar]

Hello All,

Thanks all for your help. :)

On Mon, Nov 24, 2014 at 10:51 PM, Paul Schreiner 
wrote:

> Do you understand what it MEANS to calculate a percent?
>
> 10% means 10 out of 100 or 10/100 .10
> 50% is 50 out of 100 or 50/100 or .50
>
> so, you CANNOT display 1 as 1% because 1% isn't 1, it's .01
>
> the only way you can do this is to create another column and have it
> calculate
> a percentage:
> =A2/100
>
> (see attached)
>
> *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:* Mandeep Baluja 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 24, 2014 10:59 AM
> *Subject:* Re: $$Excel-Macros$$ Changing value to percentage
>
> Chandru find the attachemnt ihad get given above it will take the format
> as value. Ashish i know that its a concatenate function but as you are not
> aware about the fact whenever a concatenate function is used with text that
> value turned into a text .
>
>
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Date & Time picker in Excel 2010 - 32 & 64 Bit system

[Chandra Shekar]

Hello Team,

Is there anyway to add Date & Time picker in Excel 2010 in both 32 & 64 bit
system.

I tried in 32 bit system its working fine but not same with 64 bit system.

Can someone help me out on this.


Regards,

Chandrashekar 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

[Chandra Shekar]

Hello,

Needed difference between times(Including and excluding weekends with
Business hours from 9AM to 8PM)

Could you help me on this attachment.


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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Date_Test.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

[Chandra Shekar]

Hello Paul,

Thanks a lot. Its working fine.


Regards,

Chandru

On Wed, Feb 15, 2017 at 8:21 PM, Paul Schreiner 
wrote:

> There are several ways to approach this.
> Here's the logic I used:
> first:
> Excel date is stored as a number. (the number of days since 1/1/1900)
> Excel TIME is stored as the decimal part of a day.
> so, the date/time: 19/11/2016 12:10 PM  is actually 42693.50694
> Excel allows you to DISPLAY this value in a variety of ways, but it
> doesn't change the value.
>
> That means that to determine the time of day without regard to the date,
> you must subtract the "integer" portion of the value.
>
> Now, if you worked from Monday, 2-Feb to Friday, 10-Feb, you expect the
> result to show you worked 5 days.
> However, simply subtracting day #42772 from day #42776 gives you a
> DIFFERENCE of 4 instead of 5!
> So, you have to be careful with date arithmetic...
>
> Excel provides two functions:
> Networkdays
> Networkdays.intl
>
> Networkdays.intl provides a means to define which days are your "weekend".
> (some people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and Wednesday
> off for their "weekend")
> This also provides a means to say ALL days are workdays! (thereby,
> "including weekends").
>
> In the file attached, I created a sheet with Named Ranges for Start_Time,
> End_Time and HolidayList
> You can add/remove dates to this HolidayList as appropriate to your needs.
>
> The logic is to first calculate the number of workdays between the Start
> date and End data.
> =NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)
> Now, the End_Time - Start_Time gives you the fractional part of a day that
> represents a "full" workday.
> Multiplying this times the number of workdays results in the number of
> hours if full days are worked.
>
> This number needs to be adjusted based on the actual start/end time.
> If the start or end day is on a weekend, then the actual start/end time is
> disregarded.
> IF(WEEKDAY($A2,2)>5,0
>
> Otherwise, for the start time, subtract the actual start time (A2 -
> int(A2)) from the scheduled "Start_Time".
> Now, if the person started BEFORE the scheduled start time, this value
> will be negative and should be disregarded. (unless you wish to calculate
> "overtime", or allow for a person to come in 30 minutes early and leave 30
> minutes early?)
>
> so, to use only positive numbers, you can use:
> MAX(($A2-INT($A2))-Start_Time,0)
>
> For End time, the arithmetic is reversed: MAX(End_Time-($B2-INT($B2)),0)
>
> So, calculating the full working days, and removing the adjustments for
> start/end time, you get:
> =NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)*(End_Time-Start_Time)
> -(IF(WEEKDAY($A2,2)>5,0,MAX($A2-INT($A2)-Start_Time,0)))
> -(IF(WEEKDAY($B2,2)>5,0,MAX(End_Time-($B2-INT($B2)),0)))
>
> But if you wish to use it as a number of hours, you'll need to multiply it
> by 24.
>
> To calculate these values and INCLUDE weekends, simply change the
> Networkdays.Intl formula to include "000" and remove the IF(WEEKDAY(
> test:
> =NETWORKDAYS.INTL($A2,$B2,"000",HolidayList)*(End_Time-Start_Time)
> -(MAX($A2-INT($A2)-Start_Time,0))
> -(MAX(End_Time-($B2-INT($B2)),0))
>
> Note:
> What this technique does NOT do is check to see if the Start or End date
> is one of the listed holidays.
> Nor does it account for any time outside of the core "Business Hours".
>
> Hope this helps.
>
> *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*
> -
>
>
> On Wednesday, February 15, 2017 7:17 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Needed difference between times(Including and excluding weekends with
> Business hours from 9AM to 8PM)
>
> Could you help me on this attachment.
>
>
> 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

$$Excel-Macros$$ Changing Header Using VBA Code

[Chandra Shekar]

How to change Header using VBA code?

1. Name = Any Name
2. =Previous Month

Regards,

Chandrashekar 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Doc1.docx
Description: MS-Word 2007 document

Re: $$Excel-Macros$$ Changing Header Using VBA Code

[Chandra Shekar]

Hello Team,

Any help on this?

Regards,

Chandru

On Mon, Mar 27, 2017 at 7:40 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> How to change Header using VBA code?
>
> 1. Name = Any Name
> 2. =Previous Month
>
> Regards,
>
> Chandrashekar 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Help on Week Formula

[Chandra Shekar]

Hello Team,

Could you please help me in attached week formula.

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Week_Formula.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Help on Week Formula

[Chandra Shekar]

Hello Paul,

For Ex: If I mention date as 07/01/2017(Sat) formula should give Week 1
from there every week it should increase by 1.
1) 07-01-2017 to 07-07-2017 = Week1
2) 22-01-2017 to 28-07-2017 = Week4
3) 29-07-2017 - 04-08-2017 = Week5

Regards,

Chandru

On Tue, Jul 25, 2017 at 4:31 PM, Paul Schreiner 
wrote:

> I think you'll need to be more specific on how you want the "weeks"
> calculated.
> For instance, in August (2017) August 1 is on  a Tuesday.
>
> so, the weeks are handled:
> [image: Inline image]
>
> but, July 1 is on a Saturday,
> so, does Week 1 only have a single day?
> [image: Inline image]
>
> Or is July 1 counted as part of week 5 of June.
> If so, what is the minimum number of days counted in a week 1?
>
> Or are you wanting a simple count of days:
> Week 1 = first 7 days
> Week 2 = Second 7 days
> etc.
>
> *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*
> -
>
>
> On Tuesday, July 25, 2017 3:34 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello Team,
>
> Could you please help me in attached week formula.
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 

Re: $$Excel-Macros$$ Help on Week Formula

[Chandra Shekar]

Hello Team,

issue got resolved. Thanks All :)

Regards,

Chandru

On Mon, Jul 31, 2017 at 8:42 AM, 'Storey Thomas' via MS EXCEL AND VBA
MACROS  wrote:

>
> 
> On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com> wrote:
>
>  Subject: Re: $$Excel-Macros$$ Help on Week Formula
>  To: excel-macros@googlegroups.com
>  Date: Sunday, July 30, 2017, 11:56 PM
>
>
>  
>  On Sun, 7/30/17, 'Martinez David' via
>  MS EXCEL AND VBA MACROS 
>  wrote:
>
>   Subject: Re: $$Excel-Macros$$ Help on
>  Week Formula
>   To: excel-macros@googlegroups.com
>   Date: Sunday, July 30, 2017, 8:42 PM
>
>
>
>  
>   On Sun, 7/30/17, 'Hopkins Ruben' via
>  MS
>   EXCEL AND VBA MACROS 
>   wrote:
>
>Subject: Re: $$Excel-Macros$$
>  Help on
>   Week Formula
>To: excel-macros@googlegroups.com
>Date: Sunday, July 30, 2017,
>  3:31 PM
>
>
>
>
>  
>On Sun, 7/30/17, Chandra Shekar
>  
>wrote:
>
> Subject: Re: $$Excel-Macros$$
>   Help on
>Week Formula
> To: excel-macros@googlegroups.com
> Date: Sunday, July 30, 2017,
>   2:57 PM
>
> Hello
> Paul,
> For Ex: If I
> mention date as 07/01/2017(Sat)
>formula should give Week 1
> from there every week it should
>increase by 1.1)
> 07-01-2017 to 07-07-2017 =
>   Week12)
>22-01-2017 to
> 28-07-2017 = Week43) 29-07-2017
>   -
>04-08-2017 =
> Week5
> Regards,
> Chandru
> On Tue, Jul 25, 2017 at
> 4:31 PM, Paul Schreiner 
> wrote:
> I
> think you'll need to be more
>   specific
>on how you want
> the "weeks" calculated.For
> instance, in
>   August (2017) August 1
>is on  a
> Tuesday.
> so,
> the weeks are handled:
>
> but,
> July 1 is on a Saturday,so,
> does Week 1 only have a single
>   day?
> Or
> is July 1 counted as part of
>   week 5 of
>June.If
> so, what is the minimum number
>   of days
>counted in a week
> 1?
> Or
> are you wanting a simple count
>   of
>days:Week
> 1 = first 7 daysWeek
> 2 = Second 7 daysetc.
>
>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
> --
> ---
>
>
>
>   On Tuesday, July 25, 2017
>   3:34
>AM,
> Chandra Shekar 
> wrote:
>
>
>  Hello Team,
> Could you please help me in
>   attached
> week formula.
> 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+unsubscribe@
> googlegroups.com.
>
> To post to this group, send
>   email to
&g

$$Excel-Macros$$ Pivot Values using VBA

[Chandra Shekar]

Hello,

Could you let me know how to get pivot values using VBA in the attached
files.

For Ex: I need to get value for the month Sep-17 i.e
A, AAA & 1

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


PivotValues.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Pivot Help

[Chandra Shekar]

Hello,

Can I get result in attached using Pivot.

Thanks in advance.

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Pivot Help

[Chandra Shekar]

Hello Saleem,

Is it possible to get field one after another. that is Accp then Accp %.

Can you explain in steps how to do it. Thanks in advance.

Regards,

Chandru

On Thu, Jan 25, 2018 at 12:09 PM, Saleem Ansari 
wrote:

> Please check & revert
>
> On Wed, Jan 24, 2018 at 7:41 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Can I get result in attached using Pivot.
>>
>> Thanks in advance.
>>
>> 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Pivot Help

[Chandra Shekar]

Hello Saleem,

There is a small change in the data have attached same.

Regards,

Chandru

On Thu, Jan 25, 2018 at 4:53 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Saleem,
>
> Is it possible to get field one after another. that is Accp then Accp %.
>
> Can you explain in steps how to do it. Thanks in advance.
>
> Regards,
>
> Chandru
>
> On Thu, Jan 25, 2018 at 12:09 PM, Saleem Ansari  > wrote:
>
>> Please check & revert
>>
>> On Wed, Jan 24, 2018 at 7:41 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> Can I get result in attached using Pivot.
>>>
>>> Thanks in advance.
>>>
>>> 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 https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot (2).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ No. Of sundays between dates

[Chandra Shekar]

Hello Ankur,

Thanks will check & revert :)

Regards,

Chandru

On Sun, Jun 24, 2018 at 12:20 AM, ankur  wrote:

> Chandru
>
> please check this solution
>
>
>
>
>
> *With Regards:*
>
>  *CMA** Ankur Pandey*
>   *B.Com (H), C.M.A *
> *  Mob: :- +919532513513*
>
>
> *P* Please don't print this e-mail unless you really need it.
>
> "This e-mail message may contain confidential, proprietary or legally
> privileged information intended solely for the use of the addressee(s). If
> you are not the intended recipient, please notify the sender by e-mail and
> delete the original message. Further, you are not to copy, disclose, or
> distribute this e-mail or its contents either partly or completely. Before
> opening any attachments please check them for viruses and defects."
>
>
> On Tue, Apr 3, 2018 at 11:48 PM, AK  wrote:
>
>> Chandru,
>>
>> Please refer the sheet.
>>
>> Regards,
>> Sarvesh
>>
>> On Tue, Apr 3, 2018 at 7:46 PM, chandrashekarb.xls <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> How to know no. Of sundays between dates?
>>>
>>> Regards,
>>> Chandru
>>>
>>>
>>>
>>> Sent from my Samsung Galaxy smartphone.
>>>
>>> --
>>> 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 https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Regards,
>>
>> AK
>>
>> --
>> 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 a

Re: $$Excel-Macros$$ No. Of sundays between dates

[Chandra Shekar]

Hello Ankur,

Its working fine. thanks a lot.

Regards,

Chandru

On Tue, Apr 3, 2018 at 7:46 PM, chandrashekarb.xls <
chandrashekarb@gmail.com> wrote:

> Hello,
>
> How to know no. Of sundays between dates?
>
> Regards,
> Chandru
>
>
>
> Sent from my Samsung Galaxy smartphone.
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel Formula : Duplicate values

[Chandra Shekar]

 Hello,

Need formula which should check Column A and B For Ex: If CPI have both A &
B then its Yes. IF CPI has only A or B then it should be No.

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book3.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Excel Formula : Duplicate values

[Chandra Shekar]

Hello Paul,

Thanks its working fine.

I have one more question is there any way we can prevent deleting rows
using VBA.

Regards,

Chandru



On Wed, Jul 25, 2018 at 5:42 PM, Paul Schreiner 
wrote:

> You can use:
>
> =IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>
> 0),"Yes","No")
> *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*
> -----
>
>
> On Wednesday, July 25, 2018 7:59 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Need formula which should check Column A and B For Ex: If CPI have both A
> & B then its Yes. IF CPI has only A or B then it should be No.
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Preventing to Delete based on condition

[Chandra Shekar]

Hello,

Is there any way to prevent from deletion based on condition but without
using protecting sheet.

For ex: Prevent user to delete row lesser than 8 but still he can able to
edit it.



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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Preventing to Delete based on condition

[Chandra Shekar]

Hello Paul,

Thanks for the reply. I tried this code but if user delete entire row it
does not work.

My requirement is code should not allow to delete entire row but it should
allow to delete cells & it should allow to update cells/row.

Regards,

Chandru

On Mon, Jul 30, 2018 at 6:20 PM, Paul Schreiner 
wrote:

> I've done something like this before using a couple of different methods.
>
> It's really going to depend on what you're trying to "block".
>
> For instance, if you want to keep someone from deleting any of the rows
> 1-8, then
> you can use a SelectionChange event to test for selected rows in the 1-8
> range and the number of columns selected as greater than, say, 100...
> If the selection meets this criteria, simply change the selection and
> cancel the sub
>
> Like:
>
> Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
> Target As Range)
>Dim Targ As Range
>For Each Targ In Target.Rows
> If ((Targ.Row >= 1) And (Targ.Row <= 8)) Then
> If (Target.Columns.Count > 100) Then
> Application.EnableEvents = False
> Cells(Targ.Row, "A").Select
> Application.EnableEvents = True
> Exit Sub
> End If
> End If
>Next Targ
> End Sub
>
> *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*
> -
>
>
> On Sunday, July 29, 2018 4:06 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Is there any way to prevent from deletion based on condition but without
> using protecting sheet.
>
> For ex: Prevent user to delete row lesser than 8 but still he can able to
> edit it.
>
>
>
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Preventing to Delete based on condition

[Chandra Shekar]

Hello Paul,

Please find attached report and is it possible to disable Delete option for
all possible ways on particular condition

Regards,

Chandrashekar B

On Tue, Jul 31, 2018 at 5:03 PM, Paul Schreiner 
wrote:

> I'm not sure how you implemented the code.
> If it is installed properly, the user cannot SELECT the entire row to
> delete!
>
> The code goes in the "Thisworkbook" module.
> you can add the line:
>
> Debug.Assert False
>
> to have it pause to see if the macro is actually being called.
> *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*
> -----
>
>
> On Monday, July 30, 2018 11:59 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello Paul,
>
> Thanks for the reply. I tried this code but if user delete entire row it
> does not work.
>
> My requirement is code should not allow to delete entire row but it should
> allow to delete cells & it should allow to update cells/row.
>
> Regards,
>
> Chandru
>
> On Mon, Jul 30, 2018 at 6:20 PM, Paul Schreiner 
> wrote:
>
> I've done something like this before using a couple of different methods.
>
> It's really going to depend on what you're trying to "block".
>
> For instance, if you want to keep someone from deleting any of the rows
> 1-8, then
> you can use a SelectionChange event to test for selected rows in the 1-8
> range and the number of columns selected as greater than, say, 100...
> If the selection meets this criteria, simply change the selection and
> cancel the sub
>
> Like:
>
> Private Sub Workbook_SheetSelectionChange( ByVal Sh As Object, ByVal
> Target As Range)
>
>Dim Targ As Range
>For Each Targ In Target.Rows
> If ((Targ.Row >= 1) And (Targ.Row <= 8)) Then
> If (Target.Columns.Count > 100) Then
> Application.EnableEvents = False
> Cells(Targ.Row, "A").Select
> Application.EnableEvents = True
> Exit Sub
> End If
> End If
>Next Targ
> End Sub
>
> *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*--
> ---
>
>
> On Sunday, July 29, 2018 4:06 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Is there any way to prevent from deletion based on condition but without
> using protecting sheet.
>
> For ex: Prevent user to delete row lesser than 8 but still he can able to
> edit it.
>
>
>
> 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 <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+unsubscribe@ googlegroups.com
> .
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/ group/excel-macros
> <https://groups.google.com/group/excel-macros>.
> For more options, visit https://groups.google.com/d/ optout
> <https://groups.google.com/d/optout>.
>
>
> --
> 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 @ 
> htt

$$Excel-Macros$$ Cannot save the attachment. Not found : Outlook 365

[Chandra Shekar]

Hello,

am getting this error while saving attachment from Outlook 365.

How to resolve this issue?

Regards,

Chandrashekar 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel Code to save Outlook Attachment

[Chandra Shekar]

Hello,

How to save attachments from Outlook(Particular Folder not under Inbox) to
local drive.

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Removing duplicates within cell

[Chandra Shekar]

Hello,

How to remove duplicates within a cell using VBA?

Please find attached sample file for the same.

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.
For more options, visit https://groups.google.com/d/optout.


Duplicates_Cell.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Removing duplicates within cell

[Chandra Shekar]

Hi,

Thanks for your reply. If possible both the steps Macro as well using
formulas.

Regards,

Chandru

On Tue, Feb 24, 2015 at 6:07 PM, Paul Schreiner 
wrote:

> What type of solution are you looking for:
> VBA macro?
> steps in Excel?
>
> Do you know how to use/maintain a VBA macro if one is provided?
>
> in your example:
> f,g,a,b,f would result in f,g,a,b
> not f,g,a
>
>
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, February 24, 2015 5:16 AM
> *Subject:* $$Excel-Macros$$ Removing duplicates within cell
>
> Hello,
>
> How to remove duplicates within a cell using VBA?
>
> Please find attached sample file for the same.
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Removing duplicates within cell

[Chandra Shekar]

Hi,

Correct Paul it should be f, g, a, b. if possible please provide solution
for both.

Regards,

Chandru

On Wed, Feb 25, 2015 at 11:51 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Thanks for your reply. If possible both the steps Macro as well using
> formulas.
>
> Regards,
>
> Chandru
>
> On Tue, Feb 24, 2015 at 6:07 PM, Paul Schreiner 
> wrote:
>
>> What type of solution are you looking for:
>> VBA macro?
>> steps in Excel?
>>
>> Do you know how to use/maintain a VBA macro if one is provided?
>>
>> in your example:
>> f,g,a,b,f would result in f,g,a,b
>> not f,g,a
>>
>>
>>
>> *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:* Chandra Shekar 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Tuesday, February 24, 2015 5:16 AM
>> *Subject:* $$Excel-Macros$$ Removing duplicates within cell
>>
>> Hello,
>>
>> How to remove duplicates within a cell using VBA?
>>
>> Please find attached sample file for the same.
>>
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>--
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 i

Re: $$Excel-Macros$$ Re: Removing duplicates within cell

[Chandra Shekar]

Hello Michael,

Thanks for the solution.

Regards,

Chandru

On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth 
wrote:

> Hi Chandru,
>
> Please find the attached macro files for Removing Duplicates within the
> cell.
>
> Kindly let me know, if you have any queries.
>
> Regards,
> MV
>
> On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote:
>
>> Hello,
>>
>> How to remove duplicates within a cell using VBA?
>>
>> Please find attached sample file for the same.
>>
>> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Working with Merged cells : Sumproduct/Countifs

[Chandra Shekar]

Hello,

PFA file and am trying to get counts based on merged cells. I have given
comments in Column G. Could you help me on this.

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.
For more options, visit https://groups.google.com/d/optout.


Sumproduct_Multicondition.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

[Chandra Shekar]

Hello Mandeep,

Thanks for the formula. is there any way we can work on merged cells?

On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja 
wrote:

> unmerge your cells and Fill it down to create a helper and use this
> formula.
>
> Regards,
> Mandeep Baluja
>
>
> On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote:
>>
>> Hello,
>>
>> PFA file and am trying to get counts based on merged cells. I have given
>> comments in Column G. Could you help me on this.
>>
>> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

[Chandra Shekar]

Hello Mandeep,

Formula does not work when Column B is General Field(Mix of Text & Number
format). Please find attached sheet.

Regards,

Chandru

On Tue, Apr 14, 2015 at 4:08 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Mandeep,
>
> Thanks for the formula. is there any way we can work on merged cells?
>
> On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja 
> wrote:
>
>> unmerge your cells and Fill it down to create a helper and use this
>> formula.
>>
>> Regards,
>> Mandeep Baluja
>>
>>
>> On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote:
>>>
>>> Hello,
>>>
>>> PFA file and am trying to get counts based on merged cells. I have given
>>> comments in Column G. Could you help me on this.
>>>
>>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.


Sumproduct_Multicondition (1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

[Chandra Shekar]

Hello,

Thanks much :-)

On Tue, Apr 14, 2015 at 8:34 PM, Vaibhav Joshi  wrote:

> Check this...
>
> Add two helper column & see formula in Green, i have tested for both of
> sample data given by you & its working..
>
>
> Cheers!!
>
> On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello Mandeep,
>>
>> Formula does not work when Column B is General Field(Mix of Text & Number
>> format). Please find attached sheet.
>>
>> Regards,
>>
>> Chandru
>>
>> On Tue, Apr 14, 2015 at 4:08 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello Mandeep,
>>>
>>> Thanks for the formula. is there any way we can work on merged cells?
>>>
>>> On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja 
>>> wrote:
>>>
>>>> unmerge your cells and Fill it down to create a helper and use this
>>>> formula.
>>>>
>>>> Regards,
>>>> Mandeep Baluja
>>>>
>>>>
>>>> On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> PFA file and am trying to get counts based on merged cells. I have
>>>>> given comments in Column G. Could you help me on this.
>>>>>
>>>>> 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.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>  --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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) ! J

$$Excel-Macros$$ Error : FileDialog

[Chandra Shekar]

Hello,

Could you please help me in attached excel file am getting error in
diaFolder.Filters.Add "Excel", "*.xls", 1 line.

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.
For more options, visit https://groups.google.com/d/optout.


Book3.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Error : FileDialog

[Chandra Shekar]

Hello,

Its working now may I know what is different between
msoFileDialogFilePicker and msoFileDialogFolderPicker.

Thanks in advance.

Regards,

Chandru

On Thu, Aug 20, 2015 at 2:54 PM, Mandeep Baluja 
wrote:

> use this line
>
> Set diaFolder = Application.FileDialog(msoFileDialogFilePicker)
>
> regards,
> mandeep baluja
>
>
>
> On Wednesday, August 19, 2015 at 5:32:06 PM UTC+5:30, Chandru wrote:
>>
>> Hello,
>>
>> Could you please help me in attached excel file am getting error in
>> diaFolder.Filters.Add "Excel", "*.xls", 1 line.
>>
>> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Error : FileDialog

[Chandra Shekar]

Hello,

Thanks for explaining it. Sorry for the late reply.

Regards,

Chandru

On Fri, Aug 21, 2015 at 5:26 PM, Paul Schreiner 
wrote:

> I think the confusion is in the portion of the terms themselves:
> msoFileDialogFilePicker
> mso: Micro Soft Object
> File: FileSYSTEM (not a "file")
> Dialog: Interactive communication tool
> File/Folder: Type of object to select.
> Picker: purpose of the object
>
> So, basically, msoFileDialogFilePicker is a flag telling the Filesystem
> Dialog method to return the name of a selected FILE,
> msoFileDialogFolderPicker returns the name of a selected FOLDER.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, August 21, 2015 12:55 AM
> *Subject:* Re: $$Excel-Macros$$ Re: Error : FileDialog
>
> Hello,
>
> Its working now may I know what is different between
> msoFileDialogFilePicker and msoFileDialogFolderPicker.
>
> Thanks in advance.
>
> Regards,
>
> Chandru
>
>
>
> On Thu, Aug 20, 2015 at 2:54 PM, Mandeep Baluja 
> wrote:
>
> use this line
>
> Set diaFolder = Application.FileDialog(msoFileDialogFilePicker)
>
> regards,
> mandeep baluja
>
>
>
> On Wednesday, August 19, 2015 at 5:32:06 PM UTC+5:30, Chandru wrote:
>
> Hello,
>
> Could you please help me in attached excel file am getting error in
> diaFolder.Filters.Add "Excel", "*.xls", 1 line.
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.

$$Excel-Macros$$ Re: Delivery Status Notification (Failure)

[Chandra Shekar]

Hello,
I need to select folder and wat ever excel files are there in that folder I
need to work on it.
Is there any way to do this?

Even I cannot able to send mail to excel-macros group accidentaly i got
unsubscribed may I know wat is the procedure to subscribe again

Regards,
Chandru

On Fri, Aug 28, 2015 at 12:27 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
> I need to select folder and wat ever excel files are there in that folder
> I need to work on it.
>
> Is there any way to do this?
> Regards,
> Chandru
>
>
>
> On Wed, Aug 26, 2015 at 12:25 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> I need to choose files from folder itself is there any way to do this?
>>
>>
>> Regards,
>>
>> Chandru
>>
>> On Tue, Aug 25, 2015 at 2:09 PM, Mail Delivery Subsystem <
>> mailer-dae...@google.com> wrote:
>>
>>> Hello chandrashekarb@gmail.com,
>>>
>>> We're writing to let you know that the group you tried to contact
>>> (excel-macros) may not exist, or you may not have permission to post
>>> messages to the group. A few more details on why you weren't able to post:
>>>
>>>  * You might have spelled or formatted the group name incorrectly.
>>>  * The owner of the group may have removed this group.
>>>  * You may need to join the group before receiving permission to post.
>>>  * This group may not be open to posting.
>>>
>>> If you have questions related to this or any other Google Group, visit
>>> the Help Center at http://groups.google.com/support/.
>>>
>>> Thanks,
>>>
>>> Google Groups
>>>
>>>
>>>
>>> - Original message -
>>>
>>> X-Received: by 10.13.213.201 with SMTP id
>>> x192mr27147882ywd.12.1440491996057;
>>> Tue, 25 Aug 2015 01:39:56 -0700 (PDT)
>>> Return-Path: 
>>> Received: from mail-yk0-x22f.google.com (mail-yk0-x22f.google.com.
>>> [2607:f8b0:4002:c07::22f])
>>> by gmr-mx.google.com with ESMTPS id
>>> v73si3005308ywa.3.2015.08.25.01.39.56
>>> for 
>>> (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256
>>> bits=128/128);
>>> Tue, 25 Aug 2015 01:39:56 -0700 (PDT)
>>> Received-SPF: pass (google.com: domain of chandrashekarb@gmail.com
>>> designates 2607:f8b0:4002:c07::22f as permitted sender)
>>> client-ip=2607:f8b0:4002:c07::22f;
>>> Authentication-Results: gmr-mx.google.com;
>>>spf=pass (google.com: domain of chandrashekarb@gmail.com
>>> designates 2607:f8b0:4002:c07::22f as permitted sender) smtp.mailfrom=
>>> chandrashekarb@gmail.com;
>>>dmarc=pass (p=NONE dis=NONE) header.from=gmail.com
>>> Authentication-Results: mx.google.com;
>>>dkim=pass header.i=@gmail.com
>>> Received: by mail-yk0-x22f.google.com with SMTP id i184so148546847ykb.2
>>> for ; Tue, 25 Aug 2015 01:39:56
>>> -0700 (PDT)
>>> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
>>> d=gmail.com; s=20120113;
>>>
>>> h=mime-version:in-reply-to:references:date:message-id:subject:from:to
>>>  :content-type;
>>> bh=1OAj658jBw5p5ir9c33FWSlIdAWtFy0HTQiFZ4JPVx4=;
>>>
>>> b=mx4dCzzgT4T5K0tqoECacpawFTZYKafHv217bV+6RWImcKFgpCPrN7bxpbAgaWwKkw
>>>
>>>  KFjljq1OnVtFa0hxZn52zgFBSs6yW3B5UFC2zXqJb4OEg2URMKYVaQoI7yQNiztZ91vI
>>>
>>>  308CxycsbauUudyZWv87bcdRFRrIvSZOlhfSdBMbgNXY6i2MkVrdVhwHPnVu6akq0axP
>>>
>>>  zhgktry9j+4eIm0eZGn2BAXyC3ASUpwxmNATs9bcM4olH/bDZTHdnLqbB9zRpHpY4lWN
>>>
>>>  m/TeUyk8popWbWbtpk+JSviiWoJbX2xqTzFpL010mkfaIWCSvGarqqWDt6/5TqVysn30
>>>  u8Og==
>>> MIME-Version: 1.0
>>> X-Received: by 10.129.44.139 with SMTP id
>>> s133mr35121531yws.161.1440491995939;
>>>  Tue, 25 Aug 2015 01:39:55 -0700 (PDT)
>>> Received: by 10.37.105.65 with HTTP; Tue, 25 Aug 2015 01:39:55 -0700
>>> (PDT)
>>> In-Reply-To: <
>>> cao32_wsr15acctznj72rz70h23a+gs7lacektsprxjxmjzr...@mail.gmail.com>
>>> References: <
>>> cao32_wsid9trwxxfmkd16v7djxmi_rgcmkdzpoddgdg-7-t...@mail.gmail.com>
>>> <1322010657.8505724.1440158164436.javamail.ya...@mail.yahoo.com>
>>> <
>>> cao32_wsr15acctznj72rz70h23a+gs7lacektsprxjxmjzr...@mail.gmail.com>
>>> Date: Tue, 25 Aug 2015 14:09:55 +0530
>>> Message-ID: >> z5x9npuyda6fmzu1ow

$$Excel-Macros$$ Min With Index

[Chandra Shekar]

Hello,

Am trying to find out student name who scored min marks using index & min
function but its giving error. Could you please find attached workbook and
let me know where its wrong.

Thanks,

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.
For more options, visit https://groups.google.com/d/optout.


Minimum_Index.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Mail : Outlook

[Chandra Shekar]

Hi,

How to send range in outlook. Could anyone help me with VBA code?


Thanks,

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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Mail : Outlook

[Chandra Shekar]

Thanks :-)

On Sat, Oct 10, 2015 at 11:25 AM, Leo  wrote:

> Fist of all do:
>
> *Add a reference to the Microsoft Outlook Library in Excel*
> *1) Go to the VBA editor with the shortcut Alt - F11*
> *2) Click on Tools>References in the Menu bar*
> *3) Place a Checkmark before Microsoft Outlook ? Object Library*
> *Where ? is the Outlook version number*
>
>
> and -> http://www.rondebruin.nl/win/s1/outlook/bmail4.htm
>
>
>
>
>
>
>
> Em sexta-feira, 9 de outubro de 2015 08:43:54 UTC-3, Chandra Shekar
> escreveu:
>>
>> Hi,
>>
>> How to send range in outlook. Could anyone help me with VBA code?
>>
>>
>> Thanks,
>>
>> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Saving attachments : Outlook

[Chandra Shekar]

Hi,

I need a OUTLOOK code to save attachments in folder (Not excel code) based
on subject line.


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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Task Scheduler

[Chandra Shekar]

Hello,

Is it possible to schedule task in windows which will oepn at 10 AM and
ends at 6:00 PM(Office working hours) but not using onkey in VBA.


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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Task Scheduler

[Chandra Shekar]

Hi,

Need to schedule through WIndows Task Scheduler.
Control Panel\All Control Panel Items\Administrative Tools\Task Scheduler


Regards,

Chandru

On Mon, Oct 19, 2015 at 4:18 PM, Paul Schreiner 
wrote:

> Are you saying that you want VBA to schedule a task?
>
> In the past, I created a userform in Excel to create a Scheduled Task.
> (Our Windows Profile had the task Scheduler locked out)
>
> The VBA macro made use of the "command line" for creating scheduled tasks:
> schtasks /create /tn 
>  /tr 
>  /sc weekly [/mo {1 - 52}]
> [/d {[,MON - SUN...] | *}]
> [/st ]
> [/sd ]
> [/ed ]
> [/it]
> [/ru {[\]
> [/rp ] | System}]
> [/s 
> [/u [\]
> [/p ]]]
>
> for instance, I have a vbscript that runs hourly to check for files in a
> specific folder to move to a "released" folder.
>
> schtasks /delete /tn "Release ADTL"  /f
> schtasks /create /tn "Release ADTL"
>  /tr "C:\WINNT\system32\wscript.exe c:\temp\Release-ADTL.vbs ALL"
>  /sc hourly
>  /st 8:00:00
>
> In my VBA, I create the schtasks command line and write it to a .bat file
> (I called it C:\temp\create_task.bat)
>
> Then, I used:
> stat = Shell("C:\temp\create_task.bat") to execute the .bat file.
>
> I think to stop your program at a specific time you could use:
>
> schtasks /end 
>
> I'm sure you can google some examples.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, October 18, 2015 11:51 PM
> *Subject:* $$Excel-Macros$$ Task Scheduler
>
> Hello,
>
> Is it possible to schedule task in windows which will oepn at 10 AM and
> ends at 6:00 PM(Office working hours) but not using onkey in VBA.
>
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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 exc

Re: $$Excel-Macros$$ Task Scheduler

[Chandra Shekar]

Hello,

Okay. Is there steps to do it?


Regards,

Chandru

On Tue, Oct 20, 2015 at 5:13 PM, Paul Schreiner 
wrote:

> It's the same Task Scheduler.
>
> Basically, the Operating System has an application that handles scheduled
> tasks.
>
> Windows has an application that serves as an INTERFACE to the task handler.
>
> There is a CMD interface called schtasks that also serves as an interface
> to the same task handler.
>
> If you use a .bat file and schtasks as described below,
> it will make an entry that you can view and modify in the Windows Task
> Scheduler.
>
> So, you can use VBA to create and run a .bat file that can make or change
> entries to the Task Scheduler.
>
>
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, October 20, 2015 2:55 AM
> *Subject:* Re: $$Excel-Macros$$ Task Scheduler
>
> Hi,
>
> Need to schedule through WIndows Task Scheduler.
> Control Panel\All Control Panel Items\Administrative Tools\Task Scheduler
>
>
> Regards,
>
> Chandru
>
>
>
> On Mon, Oct 19, 2015 at 4:18 PM, Paul Schreiner 
> wrote:
>
> Are you saying that you want VBA to schedule a task?
>
> In the past, I created a userform in Excel to create a Scheduled Task.
> (Our Windows Profile had the task Scheduler locked out)
>
> The VBA macro made use of the "command line" for creating scheduled tasks:
> schtasks /create /tn 
>  /tr 
>  /sc weekly [/mo {1 - 52}]
> [/d {[,MON - SUN...] | *}]
> [/st ]
> [/sd ]
> [/ed ]
> [/it]
> [/ru {[\]
> [/rp ] | System}]
> [/s 
> [/u [\]
> [/p ]]]
>
> for instance, I have a vbscript that runs hourly to check for files in a
> specific folder to move to a "released" folder.
>
> schtasks /delete /tn "Release ADTL"  /f
> schtasks /create /tn "Release ADTL"
>  /tr "C:\WINNT\system32\wscript.exe c:\temp\Release-ADTL.vbs ALL"
>  /sc hourly
>  /st 8:00:00
>
> In my VBA, I create the schtasks command line and write it to a .bat file
> (I called it C:\temp\create_task.bat)
>
> Then, I used:
> stat = Shell("C:\temp\create_task.bat") to execute the .bat file.
>
> I think to stop your program at a specific time you could use:
>
> schtasks /end 
>
> I'm sure you can google some examples.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, October 18, 2015 11:51 PM
> *Subject:* $$Excel-Macros$$ Task Scheduler
>
> Hello,
>
> Is it possible to schedule task in windows which will oepn at 10 AM and
> ends at 6:00 PM(Office working hours) but not using onkey in VBA.
>
>
> 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+

Re: $$Excel-Macros$$ Task Scheduler

[Chandra Shekar]

Hello Paul,

Am trying to run excel from task scheduler which as macro in it here I need
to run task scheduler from 10:00 AM  - 6:00 PM(except weekends)

At present I have scheduled it from task scheduler and its working fine
what I need is it should run from 10:00 AM - 6:00 PM only.


Regards,

Chandrashekar B

On Wed, Oct 21, 2015 at 4:48 PM, Paul Schreiner 
wrote:

> Yes there are.
> Without knowing what it is you are trying to do, it's a little difficult
> to describe.
>
> Have you already created a Scheduled Task in the Scheduler?
>
> What is the name of the program you're running?
>
> The first step is to use a text editor (like NotePad)
> to create a .bat file with the entry like I described previously:
>
> TestTask.bat:
> -
> schtasks /delete /tn "Release ADTL"  /f
> schtasks /create /tn "Release ADTL"
>  /tr "C:\WINNT\system32\wscript.exe c:\temp\Release-ADTL.vbs ALL"
>  /sc hourly
>  /st 8:00:00
>
> (yours will be different)
>
> Run that .bat file and see if it creates the Scheduled Task correctly.
>
> Once you have this .bat file working properly, then we can work on writing
> the VBA that creates and runs this bat file.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, October 20, 2015 11:49 PM
>
> *Subject:* Re: $$Excel-Macros$$ Task Scheduler
>
> Hello,
>
> Okay. Is there steps to do it?
>
>
> Regards,
>
> Chandru
>
>
>
> On Tue, Oct 20, 2015 at 5:13 PM, Paul Schreiner 
> wrote:
>
> It's the same Task Scheduler.
>
> Basically, the Operating System has an application that handles scheduled
> tasks.
>
> Windows has an application that serves as an INTERFACE to the task handler.
>
> There is a CMD interface called schtasks that also serves as an interface
> to the same task handler.
>
> If you use a .bat file and schtasks as described below,
> it will make an entry that you can view and modify in the Windows Task
> Scheduler.
>
> So, you can use VBA to create and run a .bat file that can make or change
> entries to the Task Scheduler.
>
>
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, October 20, 2015 2:55 AM
> *Subject:* Re: $$Excel-Macros$$ Task Scheduler
>
> Hi,
>
> Need to schedule through WIndows Task Scheduler.
> Control Panel\All Control Panel Items\Administrative Tools\Task Scheduler
>
>
> Regards,
>
> Chandru
>
>
>
> On Mon, Oct 19, 2015 at 4:18 PM, Paul Schreiner 
> wrote:
>
> Are you saying that you want VBA to schedule a task?
>
> In the past, I created a userform in Excel to create a Scheduled Task.
> (Our Windows Profile had the task Scheduler locked out)
>
> The VBA macro made use of the "command line" for creating scheduled tasks:
> schtasks /create /tn 
>  /tr 
>  /sc weekly [/mo {1 - 52}]
> [/d {[,MON - SUN...] | *}]
> [/st ]
> [/sd ]
> [/ed ]
> [/it]
> [/ru {[\]
> [/rp ] | System}]
> [/s 
> [/u [\]
> [/p ]]]
>
> for instance, I have a vbscript that runs hourly to check for files in a
> specific folder to move to a "released" folder.
>
> schtasks /delete /tn "Release ADTL"  /f
> schtasks /create /tn "Release ADTL"
>  /tr "C:\WINNT\system32\wscript.exe c:\temp\Release-ADTL.vbs ALL"
>  /sc hourly
>  /st 8:00:00
>
> In my VBA, I create the schtasks command line and write it to a .bat file
> (I called it C:\temp\create_task.bat)
>
> Then, I used:
> stat = Shell("C:\temp\create_task.bat") to execute the .bat file.
>
> I think to stop your program at a specific time you could use:
>
> schtasks /end 
>
> I

$$Excel-Macros$$ Read Only erro

[Chandra Shekar]

Hello,

Am running excel(Macro Based) in server but its always getting Read only
error even nobody is using that file. Could you please let me know what is
the issue in it or need to change some setting in server.


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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Read Only erro

[Chandra Shekar]

Hi Paul,

Yes I have write permission to the folder.


Regards,

Chandru

On Thu, Oct 29, 2015 at 8:59 PM, Paul Schreiner 
wrote:

> Do you have write permission to the folder on the server?
> (try to create a new file in the folder)
>
> If you do not have write permission to the folder, any file opened will be
> read-only.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, October 29, 2015 8:09 AM
> *Subject:* $$Excel-Macros$$ Read Only erro
>
> Hello,
>
> Am running excel(Macro Based) in server but its always getting Read only
> error even nobody is using that file. Could you please let me know what is
> the issue in it or need to change some setting in server.
>
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Read Only erro

[Chandra Shekar]

Hello,

Macro file works fine in local PC but same file is not working in the
server. First time its open and I can able to run the macro if I try to run
open excel second time it gives read only error.(am using workbook open
event in the excel)


Regards,

Chandru

On Fri, Oct 30, 2015 at 4:16 PM, Paul Schreiner 
wrote:

> ok, now we're back to needing more information.
>
> You said:
> "Am running excel(Macro Based) in server but its always getting Read only
> error even nobody is using that file. "
>
> I noticed that you said that you get the error when you're RUNNING the
> macro, not when you open the file.
>
> The Excel workbook can be Read-Only, but that doesn't stop you from
> running a macro, nor should it cause an error.
>
> So, WHEN does the read-only error occur?
> What line of the macro?
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, October 29, 2015 11:45 PM
> *Subject:* Re: $$Excel-Macros$$ Read Only erro
>
> Hi Paul,
>
> Yes I have write permission to the folder.
>
>
> Regards,
>
> Chandru
>
>
>
> On Thu, Oct 29, 2015 at 8:59 PM, Paul Schreiner 
> wrote:
>
> Do you have write permission to the folder on the server?
> (try to create a new file in the folder)
>
> If you do not have write permission to the folder, any file opened will be
> read-only.
>
> *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:* Chandra Shekar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, October 29, 2015 8:09 AM
> *Subject:* $$Excel-Macros$$ Read Only erro
>
> Hello,
>
> Am running excel(Macro Based) in server but its always getting Read only
> error even nobody is using that file. Could you please let me know what is
> the issue in it or need to change some setting in server.
>
>
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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.
> 

Re: $$Excel-Macros$$ Read Only erro

[Chandra Shekar]

Hi Paul,

i checked the google many arr facing the issue & its not yet solved till
now.


Regards,
Chandru

On Friday, October 30, 2015, Paul Schreiner  wrote:

> OK:
> I understand that it "works fine" on the local PC.
>
> I'm assuming that means that you can:
> 1) Open the workbook.
> 2) Run the macro
> 3) Close the workbook.
> Repeat
>
> But when you move the workbook to the server, you can:
> 1) Open the workbook
> 2) Run the macro
> 3) Close the workbook
>
> But when you try to "repeat" step 1) (open the workbook)
> it gives you warning of some kind.
>
> What is the warning?
>
> A "Read-Only" warning doesn't have anything to do with the Workbook_Open
> event macro.
>
> It happens before the event handler is activated.
>
> Can you send me a screen shot of your warning message?
>
>
> *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:* Chandra Shekar  >
> *To:* excel-macros@googlegroups.com
> 
> *Sent:* Friday, October 30, 2015 7:18 AM
> *Subject:* Re: $$Excel-Macros$$ Read Only erro
>
> Hello,
>
> Macro file works fine in local PC but same file is not working in the
> server. First time its open and I can able to run the macro if I try to run
> open excel second time it gives read only error.(am using workbook open
> event in the excel)
>
>
> Regards,
>
> Chandru
>
>
>
> On Fri, Oct 30, 2015 at 4:16 PM, Paul Schreiner  > wrote:
>
> ok, now we're back to needing more information.
>
> You said:
> "Am running excel(Macro Based) in server but its always getting Read only
> error even nobody is using that file. "
>
> I noticed that you said that you get the error when you're RUNNING the
> macro, not when you open the file.
>
> The Excel workbook can be Read-Only, but that doesn't stop you from
> running a macro, nor should it cause an error.
>
> So, WHEN does the read-only error occur?
> What line of the macro?
>
> *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:* Chandra Shekar  >
> *To:* excel-macros@googlegroups.com
> 
> *Sent:* Thursday, October 29, 2015 11:45 PM
> *Subject:* Re: $$Excel-Macros$$ Read Only erro
>
> Hi Paul,
>
> Yes I have write permission to the folder.
>
>
> Regards,
>
> Chandru
>
>
>
> On Thu, Oct 29, 2015 at 8:59 PM, Paul Schreiner  > wrote:
>
> Do you have write permission to the folder on the server?
> (try to create a new file in the folder)
>
> If you do not have write permission to the folder, any file opened will be
> read-only.
>
> *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:* Chandra Shekar  >
> *To:* excel-macros@googlegroups.com
> 
> *Sent:* Thursday, October 29, 2015 8:09 AM
> *Subject:* $$Excel-Macros$$ Read Only erro
>
> Hello,
>
> Am running excel(Macro Based) in server but its always getting Read only
> error even nobody is using that file. Could you please let me know what is
> the issue in it or need to change some setting in server.
>
>
> 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.
&

Re: $$Excel-Macros$$ Running Macro from Task Scheduler

[Chandra Shekar]

Hi,

Its confidential document cannot able to share it can you please let me
know solution for it.

Thanks in advance.


Regards,

Chandru

On Tue, Nov 3, 2015 at 12:35 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:

> send the file will change it and send it back​
>
> On Tue, Nov 3, 2015 at 12:22 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Am trying to run macro from task scheduler which will send mails from
>> outlook but its working fine when I run it manually but if I schedule it
>> from task scheduler its giving error(pls find attach for error).
>>
>> Could you please help me on this.
>>
>> Thanks in advance.
>>
>>
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
>
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
> Ph : 9343 666 888
>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Running Macro from Task Scheduler

[Chandra Shekar]

Hi,

PFA report and am getting this error only while running from TASK SCHEDULER.


Regards,

Chandru

On Tue, Nov 3, 2015 at 2:14 PM, Chandra Shekar  wrote:

> Hi,
>
> Its confidential document cannot able to share it can you please let me
> know solution for it.
>
> Thanks in advance.
>
>
> Regards,
>
> Chandru
>
> On Tue, Nov 3, 2015 at 12:35 PM, yogananda muthaiah <
> yogananda.mutha...@gmail.com> wrote:
>
>> send the file will change it and send it back​
>>
>> On Tue, Nov 3, 2015 at 12:22 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> Am trying to run macro from task scheduler which will send mails from
>>> outlook but its working fine when I run it manually but if I schedule it
>>> from task scheduler its giving error(pls find attach for error).
>>>
>>> Could you please help me on this.
>>>
>>> Thanks in advance.
>>>
>>>
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>>
>>
>>
>> Regards
>> Yogananda Muthaiah
>> Ph : 973 123 7267
>> Ph : 9343 666 888
>>
>> --
>> 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.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.


Mail_issue.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Running Macro from Task Scheduler

[Chandra Shekar]

Hi All,

Issue got resolved as its a security issue.


Regards,

Chandru

On Wed, Nov 4, 2015 at 9:11 AM, sahemur khan  wrote:

> Dear Sir,
>
>make changes in your macro as per below mention in blue
>
> Set OutApp = CreateObject("Outlook.Application.14") TO *Set OutApp =
>> CreateObject("Outlook.Application") *
>>
> --
> 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.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Moving mail within Gmail Account

[Chandra Shekar]

Hello,

I have created new gmail now I need to move old gmail account to new gmail
account.

Is there any way to do this?


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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Automating from Word

[Chandra Shekar]

Hello,

I need a code in word where it opens excel document and paste graphs in a
particular postion.

Is there any way to do it and also need a book where it as multiple
examples like this.


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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Fwd: Moving mail within Gmail Account

[Chandra Shekar]

Hello Team,

Any help on this?


Regards,

Chandru
-- Forwarded message --
From: Chandra Shekar 
Date: Fri, Nov 20, 2015 at 10:32 AM
Subject: Moving mail within Gmail Account
To: excel-macros@googlegroups.com


Hello,

I have created new gmail now I need to move old gmail account to new gmail
account.

Is there any way to do this?


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.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Pivot Sorting

[Chandra Shekar]

Hello,

Could you please help in sorting pivot based on month?

Thanks in advance

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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot_Sorting.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Object Hyperlin : Deletion

[Chandra Shekar]

Hello,

Could you please let me know how to remove hyperlinks linked to graphical
objects (Its nearly 1000 objects)

Thanks in advance.

Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

[Chandra Shekar]

Hello,

Thanks for the reply. I have nearly 1000 graphical object in the work
sheet. Macro is taking lot of time to get run some times it hangs also. I
have a good processor & ram speed.

Could you please suggest on this.

Thanks in advance.

Regards,

Chandra Shekar B

On Fri, Mar 2, 2012 at 3:34 PM, NOORAIN ANSARI wrote:

> Dear Chandra,
>
> You can also use..
>
> Sub test()
> Dim sh As Shape
> For Each sh In ActiveSheet.Shapes
> On Error Resume Next
> sh.Hyperlink.Delete
> Next
> End Sub
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
>  On Fri, Mar 2, 2012 at 5:10 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Chandra,
>>
>> Please check it
>>
>>
>> http://www.bigresource.com/VB-remove-hyperlinks-from-graphical-objects-in-excel-sv9vpXaqEN.html#APhFEcBxqn
>>
>>
>> On Fri, Mar 2, 2012 at 4:56 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> Could you please let me know how to remove hyperlinks linked to
>>> graphical objects (Its nearly 1000 objects)
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>>
>>> Chandra Shekar B
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Pivot Issue

[Chandra Shekar]

Hello,

I get errro as *Unable to get the pivottables property of the worksheet
class *in the below code. could you assist me on this code.

Thanks in advance.

Sub RefreshPivotTables()
Worksheets("OBC").Activate
Application.DisplayAlerts = False
*ActiveSheet.PivotTables("BP").PivotCache.Refresh
*Application.DisplayAlerts = True
End Sub


Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot Issue

[Chandra Shekar]

Hello Rajan,

Yes Pivot name is correct.

Regards,

Chandra Shekar B

On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma wrote:

>  Is pivot name “BP” correct?
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Mar/Tue/2012 04:57
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Pivot Issue
>
> ** **
>
> Hello,
>
> I get errro as *Unable to get the pivottables property of the worksheet
> class *in the below code. could you assist me on this code.
>
> Thanks in advance.
>
> Sub RefreshPivotTables()
> Worksheets("OBC").Activate
> Application.DisplayAlerts = False
> *ActiveSheet.PivotTables("BP").PivotCache.Refresh
> *Application.DisplayAlerts = True
> End Sub 
>
>  
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot Issue

[Chandra Shekar]

Hello,

Please let me know is there any soultion for this kind of issues.
Regards,

Chandra Shekar B
On Tue, Mar 6, 2012 at 1:58 PM, Chandra Shekar  wrote:

> Hello Rajan,
>
> Yes Pivot name is correct.
>
> Regards,
>
> Chandra Shekar B
>
>  On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma wrote:
>
>>  Is pivot name “BP” correct?
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* Mar/Tue/2012 04:57
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Pivot Issue
>>
>> ** **
>>
>> Hello,
>>
>> I get errro as *Unable to get the pivottables property of the worksheet
>> class *in the below code. could you assist me on this code.
>>
>> Thanks in advance.
>>
>> Sub RefreshPivotTables()
>> Worksheets("OBC").Activate
>> Application.DisplayAlerts = False
>> *ActiveSheet.PivotTables("BP").PivotCache.Refresh
>> *Application.DisplayAlerts = True
>> End Sub 
>>
>>  
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Multi Combo Box

[Chandra Shekar]

Hello,

I would like to have multi combo box on every row (1000 rows). Could you
please help me out on this.

Thanks in advance.

Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Combobox.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Multi Combo Box

[Chandra Shekar]

Hello,

Could you please help me on the attached file. Thanks in advance.

Regards,

Chandra Shekar B

On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma wrote:

>  *HI Chandru,*
>
> * *
>
> *File size will be very larege with 1000 controlls on worksheet.. I
> suggest to use List Validation on each cell in your range*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 01 May 2012 18:53
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Multi Combo Box
>
> ** **
>
> Hello,
>
>  
>
> I would like to have multi combo box on every row (1000 rows). Could you
> please help me out on this.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


List.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Multi Combo Box

[Chandra Shekar]

Hello,

Thanks all.

Regards,

Chandra Shekar B

On Wed, May 2, 2012 at 6:56 PM, Bé Trần Văn wrote:

>
>
> 2012/5/2 Rajan_Verma 
>
>>  Hi Chandru
>>
>> Please find the attached sheet, you can use list validation for that..***
>> *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* 02 May 2012 13:13
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Multi Combo Box
>>
>> ** **
>>
>> Hello,
>>
>>  
>>
>> Could you please help me on the attached file. Thanks in advance.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma 
>> wrote:
>>
>> *HI Chandru,*
>>
>> * *
>>
>> *File size will be very larege with 1000 controlls on worksheet.. I
>> suggest to use List Validation on each cell in your range*
>>
>> * *
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* 01 May 2012 18:53
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Multi Combo Box
>>
>>  
>>
>> Hello,
>>
>>  
>>
>> I would like to have multi combo box on every row (1000 rows). Could you
>> please help me out on this.
>>
>>  
>>
>> Thanks in advance.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, fo

$$Excel-Macros$$ Top Three

[Chandra Shekar]

Hello,

Could you please help me in the formula. Please find attached file.

Thanks in advacne.

Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Topthree.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Top Three

[Chandra Shekar]

Hello,

Thank you very much.

On Tue, May 15, 2012 at 4:14 PM, Krishna Kumar wrote:

> Hi
>
> In G1: 3
>
> In H2 and copied down,
>
> =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"")
>
> In I2 and copied down,
>
>
> =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1),COUNTIF($H$2:H2,H2))),"")
>
> It's an array formula. Confirmed with CTRL + SHIFT + ENTER
>
> Kris
> ExcelFox 
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Date

[Chandra Shekar]

Hello,

Can you please help me with attached excel.

Thanks in advance.

Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Date

[Chandra Shekar]

Hello,

Thanks all for your reply. Formula is not working if we have difference in
date. Please find attached excel for the same.

Thanks in advance.

Regards,

Chandra Shekar B




On Tue, Jun 12, 2012 at 5:15 PM, ankur  wrote:

> Dear Chandra,
> Try this one
>
>
>
>
>
>
> DATEDIF(A2,B2,"d")  for Formula1(Days)
>
> TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)
>
> CONCATENATE(C2," Days ",HOUR(D2)," Hr ",MINUTE(D2)," Mins ",SECOND(D2),"
> Sec")  for Formula3
>
> Regards:
> CMA Ankur Pandey
>
>
>
>
>
>
> On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Chandra,
>>
>> Please see attached sheet.
>>
>>
>> On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> Can you please help me with attached excel.
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>>
>>> Chandra Shekar B
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. 

Re: Re: $$Excel-Macros$$ Date

[Chandra Shekar]

Hello Ankur,

Can you please send solved excel file.

Thanks,

Chandra Shekar B

On Wed, Jun 13, 2012 at 5:51 PM,  wrote:

> hi chandra
>
> try this
>
> TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)
>
>  On , Chandra Shekar  wrote:
> > Hello,
> >
> >
> >
> > Thanks all for your reply. Formula is not working if we have difference
> in date. Please find attached excel for the same.
> >
> >
> >
> > Thanks in advance.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Chandra Shekar B
> >
> >
> >
> >
> >
> >
> >
> > On Tue, Jun 12, 2012 at 5:15 PM, ankur ankurpande...@gmail.com> wrote:
> >
> > Dear Chandra,
> > Try this one
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > DATEDIF(A2,B2,"d")  for Formula1(Days)
> >
> > TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)
> >
> > CONCATENATE(C2," Days ",HOUR(D2)," Hr ",MINUTE(D2)," Mins ",SECOND(D2),"
> Sec")  for Formula3
> >
> > Regards:
> > CMA Ankur Pandey
> >
> >
> >
> >
> >
> >
> >
> >
> > On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI noorain.ans...@gmail.com>
> wrote:
> >
> > Dear Chandra,
> >
> > Please see attached sheet.
> >
> >
> >
> >
> > On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar
> chandrashekarb@gmail.com> wrote:
> >
> >
> > Hello,
> >
> >
> >
> > Can you please help me with attached excel.
> >
> >
> >
> > Thanks in advance.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Chandra Shekar B
> >
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> >
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> >
> > To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> >
> > --
> >
> > Thanks & regards,
> > Noorain Ansari
> > www.noorainansari.com
> > www.excelmacroworld.blogspot.com
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> >
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> >
> > To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> >
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

$$Excel-Macros$$ Refreshing Pivot Table using VBA Code

[Chandra Shekar]

Hi,

In sheet1 I have 5 pivot table and source in sheet2. Here I need macro which
refresh pivot table when I paste new data.

Thanks in Advance.

Regards,

Chandra Shekar B
9845976015

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Refreshing Pivot Table using VBA Code

[Chandra Shekar]

Hi Daniel,

Thank you very much. :)

Regards,

Chandra Shekar B

On Wed, Apr 27, 2011 at 8:37 PM, Daniel  wrote:

>  Hi,
>
> Paste the following macro in Sheet1 module :
>
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> 'A1:F10 is data for pivot table 1 G1:I10 is data for pivot table 2...
>
> If Not Intersect(Target, Union([A1:F10], [G1:I10])) Is Nothing Then
>
> ThisWorkbook.RefreshAll
>
> End If
>
> End Sub
>
>
>
> Regards.
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Chandra Shekar
> *Envoyé :* mercredi 27 avril 2011 11:31
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Refreshing Pivot Table using VBA Code
>
>
>
> Hi,
>
>
>
> In sheet1 I have 5 pivot table and source in sheet2. Here I need macro
> which refresh pivot table when I paste new data.
>
>
>
> Thanks in Advance.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> 9845976015
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ MinMaxAverage : Using Sumproduct

[Chandra Shekar]

Hi,

I want Min Max and Average by using Sumproduct. My problem is I want a
formula which should be based on Date and Title as shown on Column D, E & F
and based on Column C I need Average, Min & Max Values. If I confusing pls
let me know.

Thanks

Chandra Shekar B

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


MinMaxAverage_Sumproduct.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

[Chandra Shekar]

Hi Asish,

Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
& AVG for first record should be 100, 50 & avergage should be 87.5.

Can we use sumproduct for all the formulas instead of array formulas. Thanks
in advanc.

Regards,

Chandra Shekar B

On Mon, May 16, 2011 at 9:15 PM, ashish koul  wrote:

> try this
>
>
> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I want Min Max and Average by using Sumproduct. My problem is I want a
>> formula which should be based on Date and Title as shown on Column D, E & F
>> and based on Column C I need Average, Min & Max Values. If I confusing pls
>> let me know.
>>
>> Thanks
>>
>> Chandra Shekar B
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

[Chandra Shekar]

Hi Ashish,

Please find attached file.

Thanks,

Chanra Shekar B

On Tue, May 17, 2011 at 6:09 PM, ashish koul  wrote:

> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi Asish,
>>
>> Thanks for your reply, but I did'nt get the desired result i.e. in MAX,
>> MIN & AVG for first record should be 100, 50 & avergage should be 87.5.
>>
>> Can we use sumproduct for all the formulas instead of array formulas.
>> Thanks in advanc.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> On Mon, May 16, 2011 at 9:15 PM, ashish koul wrote:
>>
>>> try this
>>>
>>>
>>> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I want Min Max and Average by using Sumproduct. My problem is I want a
>>>> formula which should be based on Date and Title as shown on Column D, E & F
>>>> and based on Column C I need Average, Min & Max Values. If I confusing pls
>>>> let me know.
>>>>
>>>> Thanks
>>>>
>>>> Chandra Shekar B
>>>>
>>>> --
>>>>
>>>> --
>>>> 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
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

[Chandra Shekar]

Hi,

Thanks for the reply. Can we do this without using array function.

Regards,

Chandra Shekar B

On Thu, May 19, 2011 at 11:16 AM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

>  HI Chandra,
>
>
>
> See if it helps…
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, May 18, 2011 7:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
>
>
>
> Hi Asish,
>
>
>
> Please reply to the mail. :)
>
>
>
> I have attached both the files for your information.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> On Tue, May 17, 2011 at 7:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi Ashish,
>
>
>
> Please find attached file.
>
>
>
> Thanks,
>
>
>
> Chanra Shekar B
>
> On Tue, May 17, 2011 at 6:09 PM, ashish koul 
> wrote:
>
> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi Asish,
>
>
>
> Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
> & AVG for first record should be 100, 50 & avergage should be 87.5.
>
>
>
> Can we use sumproduct for all the formulas instead of array formulas.
> Thanks in advanc.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> On Mon, May 16, 2011 at 9:15 PM, ashish koul 
> wrote:
>
> try this
>
>
>
> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi,
>
>
>
> I want Min Max and Average by using Sumproduct. My problem is I want a
> formula which should be based on Date and Title as shown on Column D, E & F
> and based on Column C I need Average, Min & Max Values. If I confusing pls
> let me know.
>
>
>
> Thanks
>
>
>
> Chandra Shekar B
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
>
> P Before printing, think about the environment.
>
>
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> 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.

$$Excel-Macros$$ Recovering corrupted excel file

[Chandra Shekar]

Hi,

Is there any way to recover corrupted excel file.

Thanks,

Chandra Shekar B

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

[Chandra Shekar]

Hi,

You are using array formula
i.e.=MIN(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;""
&
=AVERAGE(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;"".

Is there any way to do this without using array formula.

Thanks,

Chandra Shekar B


On Fri, May 20, 2011 at 2:24 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

>  There is no array used..
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Thursday, May 19, 2011 7:25 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
>
>
>
> Hi,
>
>
>
> Thanks for the reply. Can we do this without using array function.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> On Thu, May 19, 2011 at 11:16 AM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
> HI Chandra,
>
>
>
> See if it helps…
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, May 18, 2011 7:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
>
>
>
> Hi Asish,
>
>
>
> Please reply to the mail. :)
>
>
>
> I have attached both the files for your information.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> On Tue, May 17, 2011 at 7:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi Ashish,
>
>
>
> Please find attached file.
>
>
>
> Thanks,
>
>
>
> Chanra Shekar B
>
> On Tue, May 17, 2011 at 6:09 PM, ashish koul 
> wrote:
>
> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi Asish,
>
>
>
> Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
> & AVG for first record should be 100, 50 & avergage should be 87.5.
>
>
>
> Can we use sumproduct for all the formulas instead of array formulas.
> Thanks in advanc.
>
>
>
> Regards,
>
>
>
> Chandra Shekar B
>
> On Mon, May 16, 2011 at 9:15 PM, ashish koul 
> wrote:
>
> try this
>
>
>
> On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi,
>
>
>
> I want Min Max and Average by using Sumproduct. My problem is I want a
> formula which should be based on Date and Title as shown on Column D, E & F
> and based on Column C I need Average, Min & Max Values. If I confusing pls
> let me know.
>
>
>
> Thanks
>
>
>
> Chandra Shekar B
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
>
> P Before printing, think about the environment.
>
>
>
>
>
> --
>
> --
> 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.blo

Re: $$Excel-Macros$$ Recovering corrupted excel file

[Chandra Shekar]

Hi can u expalin briefly in steps.

Thanks,

Chandra Shekar B

On Fri, May 20, 2011 at 5:02 PM, rajan verma wrote:

> Use a Function Like this
>
> ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1
>
>
>
> On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Is there any way to recover corrupted excel file.
>>
>> Thanks,
>>
>> Chandra Shekar B
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Recovering corrupted excel file

[Chandra Shekar]

Hi,

This I tried but still I could not able to recover the file. Let me know is
there any other way to recover file.

Thanks,

Chandra Shekar B

On Sat, May 21, 2011 at 10:11 AM, ashish koul  wrote:

>
> http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx
>
>
>
>
>
> On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi can u expalin briefly in steps.
>>
>> Thanks,
>>
>> Chandra Shekar B
>>
>> On Fri, May 20, 2011 at 5:02 PM, rajan verma wrote:
>>
>>> Use a Function Like this
>>>
>>> ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1
>>>
>>>
>>>
>>> On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> Is there any way to recover corrupted excel file.
>>>>
>>>> Thanks,
>>>>
>>>> Chandra Shekar B
>>>>
>>>> --
>>>>
>>>> --
>>>> 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
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Regards
>>> Rajan verma
>>> +91 9158998701
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Recovering corrupted excel file

[Chandra Shekar]

Hi,

Its a confidential file. I cannot send the file. Please let me know if there
a way to recover the file.

Regards,

Chandra Shekar B

On Tue, May 24, 2011 at 2:35 PM, Rajan_Verma wrote:

>  Send your File..
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Monday, May 23, 2011 11:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Recovering corrupted excel file
>
>
>
> Hi,
>
>
>
> This I tried but still I could not able to recover the file. Let me know is
> there any other way to recover file.
>
>
>
> Thanks,
>
>
>
> Chandra Shekar B
>
> On Sat, May 21, 2011 at 10:11 AM, ashish koul 
> wrote:
>
>
> http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx
>
>
>
>
>
>  On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi can u expalin briefly in steps.
>
>
>
> Thanks,
>
>
>
> Chandra Shekar B
>
> On Fri, May 20, 2011 at 5:02 PM, rajan verma 
> wrote:
>
> Use a Function Like this
>
>
>
> ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1
>
>
>
>
>
> On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
> Hi,
>
>
>
> Is there any way to recover corrupted excel file.
>
>
>
> Thanks,
>
>
>
> Chandra Shekar B
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
>
> P Before printing, think about the environment.
>
>
>
>
>
> --
>
> --
> 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 @ h

$$Excel-Macros$$ Pivot Items

[Chandra Shekar]

Hi,

How to extract data from a pivot item. In the example I need pivot items(1)
data in the same worksheet. Thanks!

With pvt_tbl
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
End With

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pivot Items

[Chandra Shekar]

Hi,

Any help regarding this. Thanks!!!.

Regards,

Chandra Shekar B

On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> How to extract data from a pivot item. In the example I need pivot items(1)
> data in the same worksheet. Thanks!
>
> With pvt_tbl
> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
> End With
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pivot Items

[Chandra Shekar]

Hi Asish,

Please find attached excel file. I have given instruction in the macro
itself. Thanks!

Regards,

Chandra Shekar B

On Wed, May 25, 2011 at 4:02 PM, ashish koul  wrote:

> can you attch the worksheet
>
> On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Any help regarding this. Thanks!!!.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>>   On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> How to extract data from a pivot item. In the example I need pivot
>>> items(1) data in the same worksheet. Thanks!
>>>
>>> With pvt_tbl
>>> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
>>> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
>>> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
>>> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
>>> End With
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Pivot table_Query.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Pivot Items

[Chandra Shekar]

Hi Ashish,

Thank you for your reply. I am not getting desired ouput i.e. in ur macro I
am getting grade 3 employee count, but I need full details of that grade 3
employees. I need result such that if we double click on pivot item 3 we get
those records in a new sheet. just like that I want the result.

Regards,

Chandra Shekar B



On Wed, May 25, 2011 at 7:39 PM, ashish koul  wrote:

>
> Sub filter_pivot()
>
>
> Application.ScreenUpdating = False
> Application.EnableEvents = False
>
> Dim pi1 As PivotItem
> For Each pi1 In
> Sheets(2).PivotTables("PivotTable1").PivotFields("Grade").PivotItems
> If pi1.Value = 3 Then
> pi1.Visible = True
>
>   Else
>   On Error Resume Next
>  pi1.Visible = False
> End If
>Next pi1
> Application.ScreenUpdating = True
> Application.EnableEvents = True
> End Sub
>
>
>
>
>
> On Wed, May 25, 2011 at 4:45 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi Asish,
>>
>> Please find attached excel file. I have given instruction in the macro
>> itself. Thanks!
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> On Wed, May 25, 2011 at 4:02 PM, ashish koul wrote:
>>
>>> can you attch the worksheet
>>>
>>> On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> Any help regarding this. Thanks!!!.
>>>>
>>>> Regards,
>>>>
>>>> Chandra Shekar B
>>>>
>>>>   On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
>>>> chandrashekarb@gmail.com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> How to extract data from a pivot item. In the example I need pivot
>>>>> items(1) data in the same worksheet. Thanks!
>>>>>
>>>>> With pvt_tbl
>>>>> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
>>>>> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
>>>>> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
>>>>> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
>>>>> End With
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> 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
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> 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
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com <http://akoul.blogsp