$$Excel-Macros$$ TIIPS - Best BA LLB, BA (JMC), B.Tech, BBA, BCA Institute in Delhi NCR - Greater Noida

[Rohan Kumar]

Best Computer Science Engineering, Electronics and Communication 
Engineering, Information Technology, BA LLB, BJMC, BBA, BCA Institute in 
Delhi NCR


CONTACT

 

Name: TIIPS

 

Contact No.: +91 120 232 3123

 

Email:i...@trinity.com

 

Website: https://www.tiips.ac.in/



Best Computer Science Engineering College in Delhi NCR

Electronics and Communication Engineering Institute
Best Institute of Information Technology in Greater Noida

BA LLB Institute in Delhi NCR Affiliated to GGSIPU

Best BJMC College in Delhi NCR

Best BBA Institute in Delhi NCR

Best BCA Institute in Delhi NCR - BCA College in Greater Noida

 



Students from all around the world are seeking admissions into their 
preferred courses. Things turn sour when they don’t find a suitable 
institution to study the same. With gaining proficiency in a particular 
subject, one can open a lot of opportunities and keeps on growing day after 
day. If you want to take admission in courses like B.Tech; B.A. LLB; BA 
(JMC); B.B.A; and B.C.A., then it is important to have a brief knowledge 
about them. It will surely help you understand the subject according to 
which you can make your decision to get admission into it.

 

 



Website: https://www.tiips.ac.in

 

https://www.tiips.ac.in/programs/electronics-and-communication-engineering

 

https://www.tiips.ac.in/programs/information-technology

 

https://www.tiips.ac.in/programs/ba-llb

 

https://www.tiips.ac.in/programs/bjmc

 

https://www.tiips.ac.in/programs/bba

 

https://www.tiips.ac.in/programs/bca

 

 

 

 

 
Name: TIIPS

 

Contact No.: +91 120 232 3123

 

Email:i...@trinity.com

 

Website: https://www.tiips.ac.in/

 

 

 

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/61dadca3-e430-4d67-8180-1cc81f0b0ab6%40googlegroups.com.

Re: $$Excel-Macros$$ Getting syntax error for a basic vba code

[Rohan Kapuria]

Thanks Paul...I guess that must have been the issue... I had copy pasted 
this code in the vba editor from a pdf...when I erased it and typed it 
myself the errors went away...

Thanks for the reply!


On Friday, 25 July 2014 00:07:40 UTC+5:30, Paul Schreiner wrote:
>
>  It looks like the code you copied was modified by an editor.
> Some editors use what is called "smart quotes"
>  
> The instead of simple double-quotes (") they use
> an "opening quote" (“)
> and a "closing quote" (”)
>  
> so your quoted string looks like:
> “Is your name ”
>  
> These quote are not allowed in VBA.
>  
> simply change them to (") and you should be fine.
> Sub GuessName()
> Msg = "Is your name " & Application.UserName & "?"
> Ans = MsgBox(Msg, vbYesNo)
> If Ans = vbNo Then MsgBox "Oh, never mind."
> If Ans = vbYes Then MsgBox "I must be psychic!"
> 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*
> -
>
>*From:* Rohan Kapuria >
> *To:* excel-...@googlegroups.com  
> *Sent:* Thursday, July 24, 2014 1:05 PM
> *Subject:* $$Excel-Macros$$ Getting syntax error for a basic vba code
>  
> Hi all,
>
> I am new to excel VBA and I copied this peace of code from excel vba for 
> dummies and i am getting a compile error (syntax error)
> The option to declare variables explicitly is off.
>
> Error statements marked in RED
>
> Need help!
>
> Sub GuessName()
> Msg = “Is your name “ & Application.UserName & “?”
> Ans = MsgBox(Msg, vbYesNo)
> If Ans = vbNo Then MsgBox “Oh, never mind.”
> If Ans = vbYes Then MsgBox “I must be psychic!”
> End Sub
>
> -- 
> 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...@googlegroups.com .
> To post to this group, send email to excel-...@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$$ Getting syntax error for a basic vba code

[Rohan Kapuria]

Hi all,

I am new to excel VBA and I copied this peace of code from excel vba for 
dummies and i am getting a compile error (syntax error)
The option to declare variables explicitly is off.

Error statements marked in RED

Need help!

Sub GuessName()
Msg = “Is your name “ & Application.UserName & “?”
Ans = MsgBox(Msg, vbYesNo)
If Ans = vbNo Then MsgBox “Oh, never mind.”
If Ans = vbYes Then MsgBox “I must be psychic!”
End Sub

-- 
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$$ US$ currency Format

[Rohan Young]

*Hi Experts*

* how do get US$ currency format from 1234567 to 1,234,567*

thanks

-- 
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$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi  wrote:

> ActiveSheet.Range("G" & j).Value = strFile


ITS DONE now, Gr8 dear, excellent

thanks alot bro, very-2 thanks to 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.

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

thanks a lot bro, this is awesome and that's i need

very-2 thanks bro


On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi  wrote:

> PFA
>
> You need to customize send key letters to get desired output.
>
> Cheers!!
>
>
> On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young  wrote:
>
>> its already set on both side printing by default but when i am taking
>> print through that its coming on one side printing
>>
>>
>> On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi  wrote:
>>
>>> You need to set duplex printing option as default before printing..
>>>
>>>
>>> On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young 
>>> wrote:
>>>
>>>> one more thing if you can add on this that is both side printing coz
>>>> our organization preferred that or excel could take own-self the setting of
>>>> both side printing as default
>>>>
>>>> thanks
>>>>
>>>>
>>>> On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young 
>>>> wrote:
>>>>
>>>>> please also solve my query of folders of mails logbook
>>>>>
>>>>> regds
>>>>>
>>>>>
>>>>> On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young 
>>>>> wrote:
>>>>>
>>>>>> thanks a lot bro
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi  wrote:
>>>>>>
>>>>>>> PFA
>>>>>>>
>>>>>>> Cheers!!
>>>>>>> .*show(Time)*
>>>>>>>
>>>>>>>
>>>>>>> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> no bro,
>>>>>>>>
>>>>>>>> i want Repeat Top row should come in print on every individual
>>>>>>>> sheet's first 6 pages. from page 7 i dont need Repeat Top Row in 
>>>>>>>> prints it
>>>>>>>> should come in print without Repeat Top Rows in remaining pages. Same 
>>>>>>>> is
>>>>>>>> for rest of the sheets.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>>
>>>>>>>> On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:
>>>>>>>>
>>>>>>>>> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1
>>>>>>>>> on all pages of sheet 1,2,3 etc..
>>>>>>>>>
>>>>>>>>> it it correct??
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young >>>>>>>> > wrote:
>>>>>>>>>
>>>>>>>>>> hi,
>>>>>>>>>>
>>>>>>>>>> i am talking about the "Repeat Top Rows" not header or footer
>>>>>>>>>>
>>>>>>>>>> thanks
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi 
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Check this link.:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>>>>>>>>>
>>>>>>>>>>> Cheers
>>>>>>>>>>> On Jun 11, 2014 9:39 PM, "Rohan Young" 
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young <
>>>>>>>>>>>> rohan.j...@gmail.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Dear Group,
>>>>>>>>>>>>>
>>>>>>>>>>>>> I need to repeat header rows in prints in specific sheets
>>>&

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

its already set on both side printing by default but when i am taking print
through that its coming on one side printing


On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi  wrote:

> You need to set duplex printing option as default before printing..
>
>
> On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young  wrote:
>
>> one more thing if you can add on this that is both side printing coz our
>> organization preferred that or excel could take own-self the setting of
>> both side printing as default
>>
>> thanks
>>
>>
>> On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young 
>> wrote:
>>
>>> please also solve my query of folders of mails logbook
>>>
>>> regds
>>>
>>>
>>> On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young 
>>> wrote:
>>>
>>>> thanks a lot bro
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi  wrote:
>>>>
>>>>> PFA
>>>>>
>>>>> Cheers!!
>>>>> .*show(Time)*
>>>>>
>>>>>
>>>>> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young 
>>>>> wrote:
>>>>>
>>>>>> no bro,
>>>>>>
>>>>>> i want Repeat Top row should come in print on every individual
>>>>>> sheet's first 6 pages. from page 7 i dont need Repeat Top Row in prints 
>>>>>> it
>>>>>> should come in print without Repeat Top Rows in remaining pages. Same is
>>>>>> for rest of the sheets.
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>>
>>>>>> On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:
>>>>>>
>>>>>>> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on
>>>>>>> all pages of sheet 1,2,3 etc..
>>>>>>>
>>>>>>> it it correct??
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> hi,
>>>>>>>>
>>>>>>>> i am talking about the "Repeat Top Rows" not header or footer
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Check this link.:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>>>>>>>
>>>>>>>>> Cheers
>>>>>>>>> On Jun 11, 2014 9:39 PM, "Rohan Young" 
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young <
>>>>>>>>>> rohan.j...@gmail.com> wrote:
>>>>>>>>>>
>>>>>>>>>>> Dear Group,
>>>>>>>>>>>
>>>>>>>>>>> I need to repeat header rows in prints in specific sheets after
>>>>>>>>>>> that no need to print header rows on remaining sheets.
>>>>>>>>>>>
>>>>>>>>>>> Thanks in advance
>>>>>>>>>>> ROHAN
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Dear Group,
>>>>>>>>>>
>>>>>>>>>> I need to repeat header rows in prints in specific sheets after
>>>>>>>>>> that no need to print header rows on remaining sheets.
>>>>>>>>>>
>>>>>>>>>> Thanks in advance
>>>>>>>>>> ROHAN
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

one more thing if you can add on this that is both side printing coz our
organization preferred that or excel could take own-self the setting of
both side printing as default

thanks


On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young  wrote:

> please also solve my query of folders of mails logbook
>
> regds
>
>
> On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young  wrote:
>
>> thanks a lot bro
>>
>>
>>
>>
>> On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi  wrote:
>>
>>> PFA
>>>
>>> Cheers!!
>>> .*show(Time)*
>>>
>>>
>>> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young 
>>> wrote:
>>>
>>>> no bro,
>>>>
>>>> i want Repeat Top row should come in print on every individual sheet's
>>>> first 6 pages. from page 7 i dont need Repeat Top Row in prints it should
>>>> come in print without Repeat Top Rows in remaining pages. Same is for rest
>>>> of the sheets.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:
>>>>
>>>>> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on
>>>>> all pages of sheet 1,2,3 etc..
>>>>>
>>>>> it it correct??
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young 
>>>>> wrote:
>>>>>
>>>>>> hi,
>>>>>>
>>>>>> i am talking about the "Repeat Top Rows" not header or footer
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>>
>>>>>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi  wrote:
>>>>>>
>>>>>>> Check this link.:
>>>>>>>
>>>>>>>
>>>>>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>>>>>
>>>>>>> Cheers
>>>>>>> On Jun 11, 2014 9:39 PM, "Rohan Young"  wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Dear Group,
>>>>>>>>>
>>>>>>>>> I need to repeat header rows in prints in specific sheets after
>>>>>>>>> that no need to print header rows on remaining sheets.
>>>>>>>>>
>>>>>>>>> Thanks in advance
>>>>>>>>> ROHAN
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>
>>>>>>>>
>>>>>>>> Dear Group,
>>>>>>>>
>>>>>>>> I need to repeat header rows in prints in specific sheets after
>>>>>>>> that no need to print header rows on remaining sheets.
>>>>>>>>
>>>>>>>> Thanks in advance
>>>>>>>> ROHAN
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> --
>>>>>>>> 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

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

please also solve my query of folders of mails logbook

regds


On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young  wrote:

> thanks a lot bro
>
>
>
>
> On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi  wrote:
>
>> PFA
>>
>> Cheers!!
>> .*show(Time)*
>>
>>
>> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young 
>> wrote:
>>
>>> no bro,
>>>
>>> i want Repeat Top row should come in print on every individual sheet's
>>> first 6 pages. from page 7 i dont need Repeat Top Row in prints it should
>>> come in print without Repeat Top Rows in remaining pages. Same is for rest
>>> of the sheets.
>>>
>>> Thanks
>>>
>>>
>>> On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:
>>>
>>>> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on
>>>> all pages of sheet 1,2,3 etc..
>>>>
>>>> it it correct??
>>>>
>>>>
>>>>
>>>> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young 
>>>> wrote:
>>>>
>>>>> hi,
>>>>>
>>>>> i am talking about the "Repeat Top Rows" not header or footer
>>>>>
>>>>> thanks
>>>>>
>>>>>
>>>>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi  wrote:
>>>>>
>>>>>> Check this link.:
>>>>>>
>>>>>>
>>>>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>>>>
>>>>>> Cheers
>>>>>> On Jun 11, 2014 9:39 PM, "Rohan Young"  wrote:
>>>>>>
>>>>>>>
>>>>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Dear Group,
>>>>>>>>
>>>>>>>> I need to repeat header rows in prints in specific sheets after
>>>>>>>> that no need to print header rows on remaining sheets.
>>>>>>>>
>>>>>>>> Thanks in advance
>>>>>>>> ROHAN
>>>>>>>>
>>>>>>>> --
>>>>>>>
>>>>>>>
>>>>>>> Dear Group,
>>>>>>>
>>>>>>> I need to repeat header rows in prints in specific sheets after that
>>>>>>> no need to print header rows on remaining sheets.
>>>>>>>
>>>>>>> Thanks in advance
>>>>>>> ROHAN
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> --
>>>>>>> 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.

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

thanks a lot bro




On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi  wrote:

> PFA
>
> Cheers!!
> .*show(Time)*
>
>
> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young  wrote:
>
>> no bro,
>>
>> i want Repeat Top row should come in print on every individual sheet's
>> first 6 pages. from page 7 i dont need Repeat Top Row in prints it should
>> come in print without Repeat Top Rows in remaining pages. Same is for rest
>> of the sheets.
>>
>> Thanks
>>
>>
>> On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:
>>
>>> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all
>>> pages of sheet 1,2,3 etc..
>>>
>>> it it correct??
>>>
>>>
>>>
>>> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young 
>>> wrote:
>>>
>>>> hi,
>>>>
>>>> i am talking about the "Repeat Top Rows" not header or footer
>>>>
>>>> thanks
>>>>
>>>>
>>>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi  wrote:
>>>>
>>>>> Check this link.:
>>>>>
>>>>>
>>>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>>>
>>>>> Cheers
>>>>> On Jun 11, 2014 9:39 PM, "Rohan Young"  wrote:
>>>>>
>>>>>>
>>>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
>>>>>> wrote:
>>>>>>
>>>>>>> Dear Group,
>>>>>>>
>>>>>>> I need to repeat header rows in prints in specific sheets after that
>>>>>>> no need to print header rows on remaining sheets.
>>>>>>>
>>>>>>> Thanks in advance
>>>>>>> ROHAN
>>>>>>>
>>>>>>> --
>>>>>>
>>>>>>
>>>>>> Dear Group,
>>>>>>
>>>>>> I need to repeat header rows in prints in specific sheets after that
>>>>>> no need to print header rows on remaining sheets.
>>>>>>
>>>>>> Thanks in advance
>>>>>> ROHAN
>>>>>>
>>>>>> --
>>>>>>
>>>>>> --
>>>>>> 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
>>>>>

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

no bro,

i want Repeat Top row should come in print on every individual sheet's
first 6 pages. from page 7 i dont need Repeat Top Row in prints it should
come in print without Repeat Top Rows in remaining pages. Same is for rest
of the sheets.

Thanks


On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi  wrote:

> If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all
> pages of sheet 1,2,3 etc..
>
> it it correct??
>
>
>
> On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young  wrote:
>
>> hi,
>>
>> i am talking about the "Repeat Top Rows" not header or footer
>>
>> thanks
>>
>>
>> On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi  wrote:
>>
>>> Check this link.:
>>>
>>>
>>> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>>>
>>> Cheers
>>> On Jun 11, 2014 9:39 PM, "Rohan Young"  wrote:
>>>
>>>>
>>>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
>>>> wrote:
>>>>
>>>>> Dear Group,
>>>>>
>>>>> I need to repeat header rows in prints in specific sheets after that
>>>>> no need to print header rows on remaining sheets.
>>>>>
>>>>> Thanks in advance
>>>>> ROHAN
>>>>>
>>>>> --
>>>>
>>>>
>>>> Dear Group,
>>>>
>>>> I need to repeat header rows in prints in specific sheets after that no
>>>> need to print header rows on remaining sheets.
>>>>
>>>> Thanks in advance
>>>> ROHAN
>>>>
>>>> --
>>>>
>>>> --
>>>> 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 

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

hi,

i am talking about the "Repeat Top Rows" not header or footer

thanks


On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi  wrote:

> Check this link.:
>
>
> http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
>
> Cheers
> On Jun 11, 2014 9:39 PM, "Rohan Young"  wrote:
>
>>
>> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
>> wrote:
>>
>>> Dear Group,
>>>
>>> I need to repeat header rows in prints in specific sheets after that no
>>> need to print header rows on remaining sheets.
>>>
>>> Thanks in advance
>>> ROHAN
>>>
>>> --
>>
>>
>> Dear Group,
>>
>> I need to repeat header rows in prints in specific sheets after that no
>> need to print header rows on remaining sheets.
>>
>> Thanks in advance
>> ROHAN
>>
>> --
>>
>> --
>> 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$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young  wrote:

> Dear Group,
>
> I need to repeat header rows in prints in specific sheets after that no
> need to print header rows on remaining sheets.
>
> Thanks in advance
> ROHAN
>
> --


Dear Group,

I need to repeat header rows in prints in specific sheets after that no
need to print header rows on remaining sheets.

Thanks in advance
ROHAN

--

-- 
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$$ Repeat Header Rows in prints for specific sheets

[Rohan Young]

Dear Group,

I need to repeat header rows in prints in specific sheets after that no
need to print header rows on remaining sheets.

Thanks in advance
ROHAN

-- 
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$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

bro, i want it from .msg file


On Wed, Jun 11, 2014 at 2:23 PM, Vaibhav Joshi  wrote:

> Rohan
>
> you want from .msg file or .pst foder?
>
>
> On Wed, Jun 11, 2014 at 12:45 PM, Rohan Young 
> wrote:
>
>> Thanks Vaibhav bro its excellent & it will help me in future but my data
>> is saved in Folders on Desktop coz I have changed the subject of the mails
>> as per the requirements. I need to pick data of mails from my saved folders
>> from desktop.
>>
>> hope u r understanding. Please make correction in it.
>>
>> Thanks Bro
>>
>> ROHAN
>>
>>
>> On Wed, Jun 11, 2014 at 11:28 AM, Vaibhav Joshi  wrote:
>>
>>> Hi
>>>
>>> Check this, you can select folder one by one. If you want to Import from
>>> one folder only then once data is imported press escape key when prompted
>>> for second time.
>>>
>>> Cheers!!
>>>
>>>
>>> On Wed, Jun 11, 2014 at 10:22 AM, Rohan Young 
>>> wrote:
>>>
>>>> Hi Ravinder,
>>>>
>>>> I want to save a excel file like logbook of Incoming & Outgoing mails
>>>> with details as stated before no need of msg body
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Wed, Jun 11, 2014 at 10:16 AM, Ravinder >>> > wrote:
>>>>
>>>>> U want to save exl files with name or outlook mails in incoming and
>>>>> outgoing folders?
>>>>>
>>>>>
>>>>>
>>>>> *From:* excel-macros@googlegroups.com [mailto:
>>>>> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young
>>>>> *Sent:* Tuesday, June 10, 2014 4:55 PM
>>>>> *To:* excel-macros@googlegroups.com
>>>>> *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through
>>>>> MACRO
>>>>>
>>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>>
>>>>>
>>>>> Thanks Anil & Ravinder but I need to make log in Excel with details of
>>>>> To, From, CC, Subject, Date, Time etc. and all data of Outlook mails is
>>>>> saved in Hard Drive with the name of Incoming & Outgoing. please look at
>>>>> output sample :
>>>>>
>>>>>
>>>>>
>>>>> *To*
>>>>>
>>>>> *CC*
>>>>>
>>>>> *From*
>>>>>
>>>>> *Subject*
>>>>>
>>>>> *Date Received*
>>>>>
>>>>> *Time of mail*
>>>>>
>>>>> abc
>>>>>
>>>>> xyz
>>>>>
>>>>> 123
>>>>>
>>>>> Hello
>>>>>
>>>>> 10-Jun-14
>>>>>
>>>>> 16:51
>>>>>
>>>>>
>>>>>
>>>>> thanks in advance
>>>>>
>>>>>
>>>>>
>>>>> Regds
>>>>>
>>>>>
>>>>>
>>>>> ROHAN
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan 
>>>>> wrote:
>>>>>
>>>>> Hi Anil ,
>>>>>
>>>>>
>>>>>
>>>>> Good work , If the email id added in one column (As per attached ) we
>>>>> have to sent detail to corresponding emails . please advise how it will 
>>>>> work
>>>>>
>>>>> Eg. here Sony details need to sent x...@gmail.com
>>>>>
>>>>> and LG details sould be ZZZ@gmail .com etc like that
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli 
>>>>> wrote:
>>>>>
>>>>>  Dear Rohan,
>>>>>
>>>>> Pl find attached.
>>>>>
>>>>> Warm Regards,
>>>>> Gawli Anil/.
>>>>>
>>>>>
>>>>> On Tue, Jun 10, 2014 at 2:19 PM, Rohan Young 
>>>>> wrote:
>>>>> > Hi Group,
>>>>> >
>>>>> > I have two folders of mails (incoming & outgoing) and I need a macro
>>>>> to make
>>>>> > a log of mails separately of both folders in excel with the following

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

Thanks Vaibhav bro its excellent & it will help me in future but my data is
saved in Folders on Desktop coz I have changed the subject of the mails as
per the requirements. I need to pick data of mails from my saved folders
from desktop.

hope u r understanding. Please make correction in it.

Thanks Bro

ROHAN


On Wed, Jun 11, 2014 at 11:28 AM, Vaibhav Joshi  wrote:

> Hi
>
> Check this, you can select folder one by one. If you want to Import from
> one folder only then once data is imported press escape key when prompted
> for second time.
>
> Cheers!!
>
>
> On Wed, Jun 11, 2014 at 10:22 AM, Rohan Young 
> wrote:
>
>> Hi Ravinder,
>>
>> I want to save a excel file like logbook of Incoming & Outgoing mails
>> with details as stated before no need of msg body
>>
>> Thanks
>>
>>
>> On Wed, Jun 11, 2014 at 10:16 AM, Ravinder 
>> wrote:
>>
>>> U want to save exl files with name or outlook mails in incoming and
>>> outgoing folders?
>>>
>>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young
>>> *Sent:* Tuesday, June 10, 2014 4:55 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO
>>>
>>>
>>>
>>> Hi,
>>>
>>>
>>>
>>> Thanks Anil & Ravinder but I need to make log in Excel with details of
>>> To, From, CC, Subject, Date, Time etc. and all data of Outlook mails is
>>> saved in Hard Drive with the name of Incoming & Outgoing. please look at
>>> output sample :
>>>
>>>
>>>
>>> *To*
>>>
>>> *CC*
>>>
>>> *From*
>>>
>>> *Subject*
>>>
>>> *Date Received*
>>>
>>> *Time of mail*
>>>
>>> abc
>>>
>>> xyz
>>>
>>> 123
>>>
>>> Hello
>>>
>>> 10-Jun-14
>>>
>>> 16:51
>>>
>>>
>>>
>>> thanks in advance
>>>
>>>
>>>
>>> Regds
>>>
>>>
>>>
>>> ROHAN
>>>
>>>
>>>
>>> On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan 
>>> wrote:
>>>
>>> Hi Anil ,
>>>
>>>
>>>
>>> Good work , If the email id added in one column (As per attached ) we
>>> have to sent detail to corresponding emails . please advise how it will work
>>>
>>> Eg. here Sony details need to sent x...@gmail.com
>>>
>>> and LG details sould be ZZZ@gmail .com etc like that
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli 
>>> wrote:
>>>
>>>  Dear Rohan,
>>>
>>> Pl find attached.
>>>
>>> Warm Regards,
>>> Gawli Anil/.
>>>
>>>
>>> On Tue, Jun 10, 2014 at 2:19 PM, Rohan Young 
>>> wrote:
>>> > Hi Group,
>>> >
>>> > I have two folders of mails (incoming & outgoing) and I need a macro
>>> to make
>>> > a log of mails separately of both folders in excel with the following
>>> > details
>>> >
>>> > From, To, CC, Subject, Date, Time
>>> >
>>> > Please do the needful ASAP
>>> >
>>> > Rgds
>>> >
>>> > ROHAN
>>> >
>>> > 9818247278
>>> >
>>> > --
>>> > 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

$$Excel-Macros$$ Repeat Header Rows in prints upto initial selected sheets

[Rohan Young]

Dear Group,

I need a UDF for repeat header rows in prints upto selected sheets (i.e.
initial 5 or 6 no. sheets) after that no need to print header rows on
remaining sheets.

Thanks in advance
ROHAN

-- 
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$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

Hi Ravinder,

I want to save a excel file like logbook of Incoming & Outgoing mails with
details as stated before no need of msg body

Thanks


On Wed, Jun 11, 2014 at 10:16 AM, Ravinder 
wrote:

> U want to save exl files with name or outlook mails in incoming and
> outgoing folders?
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young
> *Sent:* Tuesday, June 10, 2014 4:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO
>
>
>
> Hi,
>
>
>
> Thanks Anil & Ravinder but I need to make log in Excel with details of To,
> From, CC, Subject, Date, Time etc. and all data of Outlook mails is saved
> in Hard Drive with the name of Incoming & Outgoing. please look at output
> sample :
>
>
>
> *To*
>
> *CC*
>
> *From*
>
> *Subject*
>
> *Date Received*
>
> *Time of mail*
>
> abc
>
> xyz
>
> 123
>
> Hello
>
> 10-Jun-14
>
> 16:51
>
>
>
> thanks in advance
>
>
>
> Regds
>
>
>
> ROHAN
>
>
>
> On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan 
> wrote:
>
> Hi Anil ,
>
>
>
> Good work , If the email id added in one column (As per attached ) we have
> to sent detail to corresponding emails . please advise how it will work
>
> Eg. here Sony details need to sent x...@gmail.com
>
> and LG details sould be ZZZ@gmail .com etc like that
>
>
>
>
>
>
>
> On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli 
> wrote:
>
>  Dear Rohan,
>
> Pl find attached.
>
> Warm Regards,
> Gawli Anil/.
>
>
> On Tue, Jun 10, 2014 at 2:19 PM, Rohan Young  wrote:
> > Hi Group,
> >
> > I have two folders of mails (incoming & outgoing) and I need a macro to
> make
> > a log of mails separately of both folders in excel with the following
> > details
> >
> > From, To, CC, Subject, Date, Time
> >
> > Please do the needful ASAP
> >
> > Rgds
> >
> > ROHAN
> >
> > 9818247278
> >
> > --
> > 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 gr

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

Hi,

Thanks Anil & Ravinder but I need to make log in Excel with details of To,
From, CC, Subject, Date, Time etc. and all data of Outlook mails is saved
in Hard Drive with the name of Incoming & Outgoing. please look at output
sample :

   *To* *CC* *From* *Subject* *Date Received* *Time of mail*  abc xyz 123
Hello 10-Jun-14 16:51

thanks in advance

Regds

ROHAN


On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan  wrote:

> Hi Anil ,
>
> Good work , If the email id added in one column (As per attached ) we have
> to sent detail to corresponding emails . please advise how it will work
> Eg. here Sony details need to sent x...@gmail.com
> and LG details sould be ZZZ@gmail .com etc like that
>
>
>
>
> On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli 
> wrote:
>
>>  Dear Rohan,
>>
>> Pl find attached.
>>
>> Warm Regards,
>> Gawli Anil/.
>>
>> On Tue, Jun 10, 2014 at 2:19 PM, Rohan Young 
>> wrote:
>> > Hi Group,
>> >
>> > I have two folders of mails (incoming & outgoing) and I need a macro to
>> make
>> > a log of mails separately of both folders in excel with the following
>> > details
>> >
>> > From, To, CC, Subject, Date, Time
>> >
>> > Please do the needful ASAP
>> >
>> > Rgds
>> >
>> > ROHAN
>> >
>> > 9818247278
>> >
>> > --
>> > 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 Hel

$$Excel-Macros$$ Outlook Mails log in Excel through MACRO

[Rohan Young]

Hi Group,

I have two folders of mails (incoming & outgoing) and I need a macro to
make a log of mails separately of both folders in excel with the following
details

From, To, CC, Subject, Date, Time

Please do the needful ASAP

Rgds

ROHAN

9818247278

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

[Rohan Young]

http://thereferraljob.com/?refer=33938

pls conform the above link to conform your payment

thanks

-- 
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$$ Copy data from one sheet to another by matching column header

[rohan . ghatak . 85]

Hi Friends,

I Have an workbook, where i want to copy data from one sheet to another 
sheet by matching column header and also to format the destination column 
in general format is there any VB Code for it

i have this code with me but it gives me error 400, please help 

Sub Test()
Dim rng As Range

Set rng = Sheets("Raw Data").Range("A1:IV1").Find("Quantity", 
LookIn:=xlValues)
Sheets("Raw Data").Range("E" & Rows.Count).End(xlUp).Row.Copy

Set rng = Sheets("Results").Range("A1:IV1").Find("Quantity", 
LookIn:=xlValues)

rng.Offset(1, 0).PasteSpecial (xlPasteAll)
End Sub 

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

[Rohan Young]

Prince ji happy diwali,

i thing me want to share wid u why u always share wid new mail, why dont
wid related quary?

thanks


On Wed, Nov 14, 2012 at 8:39 AM, Prince  wrote:

> Hi Anjali,
>
> Please set the below option in your workbook.
>
>  Tools -> Options -> Formulas -> Calculation Options -> Automatic -> Click
> Ok
>
> Regards
> Prince
>
>
> On Tuesday, November 13, 2012 12:41:27 AM UTC+5:30, Anjali . wrote:
>>
>> Hi Everyone,
>> Please be find the attached excel file in which i am facing some
>> Automatic calculation problem.
>>
>> 1. If i entered the value in Column "H" of Sheet1, The Formula in Cell
>> "B2" & "C2" of Sheet1 is not updating automatically.
>> only after saving the file, all the cells which has the formula is then
>> getting updated.
>> I want Cells "B2" & "C2" of Sheet1 to be update immediately after
>> entering the value in Column "H"
>>
>> 2. Same problem in Column "F" of Sheet2.
>>
>> Please help me out.
>> I will be thankfull to you all.
>>
>> Thanks & Regards,
>>
>>
>>
>>
>>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

[Rohan Young]

Congratulation Rajan


On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair  wrote:

> Congrats Rajan
>
>
> On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh wrote:
>
>>
>> Hi,
>>
>> *Congratulations* Rajan Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive (MIS)
>> Info Edge India Limited (naukri.com)
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>  *
>> *
>> On Tue, Nov 6, 2012 at 10:20 AM, Satendra kumar <
>> satendrakuma...@gmail.com> wrote:
>>
>>> *CONGRATULATION. *
>>>
>>>  On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>>>

 Dear members,

 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 Oct'12. He has posted 66 posts in last month and helped forum members
 through his excel expertise.
 I truly appreciate his knowledge, consistency and commitment to the
 group.
 *
 Rajan, please find enclosed the award certificate in honor of your
 contribution. Congratulations and thanks for your contribution.
 *

 Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other
 folks for helping excel enthusiasts voluntarily !!
 Keep posting.

 Regards,
 Ayush Jain
 Group Manager

 P.S. If you have any feedback, please share your thoughts by filling
 the survey 
 form.



 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



>>>
>>>
>>>
>>> --
>>> Thanks & Regards
>>> Satendra Kumar
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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, f

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

[Rohan Young]

ok then use LEFT($B$12,2)&LEFT($C$12,2)&LEFT($D1$2,2)


On Sat, Nov 3, 2012 at 11:43 PM, cyberuser  wrote:

> Hi,
>
> The text is located in a single cell and it can be of variable words...
>
> example:
>
> Cells A1: "John Doe Junior"
> Cell B1 should return "jodoju"
>
> or
>
> Cell A1: "John Doe"
> Cell B1 returns "jodo"
>
> Thanks
>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

[Rohan Young]

plz put range as per ur requirement




On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young  wrote:

> HI,
>
> TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2)
>
> REGDS
>
>
> On Sat, Nov 3, 2012 at 11:14 PM, cyberuser  wrote:
>
>> Hi,
>>
>> Is there a formula that would the 2 first characters from a name, eg.
>> first, and/or second, and last name?
>>
>> example:
>> in cell A1:
>> "John Doe Junior"
>> in cell B1 the formula would render:
>> jodoju
>>
>> or if "John Doe"
>> jodo
>>
>> Thanks
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

[Rohan Young]

HI,

TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2)

REGDS


On Sat, Nov 3, 2012 at 11:14 PM, cyberuser  wrote:

> Hi,
>
> Is there a formula that would the 2 first characters from a name, eg.
> first, and/or second, and last name?
>
> example:
> in cell A1:
> "John Doe Junior"
> in cell B1 the formula would render:
> jodoju
>
> or if "John Doe"
> jodo
>
> Thanks
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

[Rohan Young]

hi raja,

its not working

regds



On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR  wrote:

>
>
>
> On 3 November 2012 15:44, Pravin Gunjal  wrote:
>
>> *Thanks Kuldeep for your reply.*
>> *I want the cursor should go in the cell "D1" when the ENTER key is
>> pressed.*
>>  *
>> *
>> On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh wrote:
>>
>>>
>>> Hi Pravin,
>>>
>>> You want to press enter --> D1,D2,D3 OR, D1,E1,F1,G1
>>>
>>> Regads,
>>> Kuldeep Singh
>>>
>>> On Sat, Nov 3, 2012 at 3:32 PM, Pravin Gunjal  wrote:
>>>
 *Dear Friends,*
 *
 *
 *Is it possible to move the cursor automatically in to the cell "D1"
 when we hit the ENTER key.*
 *Please inform.. Thank you.*
 *
 *
 *Regards*
 *Pravin Gunjal*
 *
 *

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.

>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> "Making a million friends is not a miracle, the miracle is to make a
> friend who will stand by you when a million are against you. "
>
>
>
> ---

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

[Rohan Young]

hi,

Click the mouse in the Name Box (the area to the left of the formula bar
that shows an address of present or selected cell(s)) press D1 and enter.

redgs


On Sat, Nov 3, 2012 at 3:44 PM, Pravin Gunjal  wrote:

> *Thanks Kuldeep for your reply.*
> *I want the cursor should go in the cell "D1" when the ENTER key is
> pressed.*
>  *
> *
> On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh wrote:
>
>>
>> Hi Pravin,
>>
>> You want to press enter --> D1,D2,D3 OR, D1,E1,F1,G1
>>
>> Regads,
>> Kuldeep Singh
>>
>> On Sat, Nov 3, 2012 at 3:32 PM, Pravin Gunjal  wrote:
>>
>>> *Dear Friends,*
>>> *
>>> *
>>> *Is it possible to move the cursor automatically in to the cell "D1"
>>> when we hit the ENTER key.*
>>> *Please inform.. Thank you.*
>>> *
>>> *
>>> *Regards*
>>> *Pravin Gunjal*
>>> *
>>> *
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, an

Re: $$Excel-Macros$$ Pls help

[Rohan Young]

Hi,


try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then  Esc

regds


On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran <
karthikeyansankar...@gmail.com> wrote:

> Hi,
>
> How to select particular cell value within one click.I need to select
> value 2 only.
> without using macro , filter and ctrl+cell.
>
> example:-
> 1
> 2
> 3
> 1
> 2
> 1
> 2
>
> Thanks,
> karthik
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Serial no

[Rohan Young]

hi Prashant,

PFA

regds

On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote:

> Dear Experts
>
> Please help to arrive serial number with if condition
>
> Regards,
>
> Prashant
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

Re: $$Excel-Macros$$ If greater then the cell color should be red else green

[Rohan Young]

hi,

try this

Regds

On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics) <
prasad.kam...@imrbint.com> wrote:

> Hi Sundarvelan,
>
>
> PFA…done with conditional formatting.
>
> ** **
>
> Regards,
>
> Prasad K
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sundarvelan N
> *Sent:* Tuesday, October 30, 2012 3:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ If greater then the cell color should be red
> else green
>
> ** **
>
> Dear Gurus,
>
>  
>
> Please help me on the attached excel query.
>
>  
>
> If greater than EOT then the cell color should be red elase green
>
>
>  
>
> Thanks
>
> N.Sundarvelan 
>
> 9600160150
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>  
>
> http://www.imrbint.com/disclaimer.html
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

[Rohan Young]

Oh mere NOORAIN Bhai,
Sabki toh le li BADHAI.
Ab apni hai baari aayi,
Mubarak ho aapko apni,
KABLIYAT ki yeh kamai.

Many-2 Congrts NOORAIN bhai.. KEEP IT UP

On Sat, Aug 4, 2012 at 10:48 PM, SAGAR KASANGOTTUWAR
 wrote:
> Congratulations Noorain,
>
> All the best ...
>
> You are the heart of this google group...
>
> On Sun, Aug 5, 2012 at 10:30 AM, Aindril De  wrote:
>>
>> Great Work Noorain!!
>> Though I have been silent in this group for quite some time...
>> However I keep following the posts.. almost everyday.. thx to great
>> members like you, from whom I learn everyday...!
>>
>> Cheers and Keep up the good work,
>>
>> Regards,
>> Andy
>>
>> On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:
>>>
>>> Dear members,
>>>
>>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>>> members through his excel expertise.
>>>
>>> I truly appreciate his consistency and commitment to the group. He is
>>> really doing great job.
>>>
>>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> 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
>>>
>>>
>>
>>
>>
>>
>> --
>>
>> Warm Regards,
>> Aindril De
>> Ph: 9811300157
>>
>> --
>> 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
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 
si

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

[Rohan Young]

just correct your answer

=COUNTIF($E$10:E49,"GIRL")

On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल  wrote:
> Dear all,
>
> Can you please help me to find out the total number of boy and girl ? I used
> countif for their grade and it worked. However, for girl and boy
> seggregation it isnot working.
>
> Thank you very much for the support you all have been providing.
>
> sunita
>
> --
> 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

Re: $$Excel-Macros$$ Mails IDs from Outlook

[Rohan Young]

Dears,

i m facing run time error 1004

For Each oitem In myItems
Sheets("Inbox Scan").Cells(i, 1).Value = oitem.SenderName
Sheets("Inbox Scan").Cells(i, 2).Value = oitem.SenderEmailAddress
'Sheets("Inbox Scan").Cells(i, 3).Value = oitem.Subject
'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body
'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime
i = i + 1
Next
End Sub

On Mon, Jul 9, 2012 at 4:08 PM, NOORAIN ANSARI wrote:

> Dear Rohan,
>
> Please check Microsoft outlook 12.0 object Library.
>
>
>
> See attached screen shot.
>
>
> On Fri, Jul 6, 2012 at 10:11 AM, Rohan Young  wrote:
>
>> Dear Ashish Ji,
>>
>> thanks but i m not getting the result, can you please send me the add
>> in or anything else for it
>>
>> regds
>>
>> ROHAN
>>
>> On Thu, Jul 5, 2012 at 10:58 PM, ashish koul 
>> wrote:
>> > try this see if it helps
>> >
>> > Sub Scan_my_outlook_inbox()
>> > 'TOOLS ->Refrence -> microsoft outlook
>> > 'declare outlook objects
>> > Dim olapp As Outlook.Application
>> > Dim olappns As Outlook.Namespace
>> > Dim oinbox As Outlook.Folder
>> > Dim oitem As Outlook.MailItem
>> > Dim myItems As Outlook.Items
>> > Dim i As Long
>> > i = 2
>> > 'set outlook objects
>> > Set olapp = New Outlook.Application
>> > Set olappns = olapp.GetNamespace("MAPI")
>> > ' it will scan inbox folder only
>> > Set oinbox = olappns.GetDefaultFolder(olFolderInbox)
>> > ' sort emails on recieved basis
>> > Set myItems = oinbox.Items
>> > myItems.Sort "[Received]", True
>> >
>> > 'loop through all unread emails
>> >
>> > For Each oitem In myItems
>> > Sheets("Inbox Scan").Cells(i, 1).Value = oitem.SenderName
>> > Sheets("Inbox Scan").Cells(i, 2).Value =
>> oitem.SenderEmailAddress
>> > 'Sheets("Inbox Scan").Cells(i, 3).Value = oitem.Subject
>> > 'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body
>> > 'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime
>> > i = i + 1
>> > Next
>> > End Sub
>> >
>> >
>> >
>> >
>> > On Thu, Jul 5, 2012 at 4:39 PM, Rohan Young 
>> wrote:
>> >>
>> >> Dear Sanjib,
>> >>
>> >> Its not working & improting i need to import all Mail IDs from My Sent
>> >> & Inbox Folder, i need any macro for this
>> >>
>> >> thanks
>> >>
>> >>
>> >> On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
>> >>  wrote:
>> >> > Just follow follow the link
>> >> >
>> >> > http://support.microsoft.com/kb/295664
>> >> >
>> >> >
>> >> > On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young 
>> >> > wrote:
>> >> >>
>> >> >> Dear Group,
>> >> >>
>> >> >> how can i get all mail IDs  from my outlook to excel to make a list
>> of
>> >> >> all IDs and Co., please help me out
>> >> >>
>> >> >> Thanks & Regds
>> >> >>
>> >> >> ROHAN
>> >> >>
>> >> >> --
>> >> >> 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 per

Re: $$Excel-Macros$$ Mails IDs from Outlook

[Rohan Young]

Dear Ashish Ji,

thanks but i m not getting the result, can you please send me the add
in or anything else for it

regds

ROHAN

On Thu, Jul 5, 2012 at 10:58 PM, ashish koul  wrote:
> try this see if it helps
>
> Sub Scan_my_outlook_inbox()
> 'TOOLS ->Refrence -> microsoft outlook
> 'declare outlook objects
> Dim olapp As Outlook.Application
> Dim olappns As Outlook.Namespace
> Dim oinbox As Outlook.Folder
> Dim oitem As Outlook.MailItem
> Dim myItems As Outlook.Items
> Dim i As Long
> i = 2
> 'set outlook objects
> Set olapp = New Outlook.Application
> Set olappns = olapp.GetNamespace("MAPI")
> ' it will scan inbox folder only
> Set oinbox = olappns.GetDefaultFolder(olFolderInbox)
> ' sort emails on recieved basis
> Set myItems = oinbox.Items
> myItems.Sort "[Received]", True
>
> 'loop through all unread emails
>
> For Each oitem In myItems
> Sheets("Inbox Scan").Cells(i, 1).Value = oitem.SenderName
> Sheets("Inbox Scan").Cells(i, 2).Value = oitem.SenderEmailAddress
> 'Sheets("Inbox Scan").Cells(i, 3).Value = oitem.Subject
> 'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body
> 'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime
> i = i + 1
> Next
> End Sub
>
>
>
>
> On Thu, Jul 5, 2012 at 4:39 PM, Rohan Young  wrote:
>>
>> Dear Sanjib,
>>
>> Its not working & improting i need to import all Mail IDs from My Sent
>> & Inbox Folder, i need any macro for this
>>
>> thanks
>>
>>
>> On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
>>  wrote:
>> > Just follow follow the link
>> >
>> > http://support.microsoft.com/kb/295664
>> >
>> >
>> > On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young 
>> > wrote:
>> >>
>> >> Dear Group,
>> >>
>> >> how can i get all mail IDs  from my outlook to excel to make a list of
>> >> all IDs and Co., please help me out
>> >>
>> >> Thanks & Regds
>> >>
>> >> ROHAN
>> >>
>> >> --
>> >> 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.
>>
>>
>> --

Re: $$Excel-Macros$$ Mails IDs from Outlook

[Rohan Young]

Dear Sanjib,

Its not working & improting i need to import all Mail IDs from My Sent
& Inbox Folder, i need any macro for this

thanks


On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
 wrote:
> Just follow follow the link
>
> http://support.microsoft.com/kb/295664
>
>
> On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young  wrote:
>>
>> Dear Group,
>>
>> how can i get all mail IDs  from my outlook to excel to make a list of
>> all IDs and Co., please help me out
>>
>> Thanks & Regds
>>
>> ROHAN
>>
>> --
>> 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

$$Excel-Macros$$ Mails IDs from Outlook

[Rohan Young]

Dear Group,

how can i get all mail IDs  from my outlook to excel to make a list of
all IDs and Co., please help me out

Thanks & Regds

ROHAN

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

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

[Rohan Young]

Congratulations to both of you and thanks for being with us



On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey  wrote:
> Thanks Ayush..!!
>
> Thanks to all the members of this group for giving us many chances to
> learn by sharing their queries. ;)
>
> It is a great group.. . Thanks once again.
>
> Regards,
> DILIPandey
>
> On 7/1/12, Ayush Jain  wrote:
>> Dear members,
>>
>> I am extremely happy to inform you that two members of the group are
>> awarded Microsoft Most Valuable Professional Award.
>> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
>> thanks for their big support to this forum.
>>
>> Keep posting !
>>
>> Best regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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,
>
> DILIP KUMAR PANDEY, mvp
>MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> 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

Re: $$Excel-Macros$$ I want to repeat the text or number,

[Rohan Young]

Dear Neeraj,

See the attachment, if help

Regds

ROHAN


On Tue, Jun 26, 2012 at 2:11 PM, Neeraj Chauhan
wrote:

> Siwaya
>
> Sikhera 1
>
> Maithna Inder Singh
>
> Salarpur
>
> Niit
>
> Pela Sofipur
>
> Ganga Nagar
>
> Pallavpuram
>
> Pallav Puram
>
> Ganga Nagar (Meerut)
>
> Behind Metro Hospital
>
> Meenakshipuram
>
> Doorly
>
> Doorly
>
> Meenakshipuram
>
> Behind Metro Hospital
>
> Ganga Nagar (Meerut)
>
> Behind Metro Hospital
>
> Pallavpuram
>
> Pallav Puram
>
> Pela Sofipur
>
> Ganga Nagar
>
> Salarpur
>
> Maithna Inder Singh
>
> Sikhera 1
>
> Siwaya
>

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




Repeat Text or Number_Neeraj_Solved.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ age month days calculations - Reg

[Rohan Young]

try this

=+DATEDIF(A1,NOW(),"y")&" Years, "&DATEDIF(A1,NOW(),"ym")&" Months,
"&DATEDIF(A1,NOW(),"md")&" Days "

Regds

On Fri, Jun 22, 2012 at 1:29 PM, Suman  wrote:
> Hi Dear !
> Please use this formula if its help you.
> =Text(Today()-that cell which contain ur birth date,"yy")
>
> Regards,
> @Suman
> Send on the move with Galexy y.
>
> On Jun 22, 2012 12:56 PM, "jmothilal"  wrote:
>>
>>
>> Dear any one
>>
>> i want find age month days calculations in between two days. pls help me
>>
>>
>>
>> thanks with
>>
>> --
>>
>> J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri,
>> Vellore-2
>>
>>
>> --
>> -- 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. 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

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

[Rohan Young]

*Congratulation Nootain Bhai * - Keep it up

On Thu, Mar 15, 2012 at 3:40 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:

> Congratulations... Mr.Ansari.. Hope will continue your good work...
> Radha Lakshmi..
>
>
> On Thu, Mar 15, 2012 at 11:39 AM, jmothilal  wrote:
>
>> Congratulation Noorain.
>>
>>
>> Mothilal.J
>> Universal Computer\
>> Vellore -2
>>
>>
>>
>>
>>
>>
>> On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey wrote:
>>
>>> Congratulations Noorain
>>>
>>> Keep up the good work and keep helping :)
>>>
>>> Regards,
>>> DILIPandey
>>>
>>>
>>> On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain 
>>> wrote:
>>>
 Many congratulations Noorain bro!

 Keep up the good work and keep helping us mere mortals in excelling our
 lives. :)

 God bless


 On Thu, Mar 15, 2012 at 11:23 AM, Maries  wrote:

> Congrats Brother..
>
>
> On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Congratulation for you achievement. Hoping for a good luck.
>>
>> sanjib
>>
>> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote:
>>
>>>  Hello Everyone,
>>>
>>> Noorain Ansari has been selected as 'Most Helpful Member' for the
>>> month of Feb'12
>>> He has posted 156 posts in Feb'12 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum but 
>>> has
>>> acheived this recognition for third time.
>>>
>>> *About Noorain Ansari :*
>>> [image: noorain.jpg]
>>>
>>> Noorain is a great poet and keep sharing his thoughts on different
>>> topics throgh cool poems. Professionally, he is a Excel aficionado and
>>> presently working as senior business analyst in One97 Communication 
>>> Ltd. He
>>> is a MS excel - vba expert and keep sharing his thoughts with this 
>>> forum.
>>> You can follow his blogs for Excel knowledge and cool poems :
>>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>>
>>> *Noorain, Many thanks for all your great support to group. Keep it
>>> up*
>>>
>>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep
>>> it up !!
>>> **
>>> *Keep posting.
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> 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 t

Re: $$Excel-Macros$$ Custom Format Examples

[Rohan Young]

Gud1 Noorain Bhai - carry on


On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed  wrote:
> Hi Noorain,
> One small question how can I set this formats as default in my excel.
>
> Thanks
> Waheed
> On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel  wrote:
>>
>> NOORAIN ROCKS ONCE AGAIN
>>
>>
>>
>> Really helpful attachment for excel user from one of the most helpful
>> member of the group
>>
>> Thanks a lot brother
>>
>> Kalyan Chattopadhyay
>>
>> Executive Sales Coordinator
>> R. S. H. Pvt. Ltd.
>>
>> --
>> 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$$ Series and Justify in Excel 2010

[Rohan]

Thanks for the effort xlstime. But these are not what I am looking for
in Excel 2010. I am looking for Home - Editing - Fill button(editing
section). Please help me with any tutorial for this section if
possible. Thanks !!

Rohan.

-- 
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$$ Series and Justify in Excel 2010

[Rohan]

Hi Group,

Could anyone please share some tutorials for the "Series"and "Justify"
features in the Fill dropdown of Excel 2010. Thanks in advance.

Rohan.

-- 
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$$ Most Helpful Member Jan'12 - Noorain Ansari

[Rohan Young]

CONGRATULATION NOORAIN BHAI, CARRY ON.

On Sat, Feb 4, 2012 at 10:47 AM, Venkat CV  wrote:

> Congrats...
>
> Noorain & Everyone...
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
>
>
> On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain  wrote:
>
>>  Hello Everyone,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of Jan'12
>> He has posted 175 posts in Jan'12 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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$$ Liniking Pivot Tables

[Rohan]

I kind of agree with sam on this, and dont think that there is a way
by which any other pivot table will get effected by changing the value
of one pivot table. If you often apply filter on the same kind of
data, then you can always use the SLICERS in Excel, which should
definitely solve your concern.

Thanks,
Rohan.

-- 
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$$ $$Excel-Ma​cros$$ Index & Match Formula

[Rohan]

Really dont understand your output completly. Could you please explain
the requirement more clearly even if sam's answer above solves your
query.

Thanks
Rohan.

-- 
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$$ Amazing... Excel Menu Bar... Try it... you will like it

[Rohan]

Nice Work. Thank you !!

Rohan.

-- 
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$$ Re: Analytics

[Rohan]

Additionally, this is required for pure marketing and sales, so that I
can attract the team and the leadership on the importance of data and
analytics and also how it can help us improve on efficienc and
forecasting. Any help in this regard will be deeply appreciated.


Regards,
Rohan.

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

[Rohan]

Hi All,
Dear friends, I am looking for a pitch/presentation which represents
the value to data in the organisation and how data can transform the
decision making abilty of an organisation and drive growth. Moreover,
what are the best analytics ability that an organisation can have.

If you have a related slide, please attach the slides. Thank you !!


Regards,
Rohan.

-- 
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$$ Re: Help On Print

[Rohan]

Please excuse my delayed reply. I just tried running the code that you
provided in the attachment above. The code seems to be absolutely
fine. The only thing, that may have caused trouble, if you did not
enter the dates in the correct format. Please ensure that you enter
the date in the same format, in which its there in the sheet.

If the issues persists, you can get back to me with the error...!!
Thank you !!

Regards,
Rohan.

-- 
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$$dividing my data set in 70-30 Ratio

[Rohan]

Try this.use this macro

Sub Test()

Dim RowCount As Integer
Dim S As Integer
Dim T As Integer
LR = Cells(Rows.Count, "A").End(xlUp).Row
RowCount = LR
S = Round(RowCount * 70 / 100, 0)
T = Application.WorksheetFunction.RoundUp(RowCount * 30 / 100, 0)
Range("A1").Resize(S).Select
Selection.Copy
Range("B1").Select
ActiveSheet.Paste
Range("A1").Resize(T).Select
Selection.Copy
Range("C1").Select
ActiveSheet.Paste

End Sub



sample data


10
20
30
40
50
60
70
80
90
100
110
120
130
140
150
160
170
180
190
200
200
213.333
221.9047619


Paste this in the first column and try running the macro. See if it
helps.on the same basic ground that I have used, u can modiify the
macro as well..Thank you !!

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Best Wishes 2012

[Rohan]

Dear Friends,
Its just been a few months that I have become a member of this group,
and I am really glad I am a member. Want to take this opportunity to
wish each member of this group a very HAPPY NEW YEAR and request each
and everyone to keep up the good work. I am hoping in 2012, we ll have
more excel experts join this group, people who can code for multiple
and diverse applications(MS Office) and people who can solve tougher
problems.


Thanks to all and keep learning...



Best Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Create Uni Code

[Rohan]

Aamir, range error. Corrected. Thank you !

Sub Macro1()


Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select
Application.CutCopyMode = False
Range("C1:D" & Cells(Rows.Count,
"D").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"F1"), Unique:=True
Columns("G:G").EntireColumn.AutoFit


End Sub

-- 
FORUM RULES (934+ 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$$ Create Uni Code

[Rohan]

One more way of doing it...

Sub Macro1()

Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select
Application.CutCopyMode = False
Range("A1:B" & Cells(Rows.Count,
"B").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"F1"), Unique:=True
    Columns("G:G").EntireColumn.AutoFit

End Sub


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Lookup and summarize multiple values from another worksheet

[Rohan]

Please !! Thanks


Rohan.

-- 
FORUM RULES (934+ 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$$ Re: Fwd: Vba Code for Outlook

[Rohan]

You can use a macro to send the emails, however you would have to a
Excel sheet to store the name of the recipients and email address. Can
write a macro if that works fine for you !! Thank you !


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Compare character types in 2 character string

[Rohan]

=TYPE(VALUE(LEFT(H2,1)))=TYPE(VALUE(RIGHT(H2,1)))

Here you go. Thank you !

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: Financial Tools in excel.

[Rohan]

Not sure what your requirement is. Finance is a huge subject.
Please try to create some sample and let us know, what exactly are you
tryingy to accomplish. Thank you !


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ shortcut key .

[Rohan]

Yes, to check and uncheck the filters you can use the  bar.
Thank you !

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: Help On Print

[Rohan]

If you can replicate this for your own sheetwell and good. Else
send the worksheet over the group as an attachemnt and I will work
that out. !! Thank you !


Sub Test()
    Dim SDate As Date    Dim EDate As Date        LR =
Range("A1").End(xlDown).Row    SDate = InputBox("Put the date from
when you want to take print out?")    EDate = InputBox("Put the last
date till what you want to take print out?")       
Sheets("Sheet1").Select    For i = SDate To EDate       
Rows("1:1").Select        Selection.AutoFilter       
ActiveSheet.Range("A1:B" & LR).AutoFilter Field:=1, Criteria1:=i     
  ActiveWindow.SelectedSheets.PrintOut Copies:=1       
Rows("1:1").Select        Selection.AutoFilter    Next i
End Sub

Regards,
Rohan

-- 
FORUM RULES (934+ 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$$

[Rohan]

Thanks Noorain..!!

-- 
FORUM RULES (934+ 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$$ Re: Help On Print

[Rohan]

Hi,

You can do a filter and take a print out.!!


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: how to formatting the vba code using Notepad ++,can anyone help me?

[Rohan]

Hi,

Choose the language that you are using from the toolbar - language
menu.

There is a specific format for each specific language there. Hence, as
you choose VBA, and paste in your code there you ll see the
formattying appear. Dont think you can change that


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Change return value of data from one sheet to other by entering value in cell

[Rohan]

Have just replicated the same on my own using some sample data. Attach
your sheets and I will replicate the same in your sheet as per your
needs. Thank you !


Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: VBA code automatic typesetting and show code row number

[Rohan]

So if i get you correctly this time, your question is more related to
formatting the vba code and geeting the row number for the code,
specifically and total wise.

I think you can use a software named Notepad ++. This has a option of
formatting the vba codes and also gives you the count of lines of
codes that you have.



Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Plz help urgent

[Rohan]

Make a pivot - Right click - Value Field settings - Show values as -
Select % of grand total.


Thanks,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: Rename and search files.....need some extra help

[Rohan]

Cant open the vba file...its password protected. Send the password to
the group plz and we can try to add additional functionalities. Thank
you !

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Macro work

[Rohan]

Plz share the details and the requirement and the details...will give
it a try

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Cell editing VBA

[Rohan]

Try this... !!


Sub Test()

Range("B2").Select
Do
If ActiveCell.Value = "" Then Exit Do
ActiveCell.Offset(0, 3).Activate
Loop

End Sub

-- 
FORUM RULES (934+ 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$$ Re: VBA code automatic typesetting and show code row number

[Rohan]

Garcia,

Not sure what exactly you're asking for. If I understand, you want to
record steps in Excel and see the VBA for the same ??

-- 
FORUM RULES (934+ 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$$ No. of Occurrence of char in string

[Rohan]

This will count the input that the user makes in the input box prompt
and will display the count in a Message Box.


Sub Test()

Dim StartVal As Integer
Dim Count As Integer
Dim InputCount As Variant

InputCount = InputBox("Please enter the input u want to count")

For StartVal = 1 To Len(Range("A1"))
Range("D1").Value = Mid(Range("A1"), StartVal, 1)
If Range("D1").Value = InputCount Then
Count = Count + 1
End If
Next StartVal
MsgBox Count
End Sub

-- 
FORUM RULES (934+ 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$$ Re: Excel Books or classes

[Rohan]

I would say start topic wiseLearn each at a timelike,
basics,formulas and functions, charts, pivot tables and then on to vba/
macros.

You can start following any basic book about excel..

-- 
FORUM RULES (934+ 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$$ Conditional Formatting using VBA

[Rohan]

Derived this from Noorain wondeful Solution. Some changes in the way
if have used vba.

Sub CF()

Dim CelRng As Range
LastRow = Range("B3").End(xlDown).Row
Set CelRng = Range("B3:B" & LastRow)

For i = 3 To LastRow
If Cells(i, "B").Value <
Application.WorksheetFunction.Average(CelRng) Then
Cells(i, "B").Interior.Color = vbCyan
    End If
Next i

End Sub

Thanks,
Rohan

-- 
FORUM RULES (934+ 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$$ Conditional Formatting using named ranges

[Rohan]

Not figured out what your macro ishowever what I can suggest you
can use the Offset function to have the range of the
Conditional formating extended automatically.

Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
conditional formatting in the column A.

Put the above stated formula in the Conditonal Formatting dialog box,
where it says "Applies to"


Lemme know, if you have questions.


Rohan.

-- 
FORUM RULES (934+ 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$$ Extract Number In String - EXCEL Formula

[Rohan]

You can use this as well...

 =MID(C9,1,FIND("_",C9)-1)


Thanks
Rohan.

-- 
FORUM RULES (934+ 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$$ Need Help

[Rohan]

Guys, Cant figure out what these files do. Please explain with
example, how exactly do you use these two excel files.

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Data validation not working properly

[Rohan]

Ensure that you are using the correct formula and remove unnecessary
blanks from the sheet. Also, check the Ignore blanks in data
vlaidation box.

-- 
FORUM RULES (934+ 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$$ MS Access solution

[Rohan]

Hi,
I have a new project in hand for building a reporting solution for MS
Access. I am trying to explore the idea as to how to I go about
getting the desired results. My challange is, that the report would
require to refer to the previous day report earlier done using the
VLOOKUP formula in excel. However, the idea of using VLOOKUP function
in Access is possible or not I am not sure. While exploring some new
functions in MS ACCESS, I came accross DLOOKUP but I am not sure, if
it can produce the same results.

Group, Need your assistance with any ideas that you can share as to
how do I go about accomplishing this. If you already have worked on a
solution like this which helps in daily reporting by comparing the
value from the previous day report and if you can share the solution
with me, that will really give me ideas and would be really
appreciated. Thank you !!

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: Correction in Formula

[Rohan]

Just use >9 as ">9"


=COUNTIFS($G$3:$G$14,B4,$H$3:$H$14,">9")

Thanks,
Rohan.

-- 
FORUM RULES (934+ 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$$ MS Access Help

[Rohan]

I tried to Import the table straight instead of making a link with MS
Access. The seems to solve the problem as most of the #N/A and #NUM
does not appear. I will try and create the query and the macro in the
imported table and see if it produces consistent results. Will get
back with the sheet incase if there is any discrepancy.

Thanks,
Rohan.

-- 
FORUM RULES (934+ 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$$ Re: MS Access Help

[Rohan]

Hi Experts,

Any info on the above issue!!

-- 
FORUM RULES (934+ 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$$ MS Access Help

[Rohan]

Hi Experts,
I have a excel file which I am trying to link with MS Access for
running some queries. The Excel file contains a VLOOKUP, where I have
tried to lookup and compare the data from a previous day report. Then
I compare that data to see if they are equal or not. I simply use
A2=B2 for this, and this returns either TRUE or FALSE. The issue is
when I link this file to MS Access, it starts giving me some #N/A,
which are not there in the Excel file, to which it is linked. So when
I query the linked table, it gives me incorrect results.

Is there some thing wrong with my procedure or it is not a good idea
to Link-import a Excel sheet with formulas to MS Access. Please guide.
Thank you !

Regards,
Rohan.

-- 
FORUM RULES (934+ 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$$ Interact with other applications

[Rohan]

Hi Guys,

Thanks for your continued efforts to keep this group running, its very
helpful and a great knowledge sharing resource.

I wanted to know, how do we go ahead about making office application
interact with other applications. I mean, legacy applications, some MS-
DOS kind of applications(which we some time even use to process orders
or fetch info for our organisations etc.). I learned that I can use
some Shell commands, but I really do not understand the difference and
the boundaries in which i can have office applications interact with
any other applications.

What i need help with is, please let me know, what kind of
applications(other than office applications), I can interact with and
in order to do that what specific branch of VBA i can use. Along with
this, if you can help me with some learning resource, that would be
kind on your behalf friends.


Thank you !
Rohan.

-- 
FORUM RULES (925+ 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$$ Re: How to use Advance filter

[Rohan]

Hi,
The link that's provided is very good. Just checked it out, in see
nearly all the info there.
If you have not tried this link, please have a look and it should
solve all your queries about' Advanced Filters"

Rohan.

-- 
FORUM RULES (925+ 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$$ Re: How to use Advance filter

[Rohan]

Using advanced filter you can filter your data, as per a specific
criteria.
Advanced Filter:

List Range: Select the range that you want to filter.
Criteria Range: Select the range on the basis of which you want to
filter the data.
Unique Records only: You can select this, if you want your results to
return unique records only in the output.

I think you should try with an example to filter and see the results.
Let me know, if you have any difficulty.


Thank you !

-- 
FORUM RULES (925+ 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$$ Fwd: Required Latest No. of Drawing - Help

[Rohan Young]

Dear Paul,

please do the needful

thanks & regds

ROHAN

On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young  wrote:
> Dear Paul,
>
> one more thing your indirect formula is not working in master sheet,
> would u please explain
>
> thanks & regds
>
> On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner  
> wrote:
>> Well.. the =max() function will work to get the DATE,
>> but using the match() function with the multi-row produces an error.
>> So, I think we need to add a column (that could be hidden) to check multiple
>> rows.
>>
>> But, if the highlighting of PREVIOUS cells is an absolute requirement, then
>> we might as well do the whole thing in a 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: Rohan Young 
>> To: excel-macros@googlegroups.com
>> Sent: Tue, September 27, 2011 8:25:47 AM
>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>
>> Hi Paul,
>>
>> thanks for your help, and yes i required the latest date i.e. 22-Mar-11.
>>
>> On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner 
>> wrote:
>>> As I mentioned before,
>>> =MAX(F4:O4)
>>> will give you the maximum date.
>>>
>>> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
>>> will give you the Rev #.
>>>
>>> As far as highlighting the cells,
>>> Conditional formatting will highlight the cell with the matching date.
>>> If you really want to highlight the PREVIOUS revision, it'll take some
>>> custom coding.
>>>
>>> however,
>>>
>>> I noticed in your sample file, there are some records with multiple lines:
>>> (rows 24-41, column "H" (R1))
>>> 17-Mar-11
>>> 247-Mail
>>> 18-Mar-11
>>> 250-Hard
>>> 22-Mar-11
>>> 261-Hard
>>>
>>> which date are you looking for? since all three are in column R1...
>>> If you're expecting the 22-Mar-11 date, then it'll take some more work.
>>>
>>>
>>> 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: Rohan Young 
>>> To: excel-macros@googlegroups.com
>>> Sent: Tue, September 27, 2011 1:47:20 AM
>>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>
>>> Please see the attchment
>>>
>>> regds
>>>
>>> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1  wrote:
>>>> Can you show us an AFTER example(s) of what you want this to look like..
>>>>
>>>> -Original Message- From: Rohan Young
>>>> Sent: Monday, September 26, 2011 2:18 AM
>>>> To: excel-macros@googlegroups.com
>>>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>>
>>>> On Thu, Sep 22, 2011 at 6:04 PM, dguillett1  wrote:
>>>>>
>>>>> Can you provide an AFTER example
>>>>>
>>>>> -Original Message- From: Rohan Young
>>>>> Sent: Thursday, September 22, 2011 2:30 AM
>>>>> To: excel-macros@googlegroups.com
>>>>> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>>>
>>>>> -- Forwarded message --
>>>>> From: Rohan Young 
>>>>> Date: Tue, Jul 26, 2011 at 2:22 PM
>>>>> Subject: Required Latest No. of Drawing - Help
>>>>> To: excel-macros@googlegroups.com
>>>>>
>>>>>
>>>>> Dear Experts
>>>>>
>>>>> I want to make a list drawing in which i required only latest revision
>>>>> of drawings  it can be R3, R5, i need only latest version rest of
>>>>> previous i do not required in that list please help me out with any
>>>&g

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

[Rohan Young]

Dear Paul,

one more thing your indirect formula is not working in master sheet,
would u please explain

thanks & regds

On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner  wrote:
> Well.. the =max() function will work to get the DATE,
> but using the match() function with the multi-row produces an error.
> So, I think we need to add a column (that could be hidden) to check multiple
> rows.
>
> But, if the highlighting of PREVIOUS cells is an absolute requirement, then
> we might as well do the whole thing in a 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: Rohan Young 
> To: excel-macros@googlegroups.com
> Sent: Tue, September 27, 2011 8:25:47 AM
> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> Hi Paul,
>
> thanks for your help, and yes i required the latest date i.e. 22-Mar-11.
>
> On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner 
> wrote:
>> As I mentioned before,
>> =MAX(F4:O4)
>> will give you the maximum date.
>>
>> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
>> will give you the Rev #.
>>
>> As far as highlighting the cells,
>> Conditional formatting will highlight the cell with the matching date.
>> If you really want to highlight the PREVIOUS revision, it'll take some
>> custom coding.
>>
>> however,
>>
>> I noticed in your sample file, there are some records with multiple lines:
>> (rows 24-41, column "H" (R1))
>> 17-Mar-11
>> 247-Mail
>> 18-Mar-11
>> 250-Hard
>> 22-Mar-11
>> 261-Hard
>>
>> which date are you looking for? since all three are in column R1...
>> If you're expecting the 22-Mar-11 date, then it'll take some more work.
>>
>>
>> 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: Rohan Young 
>> To: excel-macros@googlegroups.com
>> Sent: Tue, September 27, 2011 1:47:20 AM
>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>
>> Please see the attchment
>>
>> regds
>>
>> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1  wrote:
>>> Can you show us an AFTER example(s) of what you want this to look like..
>>>
>>> -Original Message- From: Rohan Young
>>> Sent: Monday, September 26, 2011 2:18 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>
>>> On Thu, Sep 22, 2011 at 6:04 PM, dguillett1  wrote:
>>>>
>>>> Can you provide an AFTER example
>>>>
>>>> -Original Message- From: Rohan Young
>>>> Sent: Thursday, September 22, 2011 2:30 AM
>>>> To: excel-macros@googlegroups.com
>>>> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>>
>>>> -- Forwarded message --
>>>> From: Rohan Young 
>>>> Date: Tue, Jul 26, 2011 at 2:22 PM
>>>> Subject: Required Latest No. of Drawing - Help
>>>> To: excel-macros@googlegroups.com
>>>>
>>>>
>>>> Dear Experts
>>>>
>>>> I want to make a list drawing in which i required only latest revision
>>>> of drawings  it can be R3, R5, i need only latest version rest of
>>>> previous i do not required in that list please help me out with any
>>>> formula or vba code (see attachment)
>>>>
>>>> Thanks & Regds,
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> --
>>>> 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-m

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

[Rohan Young]

Dear Dguillett1,

your formula is working but some places its not working, why can u explain?

thanks

On Tue, Sep 27, 2011 at 7:27 PM, dguillett1  wrote:
> =INDEX(F36:IV36,0,MATCH(99,F36:IV36))
> =INDEX(F37:IV37,0,MATCH(99,F36:IV36))
> See attached
>
> -Original Message----- From: Rohan Young
> Sent: Tuesday, September 27, 2011 12:47 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> Please see the attchment
>
> regds
>
> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1  wrote:
>>
>> Can you show us an AFTER example(s) of what you want this to look like..
>>
>> -Original Message- From: Rohan Young
>> Sent: Monday, September 26, 2011 2:18 AM
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>
>> On Thu, Sep 22, 2011 at 6:04 PM, dguillett1  wrote:
>>>
>>> Can you provide an AFTER example
>>>
>>> -Original Message- From: Rohan Young
>>> Sent: Thursday, September 22, 2011 2:30 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>
>>> -- Forwarded message --
>>> From: Rohan Young 
>>> Date: Tue, Jul 26, 2011 at 2:22 PM
>>> Subject: Required Latest No. of Drawing - Help
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Dear Experts
>>>
>>> I want to make a list drawing in which i required only latest revision
>>> of drawings  it can be R3, R5, i need only latest version rest of
>>> previous i do not required in that list please help me out with any
>>> formula or vba code (see attachment)
>>>
>>> Thanks & Regds,
>>>
>>> --
>>>
>>>
>>> --
>>> 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
>> --
>>
&g

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

[Rohan Young]

Yes paul i need a macro please help

On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner  wrote:
> Well.. the =max() function will work to get the DATE,
> but using the match() function with the multi-row produces an error.
> So, I think we need to add a column (that could be hidden) to check multiple
> rows.
>
> But, if the highlighting of PREVIOUS cells is an absolute requirement, then
> we might as well do the whole thing in a 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: Rohan Young 
> To: excel-macros@googlegroups.com
> Sent: Tue, September 27, 2011 8:25:47 AM
> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> Hi Paul,
>
> thanks for your help, and yes i required the latest date i.e. 22-Mar-11.
>
> On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner 
> wrote:
>> As I mentioned before,
>> =MAX(F4:O4)
>> will give you the maximum date.
>>
>> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
>> will give you the Rev #.
>>
>> As far as highlighting the cells,
>> Conditional formatting will highlight the cell with the matching date.
>> If you really want to highlight the PREVIOUS revision, it'll take some
>> custom coding.
>>
>> however,
>>
>> I noticed in your sample file, there are some records with multiple lines:
>> (rows 24-41, column "H" (R1))
>> 17-Mar-11
>> 247-Mail
>> 18-Mar-11
>> 250-Hard
>> 22-Mar-11
>> 261-Hard
>>
>> which date are you looking for? since all three are in column R1...
>> If you're expecting the 22-Mar-11 date, then it'll take some more work.
>>
>>
>> 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: Rohan Young 
>> To: excel-macros@googlegroups.com
>> Sent: Tue, September 27, 2011 1:47:20 AM
>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>
>> Please see the attchment
>>
>> regds
>>
>> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1  wrote:
>>> Can you show us an AFTER example(s) of what you want this to look like..
>>>
>>> -Original Message- From: Rohan Young
>>> Sent: Monday, September 26, 2011 2:18 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>
>>> On Thu, Sep 22, 2011 at 6:04 PM, dguillett1  wrote:
>>>>
>>>> Can you provide an AFTER example
>>>>
>>>> -Original Message- From: Rohan Young
>>>> Sent: Thursday, September 22, 2011 2:30 AM
>>>> To: excel-macros@googlegroups.com
>>>> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>>
>>>> -- Forwarded message --
>>>> From: Rohan Young 
>>>> Date: Tue, Jul 26, 2011 at 2:22 PM
>>>> Subject: Required Latest No. of Drawing - Help
>>>> To: excel-macros@googlegroups.com
>>>>
>>>>
>>>> Dear Experts
>>>>
>>>> I want to make a list drawing in which i required only latest revision
>>>> of drawings  it can be R3, R5, i need only latest version rest of
>>>> previous i do not required in that list please help me out with any
>>>> formula or vba code (see attachment)
>>>>
>>>> Thanks & Regds,
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> --
>>>> 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 

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

[Rohan Young]

Hi Paul,

thanks for your help, and yes i required the latest date i.e. 22-Mar-11.

On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner  wrote:
> As I mentioned before,
> =MAX(F4:O4)
> will give you the maximum date.
>
> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
> will give you the Rev #.
>
> As far as highlighting the cells,
> Conditional formatting will highlight the cell with the matching date.
> If you really want to highlight the PREVIOUS revision, it'll take some
> custom coding.
>
> however,
>
> I noticed in your sample file, there are some records with multiple lines:
> (rows 24-41, column "H" (R1))
> 17-Mar-11
> 247-Mail
> 18-Mar-11
> 250-Hard
> 22-Mar-11
> 261-Hard
>
> which date are you looking for? since all three are in column R1...
> If you're expecting the 22-Mar-11 date, then it'll take some more work.
>
>
> 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: Rohan Young 
> To: excel-macros@googlegroups.com
> Sent: Tue, September 27, 2011 1:47:20 AM
> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> Please see the attchment
>
> regds
>
> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1  wrote:
>> Can you show us an AFTER example(s) of what you want this to look like..
>>
>> -Original Message- From: Rohan Young
>> Sent: Monday, September 26, 2011 2:18 AM
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>
>> On Thu, Sep 22, 2011 at 6:04 PM, dguillett1  wrote:
>>>
>>> Can you provide an AFTER example
>>>
>>> -Original Message- From: Rohan Young
>>> Sent: Thursday, September 22, 2011 2:30 AM
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>>>
>>> -- Forwarded message --
>>> From: Rohan Young 
>>> Date: Tue, Jul 26, 2011 at 2:22 PM
>>> Subject: Required Latest No. of Drawing - Help
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Dear Experts
>>>
>>> I want to make a list drawing in which i required only latest revision
>>> of drawings  it can be R3, R5, i need only latest version rest of
>>> previous i do not required in that list please help me out with any
>>> formula or vba code (see attachment)
>>>
>>> Thanks & Regds,
>>>
>>> --
>>>
>>>
>>> --
>>> 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

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

[Rohan Young]

Dear Experts,

This is the status of Drawing, when we received the next revision of
drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
revision the last revision  cells  should  be green highlighted, so i
can understand this drawing goes superceded, here is another change
also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
i need formula or  vba code  this  these 3 conditions, - Thanks &
Please Help - SAMPLE ATTACHED.

Regds

ROHAN

On Sat, May 28, 2011 at 3:42 PM, Rohan Young  wrote:
> Dear Ashish Ji,
>
> Please help me out on this,
>
> THANKS
>
> ROHAN
>
> On Sat, May 28, 2011 at 3:01 PM, Rohan Young  wrote:
>> waiting for reply, please
>>
>> someone can help on it
>>
>> Regd
>>
>> ROHAN
>>
>> On Sat, May 28, 2011 at 11:09 AM, Rohan Young  wrote:
>>> Dear Hanumat,
>>>
>>> Thanks a lot, its working but i required cell colours in green & how
>>> can i add this function in another file because its just sample, i
>>> have a master file with 5-7 another sheets like this - Please help
>>>
>>> Thanks & Regd
>>>
>>> ROHAN
>>>
>>>
>>>
>>> On Fri, May 27, 2011 at 8:59 PM, hanumant shinde  
>>> wrote:
>>>> Hi Rohan,
>>>>
>>>> pls see the attached. rules for this 1. after entering the date you just 
>>>> should
>>>> press "Tab" and not anyu other key like Enter or up down arrow. let me 
>>>> know if
>>>> this is wat u wanted
>>>>
>>>>
>>>>
>>>>
>>>> - Original Message 
>>>>> From: Rohan Young 
>>>>> To: excel-macros@googlegroups.com
>>>>> Sent: Fri, 27 May, 2011 9:33:41 AM
>>>>> Subject: $$Excel-Macros$$ Highlight previous revision Cells after new 
>>>>> entry of
>>>>>New Revision
>>>>>
>>>>> Dear Experts & Ashish Ji,
>>>>>
>>>>> This is the status of Drawing, when we received the next revision of
>>>>> drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
>>>>> revision the last revision  cells  should  be green highlighted, so i
>>>>> can understand this drawing goes superceded, here is another change
>>>>> also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
>>>>> i need formula or  vba code  this  these 3 conditions, - Thanks &
>>>>> Please Help - SAMPLE ATTACHED.
>>>>>
>>>>> Regds
>>>>>
>>>>> ROHAN
>>>>>
>>>>> --
>>>>>--
>>>>>-
>>>>> 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

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

[Rohan Young]

Dear Ashish Ji,

Please help me out on this,

THANKS

ROHAN

On Sat, May 28, 2011 at 3:01 PM, Rohan Young  wrote:
> waiting for reply, please
>
> someone can help on it
>
> Regd
>
> ROHAN
>
> On Sat, May 28, 2011 at 11:09 AM, Rohan Young  wrote:
>> Dear Hanumat,
>>
>> Thanks a lot, its working but i required cell colours in green & how
>> can i add this function in another file because its just sample, i
>> have a master file with 5-7 another sheets like this - Please help
>>
>> Thanks & Regd
>>
>> ROHAN
>>
>>
>>
>> On Fri, May 27, 2011 at 8:59 PM, hanumant shinde  
>> wrote:
>>> Hi Rohan,
>>>
>>> pls see the attached. rules for this 1. after entering the date you just 
>>> should
>>> press "Tab" and not anyu other key like Enter or up down arrow. let me know 
>>> if
>>> this is wat u wanted
>>>
>>>
>>>
>>>
>>> - Original Message 
>>>> From: Rohan Young 
>>>> To: excel-macros@googlegroups.com
>>>> Sent: Fri, 27 May, 2011 9:33:41 AM
>>>> Subject: $$Excel-Macros$$ Highlight previous revision Cells after new 
>>>> entry of
>>>>New Revision
>>>>
>>>> Dear Experts & Ashish Ji,
>>>>
>>>> This is the status of Drawing, when we received the next revision of
>>>> drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
>>>> revision the last revision  cells  should  be green highlighted, so i
>>>> can understand this drawing goes superceded, here is another change
>>>> also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
>>>> i need formula or  vba code  this  these 3 conditions, - Thanks &
>>>> Please Help - SAMPLE ATTACHED.
>>>>
>>>> Regds
>>>>
>>>> ROHAN
>>>>
>>>> --
>>>>--
>>>>-
>>>> 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

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

[Rohan Young]

waiting for reply, please

someone can help on it

Regd

ROHAN

On Sat, May 28, 2011 at 11:09 AM, Rohan Young  wrote:
> Dear Hanumat,
>
> Thanks a lot, its working but i required cell colours in green & how
> can i add this function in another file because its just sample, i
> have a master file with 5-7 another sheets like this - Please help
>
> Thanks & Regd
>
> ROHAN
>
>
>
> On Fri, May 27, 2011 at 8:59 PM, hanumant shinde  
> wrote:
>> Hi Rohan,
>>
>> pls see the attached. rules for this 1. after entering the date you just 
>> should
>> press "Tab" and not anyu other key like Enter or up down arrow. let me know 
>> if
>> this is wat u wanted
>>
>>
>>
>>
>> - Original Message 
>>> From: Rohan Young 
>>> To: excel-macros@googlegroups.com
>>> Sent: Fri, 27 May, 2011 9:33:41 AM
>>> Subject: $$Excel-Macros$$ Highlight previous revision Cells after new entry 
>>> of
>>>New Revision
>>>
>>> Dear Experts & Ashish Ji,
>>>
>>> This is the status of Drawing, when we received the next revision of
>>> drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
>>> revision the last revision  cells  should  be green highlighted, so i
>>> can understand this drawing goes superceded, here is another change
>>> also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
>>> i need formula or  vba code  this  these 3 conditions, - Thanks &
>>> Please Help - SAMPLE ATTACHED.
>>>
>>> Regds
>>>
>>> ROHAN
>>>
>>> --
>>>--
>>>-
>>> 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

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

[Rohan Young]

Dear Hanumat,

Thanks a lot, its working but i required cell colours in green & how
can i add this function in another file because its just sample, i
have a master file with 5-7 another sheets like this - Please help

Thanks & Regd

ROHAN



On Fri, May 27, 2011 at 8:59 PM, hanumant shinde  wrote:
> Hi Rohan,
>
> pls see the attached. rules for this 1. after entering the date you just 
> should
> press "Tab" and not anyu other key like Enter or up down arrow. let me know if
> this is wat u wanted
>
>
>
>
> - Original Message 
>> From: Rohan Young 
>> To: excel-macros@googlegroups.com
>> Sent: Fri, 27 May, 2011 9:33:41 AM
>> Subject: $$Excel-Macros$$ Highlight previous revision Cells after new entry 
>> of
>>New Revision
>>
>> Dear Experts & Ashish Ji,
>>
>> This is the status of Drawing, when we received the next revision of
>> drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
>> revision the last revision  cells  should  be green highlighted, so i
>> can understand this drawing goes superceded, here is another change
>> also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
>> i need formula or  vba code  this  these 3 conditions, - Thanks &
>> Please Help - SAMPLE ATTACHED.
>>
>> Regds
>>
>> ROHAN
>>
>> --
>>--
>>-
>> 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$$ Highlight previous revision Cells after new entry of New Revision

[Rohan Young]

Dear Experts & Ashish Ji,

This is the status of Drawing, when we received the next revision of
drawing (i.e.  we receive R1 after Ro), i need , when i enter the next
revision the last revision  cells  should  be green highlighted, so i
can understand this drawing goes superceded, here is another change
also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2,
i need formula or  vba code  this  these 3 conditions, - Thanks &
Please Help - SAMPLE ATTACHED.

Regds

ROHAN

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


Help_Highlighting Cells after next entry.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

[Rohan Young]

Thanks very much Ashish Ji & Zafar

Regds

ROHAN

On Tue, May 10, 2011 at 9:30 PM, ashish koul  wrote:

> to find total ---
>
>
> =INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0))
>
>
>
>
> On Tue, May 10, 2011 at 5:39 PM, Rohan Young  wrote:
>
>> Thanks Ashish Ji,
>>
>> as i knew that i will got the answer first from your side,  but 1 more
>> thing if i do not have column A (skilled & unskilled type), in that
>> situation what is the formula?
>>
>> please reply
>>
>> Thanks & Regds
>>
>> ROHAN
>>
>>
>> On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote:
>>
>>> =SUMPRODUCT(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
>>>
>>
>>  --
>>
>> --
>> 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$$ Total of sum of Diff. criteria according to date

[Rohan Young]

Thanks Ashish Ji,

as i knew that i will got the answer first from your side,  but 1 more thing
if i do not have column A (skilled & unskilled type), in that situation what
is the formula?

please reply

Thanks & Regds

ROHAN

On Tue, May 10, 2011 at 5:16 PM, ashish koul  wrote:

> =SUMPRODUCT(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
>

-- 
--
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$$ Total of sum of Diff. criteria according to date

[Rohan Young]

Dear Experts,

Daily updation of the status according to skilled & unskilled type labour, I
need a total sum of skilled & unskilled if I change the date only. because
total sum of these diff. criteria is use in some other different formats.

Sample file attached (for better understanding)

thanks & regds

ROHAN

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


Total Sum of Different Criteria_HELP.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet