Re: $$Excel-Macros$$ EXCELLENT MIND READING

[╰» ℓαℓιт мσαнη]

Excellent

Regards,
Lalit Mohan


On Sat, Sep 1, 2012 at 7:22 PM, Kuldeep Singh wrote:

>
> Woh!!
>
> Regards,
> Kuldeep Singh
>
>
> On Sat, Sep 1, 2012 at 10:48 PM, Rajan_Verma wrote:
>
>> * *
>>
>> *Ok*
>>
>> * I was choosing wrong color **J***
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
>> *Sent:* 01 September 2012 10:22
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ EXCELLENT MIND READING
>>
>> ** **
>>
>> It cannot give a wrong result. Look a little more closely!
>>
>> On Sat, Sep 1, 2012 at 2:39 PM, vaibhav joshi 
>> wrote:
>>
>> Hi But got it correct
>>
>> ** **
>>
>> On Sat, Sep 1, 2012 at 1:38 PM, Rajan_Verma 
>> wrote:
>>
>> *Wrong Result **J** *
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Sarika Parab
>> *Sent:* 01 September 2012 12:58
>> *To:* Reshma Shelar; gauri rane; Nishant Sakpal; Ashish Shinde //Kotak
>> /Bank; DSOUZA Snowel; excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ EXCELLENT MIND READING
>>
>>  
>>
>>  
>>
>>
>> EXCELLENT  MIND READING
>>
>> *This will drive you up the wall!!*
>>
>> *CLICK ON HOUSE**[image: Description:
>> cid:1.3658108220@web125205.mail.ne1.yahoo.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
>> 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.
>>
>>  
>>
>> --
>> 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.
>>
>>  
>>
>> ** **
>>
>> --
>> 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 perso

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

[╰» ℓαℓιт мσαнη]

Congrats Mr. expert

Regards,
Lalit Mohan


On Sun, Sep 2, 2012 at 7:58 AM, vijayajith VA wrote:

> Congrats noorain Brother..
>
>
> On Sun, Sep 2, 2012 at 11:22 AM, rao  wrote:
>
>> Congrats, u are the live wire of this group.please do continue the same.
>>
>> Cheers,
>> Prabhakar
>>
>>
>> On Sun, Sep 2, 2012 at 10:44 AM,  wrote:
>>
>>> **
>>> Congrats Noorain..
>>>
>>> Rgds
>>> Vaibhav
>>> --
>>> *From: * Ayush Jain 
>>> *Sender: * excel-macros@googlegroups.com
>>> *Date: *Sun, 2 Sep 2012 10:32:31 +0530
>>> *To: *excel-macros
>>> *ReplyTo: * excel-macros@googlegroups.com
>>> *Cc: *NOORAIN ANSARI
>>> *Subject: *$$Excel-Macros$$ Noorain Ansari - Most Helpful Member August
>>> 2012
>>>
>>> Dear members,
>>>
>>> Once again, Noorain Ansari has been selected as 'Most Helpful Member'
>>> for the month of Aug'12. He has posted 111 posts in August 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.
>>> *Noorain, please find enclosed the award certificate in honour of your
>>> contribution.*
>>>
>>> Thanks to all other folks for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>
>>  --
>> 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.co

Re: $$Excel-Macros$$ Need update on the attached Macro

[╰» ℓαℓιт мσαнη]

Just use this line of code before calling sendmail procedure

If Target.Column <> Range("N1").Column Then Exit Sub

Hope it helps you

Regards,
Lalit Mohan


On Fri, Aug 31, 2012 at 5:50 PM, Selva  wrote:

>  Hi All,
>
> ** **
>
> Need an update on the attached macro file. Based on this file, whenever
> the Column N  drop down is selected for ‘Failure’, an outlook mail
> generates and ready to be sent. If ‘Success’ is selected no mails will be
> sent. But my issue is whenever I select for ‘Failure’ in Column O. Two
> mails are being generated for Column N and for Column O. But I want to
> restrict it to one mail for that cell which I have selected only. Can any
> one help me on this?
>
> ** **
>
> Code:-
>
> ** **
>
> Sub sendEmail()
>
> ** **
>
> Dim objOL As Object
>
> Dim objMail As Object
>
> Dim sEmail As String
>
> Dim sEmailColumn As String
>
> Dim sSubject As String
>
> Dim sBody As String
>
> Dim lDataRow As Long
>
> Dim cl As Range
>
> 'Set column with email address
>
> sEmailColumn = "Z"
>
>  For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("N" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "Step A" 
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("O" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP B" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("P" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP C" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> For Each cl In Selection.Resize(, 1)
>
> 
>
> lDataRow = cl.Row
>
> 
>
> If cl.Parent.Range("Q" & lDataRow).Value = "Failure" Then
>
> With cl.Parent
>
> sEmail = .Range(sEmailColumn & lDataRow)
>
> sSubject = Range("B" & lDataRow)
>
> sBody = "URL/Test Condition: " & .Range("G" & lDataRow) &
> vbNewLine & "STEP D" & vbNewLine & ""
>
> End With
>
> 
>
> On Error GoTo Cleanup
>
> 
>
> Set objOL = CreateObject("Outlook.Application")
>
> 
>
> Set objMail = objOL.CreateItem(0)
>
> With objMail
>
> .To = sEmail
>
> .Subject = sSubject
>
> .Body = sBody
>
> .Display
>
> End With
>
> End If
>
> Next cl
>
> 

Re: $$Excel-Macros$$ Hook Chart

[╰» ℓαℓιт мσαнη]

Nice one

Regards,
Lalit Mohan


On Thu, Aug 23, 2012 at 7:29 PM, Mangesh Vimay wrote:

> Nice !!!
>
>
> On Thu, Aug 23, 2012 at 10:12 AM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
>> Gr8 work rajan .:)
>>
>> Regards,
>> Gawli Anil
>>
>> On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomotey wrote:
>>
>>> i love the chart, nice work bro
>>>
>>>
>>> On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh 
>>> wrote:
>>>

 Hi Sir,

 It's really good.

 Regards,
 Kuldeep Singh


 On Wed, Aug 22, 2012 at 9:02 PM,  wrote:

> Nice creativity Rajan
>
> Sent from BlackBerry® on Airtel
> --
> *From: *"Rajan_Verma" 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Wed, 22 Aug 2012 19:32:24 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Hook Chart
>
>  * *
>
> *Hi Group,*
>
> * *
>
> *Just sharing hook chart ,  see the attached sheet*
>
> * *
>
> * *
>
> **
>
> * *
>
> *
> any comment and suggestion are welcome ,*
>
> *You can also visit this link*
>
> http://excelpoweruser.wordpress.com/2012/08/22/hook-chart/**
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> 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.
>
>
>
> --
> 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.
>
  --
 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.

Re: $$Excel-Macros$$ All the sheet names in one sheet

[╰» ℓαℓιт мσαнη]

Dear Santosh,

I think it is not possible to get all the sheets name by using only formula.

Regards,
Lalit Mohan


On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI
 wrote:
> Dear Santosh,
>
> Please create a name range with below formula..
>
> =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
>
> and use below formula to extract sheet name in column A.
>
> =IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
>
> See attached sheet for more information.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi
>  wrote:
>>
>> Hi Group,
>>
>> I want the list of all the sheet names available or to created in sheet1
>> automatically via formula of a workbook without a macro.
>>
>> Thanks & Regards
>> Santosh
>> santoshkumar.subu...@gmail.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

2) Don't post a question in the thread of 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$$ Vlookup Problem

[╰» ℓαℓιт мσαнη]

Hi Mangesh,

If you want to learn how vlookup works may be below links helps you..

http://www.free-training-tutorial.com/function-vlookup.html
http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm


Regards,
Lalit Mohan


On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay  wrote:
> Its really helpful.
> U have done full R & D here.
> Thanks lot.
>
>
> On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI 
> wrote:
>>
>> Dear Mangesh,
>>
>> You can also use..
>>
>> =LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)
>>
>> or
>>
>> =INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))
>>
>> or
>>
>> =OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)
>>
>> with ctrl+shift+Enter
>>
>> See attached sheet.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>>
>>> Hi Friends,
>>>
>>> Please solve my VLookup Query.
>>> Description is given in attached file.
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> 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
>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
> --
> 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

Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

[╰» ℓαℓιт мσαнη]

Hi

Give this also a try.

sheet2.resize(sheet1.usedrange.rows.count,
sheet1.usedrange.columns.count).value = sheet1.usedrange.value

Regards,
Lalit Mohan


On Sat, Jul 14, 2012 at 1:12 AM, dguillett1  wrote:
> and then
> activesheet.shapes.cut
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> From: NOORAIN ANSARI
> Sent: Friday, July 13, 2012 1:47 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ VBA to copy the entire data without the button
> in the sheet
>
> Dear Vinay,
>
> Please try
> Sheets(1).copy after:=sheets(sheets.count)
>
> On Fri, Jul 13, 2012 at 9:46 PM, t vinay  wrote:
>>
>> Hi Team,
>>
>> Can any one help me with a vba code to copy the entire sheet into a new
>> one without the button in that sheet.
>>
>> thanks for your help!!
>>
>> --
>> Regards,
>>
>> Vinay. T
>>
>> --
>> 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
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

2) Don't post a question in the thread of 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$$ Re: Error Cleaning

[╰» ℓαℓιт мσαнη]

Hi,

Please attach file with sample data to make it more clear.

Regards,
Lalit Mohan


On Sat, Jul 14, 2012 at 3:11 AM, bpascal123  wrote:

> Hi,
>
> You say:
>
> I need your help again.We extract the data from database & each user got
>> some errors on different projects.I need to clean the error data to get the
>> count of errors.For this,i do text to column on error column
>
>
>  What settings do you apply for text to columns?
>
> If you first choose "Delimited" then tick "Comma" delimiters box you
> should get your error column automatically split into 3 columns which
> should then be easier to process manually or with vba if someone wants to
> code that.
>
>
> 
>
>
> Regards,
>
> Pascal Baro
> bpascal...@gmail.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$$ Error--Cant Exit Design Mode

[╰» ℓαℓιт мσαнη]

Hi,

Can u provide the file to make it more clear.

Regards,
Lalit Mohan


On Sat, Jul 14, 2012 at 1:36 AM, hanumant shinde  wrote:
> Hi friends.
>
> there is huge macro file which throws an error as "Cant exit design Mode"
> for few users at few occasions.
> we don't know when and why this error comes but it was told us that this
> error comes when we open Office 2003 file which has ActiveX control buttons
> in office 2007 version.
>
> can you provide your thoughts and feedback.
>
> Workaround:
> if we simply open the error file and save it after giving error the issue
> disappears but reappear after few days. we have no idea why is it happening.
>
>
> --
> 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$$ File opens read only on same excel instance

[╰» ℓαℓιт мσαнη]

Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will
not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write
permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right
click on the document and click properties. in the 'General' Tab see
if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using
it (If the above fixes dont work) open it up in excel and then click
File --> Save As... and then save it somewhere else. That will then
make it editable for you.



Regards,
Lalit Mohan


On Fri, Jul 13, 2012 at 8:16 PM, Divaker Pandey  wrote:
> Hi Expert,
>
> I am facing one issue with excel.
>
> I open a excel workbook xyz.xlsm, it opens without any problem.
> But when I closed only xyz.xlsm, and try to reopen it, i am getting message
> that file is in read only mode.
>
> I tried all option. but still no clue
> What problem may be. can you experts give any clue.
>
> Divaker
>
> --
> 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$$ Query- Global Variable

[╰» ℓαℓιт мσαнη]

Dear

If you want a variabler such that it will works for all the procedure
in a module use below.

dim sh as worksheet
dim rng as range

Private sub abc()

set sh = Thisworkbook.Sheets("Sheet1")
set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)

End sub


or else  If you want it access from any module try below one..

Public sh as worksheet
Public rng as range

Private sub abc()

set sh = Thisworkbook.Sheets("Sheet1")
set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)

End sub

Regards,
Lalit Mohan


On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba  wrote:
> Hi Group,
>
>
> How can i declare a global variable for below mentioned.
>
>
>
> Private sub abc()
> dim sh as worksheet
> dim rng as range
>
> set sh = Thisworkbook.Sheets("Sheet1")
> set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
>
> End sub
>
>
> In my module i have 20 procedure and in future comes many more.
> So, my query how to declare a global variable and how to call in my
> procedure.
>
> Regards,
> excelvba.lear...@gmail.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$$ Rajan Verma - Most helpful Member(June​'12)

[╰» ℓαℓιт мσαнη]

Congrats Rajan this is the third time continuously. congratulation once again

Regards,
Lalit Mohan


On Thu, Jul 5, 2012 at 6:18 PM, Rajan_Verma  wrote:
> Thank you all.. J
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Asa Rossoff
> Sent: 05 July 2012 1:39
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
>
>
>
> Extraorinary contribution, Rajan.
>
> Cheers.
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Ayush Jain
> Sent: Wednesday, July 04, 2012 9:17 AM
> To: excel-macros
> Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
>
>
>
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 posts in June 2012 and helped many people through his
> expertise.
>
> I truly appreciate his consistency and commitment to group. He is really
> doing great job.
>
>
> Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa 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
>
> 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

-- 
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$$ Macro timings should be multiple based on date changing

[╰» ℓαℓιт мσαнη]

Hi Lokesh,

Please find the attached hope it meets your specification

Regards,
Lalit Mohan


On Sat, Jun 30, 2012 at 7:32 AM, Lokesh Loki  wrote:
> Hi Lalit,
>
> Thanks for replying to my query.
>
> Actually i needed when i am changing the dates the macro timings i.e.
> 4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
> timings will added to the total timings.
>
> Examples:
>
>            Timings    Macro timings   Total timings
>              5:30:15 +  4:00:00   =   9:30:15
>  5:30:15 +  8:00:00           =  13:30:15
>  5:30:15 + 12:00:00          =  17:30:15
>  5:30:15 + 12:00:00  =  21:30:15
>
> Please refer attached excel sheet i have mentioned date wise results so do
> the needful.
>
> Regards
> Lokesh.M
>
>
> On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan 
> wrote:
>>
>> Hi Lokesh,
>>
>>
>>
>> Please find the attached. Change the formula accordingly.
>>
>>
>>
>>
>>
>> Regards,
>>
>> Lalit Mohan
>>
>> www.excelfox.com/forum
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Lokesh Loki
>> Sent: Friday, June 29, 2012 7:18 PM
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
>> changing
>>
>>
>>
>> Hi All,
>>
>> Please find the attached excel file, and i need total macro timings based
>> on date changes.
>>
>> Let me know for any clarification.
>>
>> Regards
>> Lokesh.M
>>
>> --
>> 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

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

Re: $$Excel-Macros$$ IN TROUBLE

[╰» ℓαℓιт мσαнη]

Hi Azhar,

Try this revised version...

Sub InsertColumnWithFormula()
Const lngNoOfColAs Long = 2
Dim varSheets() As Variant
Dim lngLoop As Long
Const strStartRange As String = "R1"


varSheets = Array("Sheet1", "Sheet2", "Sheet3")

Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

For lngLoop = LBound(varSheets) To UBound(varSheets)
With ThisWorkbook.Worksheets(varSheets(lngLoop))
.Range(strStartRange).Offset(, (lngNoOfCol - 1) *
-1).Resize(, lngNoOfCol).EntireColumn.Copy
.Range(strStartRange).Offset(, 1).Insert Shift:=xlToRight
End With
Next lngLoop

Application.CutCopyMode = False
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True
End Sub

Regards,
Lalit Mohan
Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 4:51 PM, NOORAIN ANSARI
 wrote:
> Dear Azhar,
>
> Please share sample workbook with Group.
>
>
> On Fri, Jun 29, 2012 at 4:38 PM, Azhar Rai  wrote:
>>
>> Hello Dear Gurus
>>
>> I want to add columns in an excel sheet between R and AQ to be total in
>> number as in cell H5 and I also want this to be replicated in sheet2,
>> sheet3, and sheet4 and these columns  should also carry the formula from
>> column R.
>>
>> Gurus please help me.
>>
>> Thanks
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

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

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

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

[╰» ℓαℓιт мσαнη]

Hi,

Try this also

=A1&" "&B1&" "&C1

Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI
wrote:

> Dear Moti Lal,
>
> You can use below UDF for dynamically
>
> Function combine_cells(rng As Excel.Range) As String
> Dim cell As Excel.Range
> For Each cell In rng.Cells
> combine_cells = combine_cells + CStr(cell.Value) & Chr(10)
> Next cell
> End Function
>
> see attached sheet
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Fri, Jun 29, 2012 at 9:18 PM, jmothilal  wrote:
>
>> Dear any one
>>
>> I want 3 cell values in 1 cell line by line
>>
>> Thanks in advance
>>
>> like
>>
>>  MOTHILAL
>> NAVEEN
>> RAJA MOTHILAL NAVEEN RAJA
>>
>> --
>>
>> *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$$ Help in Access

[╰» ℓαℓιт мσαнη]

Hi Manoj,

Try this

select [store id] from [Acer All Data] group by [store id]
select [store id] from [Apr'12] group by [store id]
select [store id] from [Mar'12] group by [store id]
select [store id] from [May'12] group by [store id]

Regards,
Lalit Mohan


On Fri, Jun 29, 2012 at 3:14 PM, Manoj Kumar  wrote:
> Dear Experts,
>
>
> I have data in month wise data in Access in different query..
> Please help me to find unique id From DATA in attached file..
>
>
>
> Regard
> Manoj
>
> --
> 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$$ Re: Delete Blank Cells.xlsx

[╰» ℓαℓιт мσαнη]

Hi Prince,

Sorry for asking but could you please explain the deference in both of
your solution.

Regards,
Lalit Mohan


On Wed, Jun 27, 2012 at 8:32 AM, Prince Dubey  wrote:
> Hi Vishwa,
>
>
> Try This
>
>
>
> Public Sub DeleteWeekends()
>     Dim rng As Range
>     Dim rngData As Range
>
>     With ThisWorkbook.Worksheets("Sheet1")
>     Set rngData = .Range("A1:A" & .Range("A" &
> .Rows.Count).End(xlUp).Row)
>     For Each rng In rngData
>     If Application.WorksheetFunction.Text(rng.Value, "DDD") = "Sat"
> Or Application.WorksheetFunction.Text(rng.Value, "DDD") = "Sun" Then
>     rng.Value = ""
>     End If
>     Next
>     End With
>     rngData.SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
> End Sub
>
>
>
> Regards
> Prince Dubey.
>
>
>
>
>
> On Wednesday, 27 June 2012 00:46:00 UTC+5:30, Viswanathan Yoganathan wrote:
>>
>> Hi all,
>>
>>
>>
>> In the attached excel, I want to delete the week ends whereas at the same
>> time the position of the month should not move.  It means the Feb month
>> should start from A34, March month should start from A64.  Please advise
>> using VBA macro.
>>
>>
>>
>> Thanks,
>>
>> Vishwa
>>
>> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
>> and may also be privileged. If you are not the intended recipient of this
>> e-mail you may not copy, forward, disclose or otherwise use it or any part
>> of it in any form whatsoever. If you are not the intended recipient please
>> telephone or e-mail the sender and delete this message and any attachment
>> from your system."
>
>
> On Wednesday, 27 June 2012 00:46:00 UTC+5:30, Viswanathan Yoganathan wrote:
>>
>> Hi all,
>>
>>
>>
>> In the attached excel, I want to delete the week ends whereas at the same
>> time the position of the month should not move.  It means the Feb month
>> should start from A34, March month should start from A64.  Please advise
>> using VBA macro.
>>
>>
>>
>> Thanks,
>>
>> Vishwa
>>
>> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
>> and may also be privileged. If you are not the intended recipient of this
>> e-mail you may not copy, forward, disclose or otherwise use it or any part
>> of it in any form whatsoever. If you are not the intended recipient please
>> telephone or e-mail the sender and delete this message and any attachment
>> from your system."
>
> --
> --
> 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$$ Label record sheet

[╰» ℓαℓιт мσαнη]

HI,

Can you please explain it more actually the requirement is not clear.

Regards,
Lalit Mohan


On Wed, Jun 27, 2012 at 1:33 PM,   wrote:
> Dear all experts
>
>
>
> I’ve some questions about functions on the sheet, I made the sheet, So it
> use for record the label for production
>
>
>
> I tried and tried to do with many fomular, but the results are not OK L
>
>
>
> I posted that sheet for all, Please discipline for me
>
>
>
> Very thanks
>
>
>
> Rdgs
>
>
>
> Attapan Chainarongboon
>
> Production control Dept (Compressor)
>
> Calsonic Kansei (Thailand)
>
> E-mail : attapan_chainarongb...@ck-mail.com
>
> Phone : (+66) 038-210-129 #101
>
> Mobile phone: (+66) 086-824-5045
>
>
>
> --
> --
> 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$$ VBA editor auto-deletes spaces at the ends of lines

[╰» ℓαℓιт мσαнη]

Thanks Rajan for your great help.

Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 8:47 PM, Rajan_Verma  wrote:
>
> Download this book .
>
> http://freedownload.is/pdf/the-vsto-programming-model-3812060.html
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of ?» lal?? ?sa??
> Sent: 26 June 2012 8:35
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of 
> lines
>
> Hi Rajan,
>
> I also want to learn how to build and use VSTO so if u found something  
> related to this please let me know.
>
> Regards,
> Lalit Mohan
>
>
> On Tue, Jun 26, 2012 at 8:29 PM, ╰» ℓαℓιт мσαнη  
> wrote:
>> Hi Rajan,
>>
>> Actually i faced this issue while doing vba programming. These are
>> just steps to resolve the same.
>>
>> Regards,
>> Lalit Mohan
>>
>>
>> On Tue, Jun 26, 2012 at 8:24 PM, Rajan_Verma  
>> wrote:
>>> Lalit Can you give the example .? I have vsto on my system,
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Rajan verma
>>>
>>> +91 7838100659 [IM-Gtalk]
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Lalit_Mohan
>>>
>>>
>>> Sent: 26 June 2012 8:20
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends
>>> of lines
>>>
>>>
>>>
>>> Today i faced an issue with excel 2010. if u have installed Visual
>>> Studio
>>> 2010 beta2 then VBA editor auto-deletes spaces at the ends of lines
>>> so below are the steps which helps me to resolve this.
>>>
>>> Click the Microsoft Office Button, and then click Excel Options Click
>>> the Add-Ins category In the Manage box, click COM Add-ins, and then
>>> click Go.
>>> Look for an add in called 'Load Test Report AddIn' then uncheck it
>>> restart excel
>>>
>>>      This addin is installed with VS2010 Beta2
>>>
>>> --
>>> --
>>> 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
>&g

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

[╰» ℓαℓιт мσαнη]

Hi Rajan,

I also want to learn how to build and use VSTO so if u found something
 related to this please let me know.

Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 8:29 PM, ╰» ℓαℓιт мσαнη
 wrote:
> Hi Rajan,
>
> Actually i faced this issue while doing vba programming. These are
> just steps to resolve the same.
>
> Regards,
> Lalit Mohan
>
>
> On Tue, Jun 26, 2012 at 8:24 PM, Rajan_Verma  wrote:
>> Lalit Can you give the example .? I have vsto on my system,
>>
>>
>>
>>
>>
>> Regards
>>
>> Rajan verma
>>
>> +91 7838100659 [IM-Gtalk]
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Lalit_Mohan
>>
>>
>> Sent: 26 June 2012 8:20
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of
>> lines
>>
>>
>>
>> Today i faced an issue with excel 2010. if u have installed Visual Studio
>> 2010 beta2 then VBA editor auto-deletes spaces at the ends of lines so below
>> are the steps which helps me to resolve this.
>>
>> Click the Microsoft Office Button, and then click Excel Options
>> Click the Add-Ins category
>> In the Manage box, click COM Add-ins, and then click Go.
>> Look for an add in called 'Load Test Report AddIn' then uncheck it
>> restart excel
>>
>>  This addin is installed with VS2010 Beta2
>>
>> --
>> --
>> 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$$ VBA editor auto-deletes spaces at the ends of lines

[╰» ℓαℓιт мσαнη]

Hi Rajan,

Actually i faced this issue while doing vba programming. These are
just steps to resolve the same.

Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 8:24 PM, Rajan_Verma  wrote:
> Lalit Can you give the example .? I have vsto on my system,
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Lalit_Mohan
>
>
> Sent: 26 June 2012 8:20
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of
> lines
>
>
>
> Today i faced an issue with excel 2010. if u have installed Visual Studio
> 2010 beta2 then VBA editor auto-deletes spaces at the ends of lines so below
> are the steps which helps me to resolve this.
>
> Click the Microsoft Office Button, and then click Excel Options
> Click the Add-Ins category
> In the Manage box, click COM Add-ins, and then click Go.
> Look for an add in called 'Load Test Report AddIn' then uncheck it
> restart excel
>
>  This addin is installed with VS2010 Beta2
>
> --
> --
> 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$$ MY NEW EXCEL DASHBOARD PROJECTS

[╰» ℓαℓιт мσαнη]

Nice work Hilary..
Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 7:17 PM, Rajan_Verma  wrote:
> Hi deba..
>
> Actually the "BLPLinkReset" is a macro which was called at the time of
> Recording this macro.
>
>
>
> Hi Hilary..
>
>
>
> You can put the  code of "BLPLinkReset" in your dashboard. So that  any one
> can use this ( if needed)
>
>
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Deba Ranjan
> Sent: 26 June 2012 3:59
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS
>
>
>
> Dear hilary,
>
>   its awesome Dashboard, keep it up.
>
>  I show in the Macro code, hence i notice you have used many times this -
> Application.Run "BLPlinkReset"
>   May i know what it is ?
>
>  And even in the Account Setup sheet, if i try to create a account, it
> doesn't allow to create, shows errors in coding debug- Application.Run
> "BLPlinkReset"
>
> Explain Please 
>
>
>
> Thanks & Regards,
> Deba Ranjan P
>
>
>
>
>
> On Tue, Jun 26, 2012 at 3:37 PM, hilary lomotey  wrote:
>
> Hi Amit
>
>
>
> Click on the column header you want to hide, in my case column H, which will
> highlight the whole column and hold ctrl + shift + forward arrow key , right
> click and select hide, same is true for the row headers. thanks
>
>
>
> On Tue, Jun 26, 2012 at 9:54 AM, Amit Gandhi  wrote:
>
> Nice Creativity Hilary
>
>
>
> As I am new to these things, can I know how you Freezed Columns A to G and
> Rows 1 to 18 (and others Column & Row headers are not showing)? How you
> freezed scrolling thereafter?
>
>
>
> Regards
>
>
>
> Amit
>
>
>
> On Mon, Jun 25, 2012 at 7:41 PM, hilary lomotey  wrote:
>
> Hello Guys
>
>
>
> i just completed my two excel projects and want to share. The first one is
> like an accounting system where you can enter clients information as well as
> transactions and post it to a database and also able to retrieve the
> information. Since i am not good with VBA , i used macro recording
> techniques to achieve these as well as of course formula's. Try it out and
> have fun and hope someone can improve upon it and give feedback. the pass
> word on the file is 'kiss"
>
> The second is a fixed income dashboard, its easy to understand when you test
> how it works,
>
>
>
> keep excelling cos excel is fun, have a great day.
>
> --
> -- 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
>
>
>
>
>
> --
> 'Expecting the world to treat u fairly coz u r a good person is like
> expecting the lion not to attack u coz u r a vegetarian.
> Think about it.'
>
> Take care
>
> Amit
>
> --
> -- 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-promotio

Re: $$Excel-Macros$$ Problem with excel

[╰» ℓαℓιт мσαнη]

Hi Divaker,

You query is not cleary mentioned can u please share a file with the
full description so that we can help u as soon as possible

Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey  wrote:
> Hi Experts,
>
> Still waiting for your response.
>
> Divaker
>
>
> On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey  wrote:
>>
>> Hi Noorain & Experts,
>>
>> Thanks for respond. please find attached file.
>> on tab sheet1 there is two activeX control
>>
>> 1. Textbox -txtLookup
>> 2. ListBox - lstLookup
>>
>> if user change value of textbox it search the input string in each column.
>> and add in listbox all rows which string matched.
>>
>> I want to add headers.
>>
>> Please suggest asap.
>>
>>
>> Divaker
>>
>>
>> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI 
>> wrote:
>>>
>>> Dear Divaker,
>>>
>>> Please share your Activelistbox with group.
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey 
>>> wrote:
>>> > Hi Ayush,
>>> >
>>> > I want to add header column text in Activelistbox through vba.
>>> >
>>> > Can you help me how i can add.
>>> >
>>> >
>>> > Thanks.
>>> >
>>> > Divaker
>>> >
>>> > --
>>> > -- 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
>
>

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

Re: $$Excel-Macros$$ Re: delete blank columns

[╰» ℓαℓιт мσαнη]

You can try this also

on error resume next
activesheet.specialcells(xlcelltypeblank).usedrange.entirecolumn.delete
on error goto 0: on error goto -1: err.clear


Regards,
Lalit Mohan


On Tue, Jun 26, 2012 at 7:09 PM, Rajan_Verma  wrote:
> Try this
>
> Sub delete_blankcolumn()
> Dim col a range
>    With ActiveSheet
>        For Each col In .UsedRange.Columns
>              If WorksheetFunction.CountA(col) = 0 Then
>                   col.Delete
>              End If
>        Next
>    End With
> End Sub
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of NOORAIN ANSARI
> Sent: 26 June 2012 12:23
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Re: delete blank columns
>
> Please use it for blank column
>
> Sub delete_blankcolumn()
>    Dim i As Long
>    With ActiveSheet
>        For i = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
>              If WorksheetFunction.CountA(.Columns(i)) = 0 Then
>                   ActiveSheet.Columns(i).Delete
>              End If
>        Next
>    End With
> End Sub
>
>
> On Tue, Jun 26, 2012 at 12:17 PM, NOORAIN ANSARI 
> wrote:
>> Hi Smitha,
>>
>> you can also try it
>>
>> Sub delete_blankcell()
>>    Dim i As Long
>>    With ActiveSheet
>>        For i = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step
>> -1
>>              If WorksheetFunction.CountA(.Rows(i)) = 0 Then
>>                   ActiveSheet.Rows(i).Delete
>>              End If
>>        Next
>>    End With
>> End Sub
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Tue, Jun 26, 2012 at 12:01 PM, Anil Gawli 
> wrote:
>>> select the column & press Ctlr+g and go to blank and then press Alt+E
>>> D and select row and delete .
>>>
>>> Regards,
>>> Gawli Anil
>>>
>>> On Tue, Jun 26, 2012 at 11:34 AM, Prince Dubey
>>> 
>>> wrote:

 Hi Smitha,

 Please use this Macro hope this help you.

 Public Sub DeleteBlankCols(strSheetName As String, strRange As
 String)

     Dim intCount    As Integer
     Dim rng As Range

     With ThisWorkbook.Worksheets(strSheetName)
     Set rng = .Range(strRange)
     For intCount = 1 To rng.Columns.Count
     If
 Application.WorksheetFunction.CountA(rng.Columns(intCount))
 <> 0 Then
     rng.Columns(intCount).Delete
     End If
     Next
     End With

 End Sub



 On Friday, 15 June 2012 11:11:12 UTC+5:30, Smitha S R wrote:
>
> How to delete all blank columns arising between various rows and
> columns?

 --
 -- 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,
>>> Gawli Anil Narayan
>>> Software Developer,
>>> Abacus Software Services 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 To unsubscribe, send a blank email
>>> to excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacrow

Re: $$Excel-Macros$$ Join Sql statement in VB using ADODB

[╰» ℓαℓιт мσαнη]

Try this

Sub Get_Vessel_Schedule()

Dim cn  As ADODB.Connection
Dim rs  As ADODB.Recordset
Dim strSql  As String

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset

cn.Open ( _
"User ID=User" & _
";Password=Pass" & _
";Data Source=My DB" & _
";Provider=MSDAORA.1")

strSql = ""
strSql = strSql & vbLf & "select VESSEL.CODE, VESSEL.NAME,
VV_VESSEL_VISIT.VESSEL_ID, VV_VESSEL_VISIT.ARR_VOYAGE,"
strSql = strSql & vbLf & "VV_VESSEL_VISIT.DEP_VOYAGE,
VV_VESSEL_VISIT.BERTH, VV_VESSEL_VISIT.MPH,"
strSql = strSql & vbLf & "VV_VESSEL_VISIT.ESC_FORWARD_DRAFT,
VV_VESSEL_VISIT.ATA, VV_VESSEL_VISIT.ATD,"
strSql = strSql & vbLf & "VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD
from VV_VESSEL_VISIT"
strSql = strSql & vbLf & "join"
strSql = strSql & vbLf & "VESSEL on VV_VESSEL_VISIT.VESSEL_ID=VESSEL.ID"

rs.Open strSql, cn


Cells(6, 6).CopyFromRecordset rs

End Sub

Regards,
Lalit Mohan


On Sat, Jun 23, 2012 at 5:44 AM, TJ  wrote:
> Hello,
>
> Super new to thsi world but trying to put something together that will
> execute a simple SQL statement against on of our Oracle Databases and return
> the results.  The Code for the Macro is below but I am getting "Data Type is
> not Supported".  Anyone help with that.  Also, another question which may be
> simple sytax I do nto know, what is a good mechanism to break out the SQL
> statments accross various lines instead of one line?
>
> BTW, using Excel 2010.
>
> Thanks In Advance.
>
>
> Sub Get_Vessel_Schedule()
>
> Dim cn As ADODB.Connection
> Dim rs As ADODB.Recordset
>
> Set cn = New ADODB.Connection
> Set rs = New ADODB.Recordset
>
> cn.Open ( _
>     "User ID=User" & _
>     ";Password=Pass" & _
>     ";Data Source=My DB" & _
>     ";Provider=MSDAORA.1")
>
> rs.Open "select VESSEL.CODE, VESSEL.NAME, VV_VESSEL_VISIT.VESSEL_ID,
> VV_VESSEL_VISIT.ARR_VOYAGE, VV_VESSEL_VISIT.DEP_VOYAGE,
> VV_VESSEL_VISIT.BERTH, VV_VESSEL_VISIT.MPH,
> VV_VESSEL_VISIT.ESC_FORWARD_DRAFT, VV_VESSEL_VISIT.ATA, VV_VESSEL_VISIT.ATD,
> VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD from VV_VESSEL_VISIT join VESSEL on
> VV_VESSEL_VISIT.VESSEL_ID=VESSEL.ID", cn
>
>
> Cells(6, 6).CopyFromRecordset rs
>
> End Sub
>
>
>
> --
> -- 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$$ Dynamic List range for Data validation

[╰» ℓαℓιт мσαнη]

Give a try to this link..

http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Thu, May 17, 2012 at 11:07 AM, Seraj Alam  wrote:
> Hi,
>
> U can use this formula in data validation for dynamic range
>
> =OFFSET($A$1,0,0,COUNTA(A:A),1)
>
> And also find the attached sheet with example hope it will help you what u
> are looking for
>
>
>
>
> On Wed, May 16, 2012 at 9:21 PM,  wrote:
>>
>> Dear all,
>>
>> I want to create a list in data validation which take a dynamic range in
>> alphabetic order. Can it be possible I have tried to find it google but
>> could not solve this though have got solutions!
>>
>> Please help like you help us with indirect function module!
>>
>> Sandeep Chhajer.
>> Sent on my BlackBerry® from Vodafone
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> --
> Thanks & Regards
> Seraj Alam
> +91 989 130 1776
>
> --
> 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$$ Re: Charts

[╰» ℓαℓιт мσαнη]

Give a try to this link

http://www.mrexcel.com/archive/Chart/index.html


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Wed, May 16, 2012 at 6:28 PM, dguillett1  wrote:
> http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMpositiondatalabels
>
> http://www.techrepublic.com/article/make-your-excel-charts-easier-to-read-with-custom-data-labels/6145493
>
> http://www.ozgrid.com/forum/showthread.php?t=53916
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> From: joseph camill
> Sent: Tuesday, May 15, 2012 2:43 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re: Charts
>
> example attached
>
> On Sat, May 5, 2012 at 10:02 AM,  wrote:
>>
>> Hi,
>>
>> I create a lot of stacked charts and I spend a lot of time formatting the
>> overlapped numbers.
>>
>> I need a macro that will move numbers that overlap other numbers in a
>> stacked chart.
>>
>> Thanks,
>> Joseph
>> Sent on my BlackBerry® from Vodafone
>
>
> --
> 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$$ Time Difference

[╰» ℓαℓιт мσαнη]

Dear Mangesh

PFA

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Wed, May 16, 2012 at 6:48 PM, Mangesh Dayne  wrote:
> Hi,
>
> Thanks for your great help.
> In vba code,
> Range("C11").Value = Range("C10") + 0.2916667
> why did you have taken  0.2916667  value and many other in formula.
> Please explain the logic behind it.
>
>
> Thanks
>
> Mangesh
>
>
> On Wed, May 16, 2012 at 6:43 PM, Maries  wrote:
>>
>> Hi,
>>
>> Find the attachments..
>>
>> --
>>
>>   MARIES
>> Excel Inspiration
>>
>> --
>> 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


Time_Difference Solved(Lalit Mohan).xlsm
Description: Binary data

Re: $$Excel-Macros$$ IF Function

[╰» ℓαℓιт мσαнη]

Dear Smitha,


You can try this accordingly


If condition1 = true and condition2 = true and condition3 = true then
   'Your code here
else
   'Your code here
end if

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Wed, May 16, 2012 at 4:44 PM, Naresh V  wrote:
> Hi Smitha,
>
>    Can you please send sample file. So that we can help you. In
> If function you can add any function.
>
> Thanks,
> Naresh V
>
>
>
>
>
> On Wed, May 16, 2012 at 7:11 AM, Smitha S R  wrote:
>>
>> How can we add so many conditions in IF  function?
>>
>> --
>> 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$$ Re: help required for creating a formula

[╰» ℓαℓιт мσαнη]

Dear Ashish

PFA

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Wed, May 16, 2012 at 3:27 PM, CoRe  wrote:
> Hello,
>
> PFA!
>
>
>
> On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
>>
>> Dear All,
>>
>> I have a list of industry in one column and in corresponding column
>> the rates as per industry are given. I want to create a formula
>> whereby when i selected a specific industry from the dropdown list
>> automatically the corresponding rate is displayed in next cell. I am
>> enclosing my worksheet.
>>
>> Please help me.
>>
>> Thanks all in advance.
>>
>> --
>> Thanking you.
>>
>> With regards,
>>
>> Ashish Damor
>
> --
> 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


exp_CoRe Solved(Lalit Mohan).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[╰» ℓαℓιт мσαнη]

Dear Indrajit

range("A1").value = WorksheetFunction.VlOOKUP(lookup_value,
table_array, col_index_num, [range_lookup)

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Mon, May 14, 2012 at 7:54 PM, ╰» ℓαℓιт мσαнη
 wrote:
> Dear  Indrajit
>
> range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value,
> table_array, col_index_num, [range_lookup)
>
>
> same for the other formula
>
>
> Regards,
> Lalit Mohan
> https://www.facebook.com/buzinesstransformation
>
>
> On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai  
> wrote:
>> Thanks for the suggestion.I know the formula, but how can I migrate
>> those formulas with VBA Coding.
>>
>>
>>
>>
>> On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
>> wrote:
>>>
>>> Hi
>>>
>>> You can refer Excel Formula Help to understand how they work J
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Rajan verma
>>>
>>> +91 7838100659 [IM-Gtalk]
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Indrajit $nai
>>> Sent: 14 May 2012 3:53
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
>>> Coading
>>>
>>>
>>>
>>>
>>> Hi All,
>>>
>>>
>>>
>>> Can anyone explain how to use Vlookup, Index, Match, Offset function in
>>> VBA Coading
>>>
>>>
>>>
>>> --
>>> Indrajit
>>>
>>> Disclaimer:
>>> This electronic message and any files transmitted with it are confidential
>>> and intended solely for the use of the individual or entity to whom they are
>>> addressed. If you are not the intended recipient you are hereby notified
>>> that any disclosure, copying, distribution or taking any action in reliance
>>> on the contents of this information is strictly prohibited and may be
>>> unlawful.
>>>
>>> --
>>> 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
>>
>>
>>
>>
>> --
>> Indrajit Snai
>> +91 9051755745
>> talk2indra...@gmail.com
>>
>> Disclaimer:
>> This electronic message and any files transmitted w

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[╰» ℓαℓιт мσαнη]

Dear  Indrajit

range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value,
table_array, col_index_num, [range_lookup)


same for the other formula


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai  wrote:
> Thanks for the suggestion.I know the formula, but how can I migrate
> those formulas with VBA Coding.
>
>
>
>
> On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
> wrote:
>>
>> Hi
>>
>> You can refer Excel Formula Help to understand how they work J
>>
>>
>>
>>
>>
>>
>>
>> Regards
>>
>> Rajan verma
>>
>> +91 7838100659 [IM-Gtalk]
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Indrajit $nai
>> Sent: 14 May 2012 3:53
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
>> Coading
>>
>>
>>
>>
>> Hi All,
>>
>>
>>
>> Can anyone explain how to use Vlookup, Index, Match, Offset function in
>> VBA Coading
>>
>>
>>
>> --
>> Indrajit
>>
>> Disclaimer:
>> This electronic message and any files transmitted with it are confidential
>> and intended solely for the use of the individual or entity to whom they are
>> addressed. If you are not the intended recipient you are hereby notified
>> that any disclosure, copying, distribution or taking any action in reliance
>> on the contents of this information is strictly prohibited and may be
>> unlawful.
>>
>> --
>> 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
>
>
>
>
> --
> Indrajit Snai
> +91 9051755745
> talk2indra...@gmail.com
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
> 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 qu

Re: $$Excel-Macros$$ amend in macro

[╰» ℓαℓιт мσαнη]

Dear Aamir

You can use this also..

Sub Sheet1Multiplecopy()

Dim noOfSheet   As Long
Dim strTEmp As String
Dim lngLoop As Long

On Error Resume Next
strTEmp = InputBox("Enter no of Sheets:-", "Sheet Number")
On Error GoTo 0: On Error GoTo -1: Err.Clear

noOfSheet = IIf(IsNumeric(strTEmp), strTEmp, 0)
If noOfSheet > 0 Then
For lngLoop = 1 To noOfSheet
Sheets("Sheet1").Copy After:=Sheets(lngLoop)
ActiveSheet.Name = lngLoop
Next lngLoop
End If

End Sub


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Sun, May 13, 2012 at 2:07 AM, dguillett1  wrote:
> Sub Sheet1Multiplecopy()
> Dim i As Long
> For i = 1 To InputBox("howmany")
> Sheets("Sheet1").Copy After:=Sheets(i)
> ActiveSheet.Name = i
> Next i
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> From: Aamir Shahzad
> Sent: Saturday, May 12, 2012 2:40 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ amend in macro
>
> error reflecting, see the attached snapshot.
>
> On Sun, May 13, 2012 at 12:13 AM, dguillett1  wrote:
>>
>> For i = 1 To inputbox(“how many”)
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>> From: Aamir Shahzad
>> Sent: Saturday, May 12, 2012 1:51 PM
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ amend in macro
>>
>> Dear Group,
>>
>> Following macro provided by anyone in this forum & this code is working
>> fine but I want to amend into this coding e.g. when run this code it should
>> ask by msg box "How many sheets do you want to add?" then take the input e.g
>> 10 or any number then add sheets which given by user. Kindly do the needful.
>> Thanks in advance.
>>
>> Sub Sheet1Multiplecopy()
>> Dim i As Integer
>> i = 1
>> For i = 1 To 100
>> Sheets("Sheet1").Select
>> Sheets("Sheet1").Copy After:=Sheets(i)
>> ActiveSheet.Name = i
>> Next
>> End Sub
>>
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>>
>> --
>> 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
>
>
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
>
> --
> 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, Formu

Re: $$Excel-Macros$$ Attendance tracking

[╰» ℓαℓιт мσαнη]

Hi Yogananda

I test this file so many times but didn't get this kind of situation,
so please whenever you get this situation then send me the file with
the explanation.


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Fri, May 11, 2012 at 11:06 PM, yogananda muthaiah
 wrote:
> Hi Lalit
>
> There is some bug in resigned sheet where employee code doesn't match some
> times in tracker sheet,
>
> can u pls check and resolve
>
>
> -- Forwarded message --
> From: ╰» ℓαℓιт мσαнη 
> Date: Sun, May 6, 2012 at 5:50 PM
> Subject: Re: $$Excel-Macros$$ Attendance tracking
> To: excel-macros@googlegroups.com
>
>
> Hi,
>
> PFA
>
> Regards,
> Lalit Mohan
> https://www.facebook.com/buzinesstransformation
>
>
>
> On Sun, May 6, 2012 at 6:32 AM, yogananda muthaiah
>  wrote:
>>
>> Hi,
>>
>> Require your help.
>>
>>
>> -- Forwarded message --
>> From: yogananda muthaiah 
>> Date: Sat, May 5, 2012 at 10:25 PM
>> Subject: Re: $$Excel-Macros$$ Attendance tracking
>> To: excel-macros@googlegroups.com, mohan.pande...@gmail.com
>>
>>
>> Hi
>>
>> Do help anyone.
>>
>>
>> On Sat, May 5, 2012 at 8:48 AM, yogananda muthaiah
>>  wrote:
>>>
>>> Hi Lalit,
>>>
>>> I would really thank you for doing excellent work for last 2 weeks back.
>>> Once again i would like you to thank for your support provided in little
>>> time.
>>>
>>> Now we have different method of my requirement to see how it works .
>>> Please help me to do this way
>>>
>>>
>>>
>>>
>>> On Sat, May 5, 2012 at 8:44 AM, ╰» ℓαℓιт мσαнη 
>>> wrote:
>>>>
>>>> Hi yogannada,
>>>>
>>>> i have done someting similar before 2 weeks
>>>>  PFA and check if it works for you
>>>>
>>>> Regards,
>>>> Lalit Mohan
>>>> https://www.facebook.com/buzinesstransformation
>>>>
>>>>
>>>>
>>>> On Sat, May 5, 2012 at 7:24 AM, yogananda muthaiah
>>>>  wrote:
>>>>>
>>>>> Hi Experts
>>>>>
>>>>> Need your assistance for resolving my 2 requirements in attached file
>>>>>
>>>>>
>>>>> My Requirements are as follows
>>>>>
>>>>> 1)  Holiday List sheet as list of holidays as per locations -  Need a
>>>>> macro to update in Tracker Sheet as H to lookup from Holiday Sheet
>>>>>
>>>>>  ( Module 2 as VBA code written which needs to be altered)
>>>>>
>>>>> 2)  If i update in cell G10 as 1 it should give a result as AL , M10 as
>>>>> 2 it should  give result as CL ... etc as per above table
>>>>>
>>>>> Give a VBA code script where if i enter 1 it should auto update as AL
>>>>> or CL
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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, Urgen

Re: $$Excel-Macros$$ query

[╰» ℓαℓιт мσαнη]

Hi Aamir,

You can use SUBTOTAL formula accordingly.

for ex.:

Sum of visible cells :-   =SUBTOTAL("A1:A100",109)


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad  wrote:
> Dear Group,
>
>
>
> How to pick the values by formula of visible cells only?
>
>
>
> Regards,
>
>
> Aamir Shahzad
>
>
> --
> 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$$ Running text in excel

[╰» ℓαℓιт мσαнη]

Hi

PFA

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki  wrote:
> Hi Experts.
>
> I am waiting for your reply.
>
> Regards
> Lokesh
>
>
> On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki 
> wrote:
>>
>> Hi Rajan,
>>
>> Yes you have sent, but it's not working.If you dont mind can u please send
>> me with the solution excel file.
>>
>> So that i would help me a lot.
>>
>> Regards
>> Lokesh.M
>>
>>
>> On Fri, May 11, 2012 at 9:25 PM, Rajan_Verma 
>> wrote:
>>>
>>> Hi Lokesh
>>>
>>> I have sent you a file.. that has an embedded Internet Control ,,
>>>
>>> Is that not working for you ?
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Rajan verma
>>>
>>> +91 7838100659 [IM-Gtalk]
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki
>>> Sent: 11 May 2012 9:21
>>> To: excel-macros@googlegroups.com
>>> Subject: Fwd: $$Excel-Macros$$ Running text in excel
>>>
>>>
>>>
>>> Hi All,
>>>
>>> When the macro is running mode for the below excel file i can't able to
>>> edit the cells. The file becomes hang.
>>>
>>> So could you please resolve the hang option in the file and just text
>>> only runs.So that i can able to edit the other cells.
>>>
>>> Waiting for your reply. Thanks in advance experts.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>> -- Forwarded message --
>>> From: Lokesh Loki 
>>> Date: Thu, May 10, 2012 at 1:34 PM
>>> Subject: Re: $$Excel-Macros$$ Running text in excel
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Hi Noorain,
>>>
>>> Thanks a lot for helping me on this running text query. Once again thanks
>>> a lot.
>>>
>>> But when i am opened the running text excel file it gets hang, i can't
>>> table to edit the other cells.
>>>
>>> So please remove the hang option in the file and provide me editing
>>> option in cells.
>>>
>>>
>>> Regrards
>>> Lokesh M
>>>
>>>
>>>
>>> On Wed, May 9, 2012 at 8:46 PM, NOORAIN ANSARI 
>>> wrote:
>>>
>>> Dear Lokesh,
>>>
>>>
>>>
>>> Please see attached sheet.
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>>
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>>
>>> On Wed, May 9, 2012 at 8:00 PM, Lokesh Loki 
>>> wrote:
>>>
>>> Hi Rajan,
>>>
>>> I did not get any results in the below link, could you please provide me
>>> the solution with the attached excel sheet.
>>>
>>> Its great for me to understand.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>>
>>>
>>> On Wed, May 9, 2012 at 7:50 PM, Rajan_Verma 
>>> wrote:
>>>
>>>
>>>
>>> Follow this Link
>>>
>>> http://www.excelvbamacros.com/2012/04/adding-marquee-on-excel-worksheet.html
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Rajan verma
>>>
>>> +91 7838100659 [IM-Gtalk]
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com
>>> [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki
>>> Sent: 09 May 2012 7:33
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Running text in excel
>>>
>>>
>>>
>>> Hi Experts,
>>>
>>> I have one small query i need a macro or else formula for running text in
>>> excel.
>>>
>>> Please help on us and do the needful.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>> --
>>> 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

Re: $$Excel-Macros$$ Name Manager

[╰» ℓαℓιт мσαнη]

Hi,


By using names, you can make your formulas much easier to understand
and maintain. You can define a name for a cell range, function,
constant, or table. Once you adopt the practice of using names in your
workbook, you can easily update, audit, and manage these names.


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Sat, May 12, 2012 at 12:43 PM, Rajan_Verma  wrote:
> Name manager is used to Assign a Name to a Range on worksheets
>
> After define a name you can refer that range by that Name you assigned
>
>
>
> 1)  Press Ctrl+F3
>
> 2)  Alt+N (New)
>
> 3)  Fill the Name
>
> 4)  Select the Scope
>
> 5)  Select the Range
>
>
>
> If Your Define a name rngMyRange for A1:A10
>
> Then you can use like = sUm(rngMyRange) , Counta(rngMyRange)
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of vijayajith VA
> Sent: 12 May 2012 10:35
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Name Manager`
>
>
>
> Hi,
>
>
>
> I want to know about Name Manager.. .. what is the use of Name
> manager.how to use it..
>
>
>
> Can any one explain me with examples...or any nice links  ..Thanks
>
>
>
> --
> 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$$ match 2 columns

[╰» ℓαℓιт мσαнη]

Dear Sara,

PFA

*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Sun, May 6, 2012 at 11:35 PM, Sara Lee  wrote:

> hi
>  i would like to have wgt column in sheet 1 updated based on whenever
> there is a match on ozip and dzip columns in sheet1 and sheet 2. Can u pls
> give exact formula?
>
>
>  --
> 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


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

Re: $$Excel-Macros$$ Need macro website

[╰» ℓαℓιт мσαнη]

Dear karthik

you can also learn VBA by your self and for this you just need to record
macro for anything you do.


*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Sun, May 6, 2012 at 7:07 PM, Prajakt Pande wrote:

> Dear,
>
> Instated of learn from web site, just try your self with small small tools
> it will help you lot, i learn like this only this is my personal
> experience.
>
> all the best.
>
> Thanks & Regards,
> Prajakt Pande
> +971551388482
> **
>
>
>
> On Sun, May 6, 2012 at 5:09 PM, Bé Trần Văn wrote:
>
>> **
>>
>> 2012/5/5 Maries 
>>
>>>  Hi,
>>>
>>> Check below link,
>>>
>>> http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
>>>
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>>
>>> On Sat, May 5, 2012 at 4:41 AM, karthik N  wrote:
>>>
 Hi Friends,


 How learn the macro's in step by step,kindly provide the any macro
 tutorial website


 Pls Help

 Regards
 karthik.N

 --
 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
>>>
>>
>> *VBA basic instructions*
>>
>> http://www.excel-vba.com/index.htm
>>
>>
>> http://www.ozgrid.com/Excel/free-training/ExcelVBA1/excel-vba1-index.htm
>>
>>
>>
>> --
>> 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 thre

Re: $$Excel-Macros$$ Re: Help me to generate Report

[╰» ℓαℓιт мσαнη]

Hi Ankit,

Please attach file for the reference.


*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 4:10 PM, CoRe  wrote:

> More infos , less gibberish please.
>
> On Friday, May 4, 2012 11:30:18 AM UTC+3, ankit wrote:
>
>> Dear all,
>>
>> I have some data in one sheet and I have to generate report which format
>> is also on second sheet. How can we  generate it.
>>
>> Thanks & Regards,
>> Ankit
>>
>  --
> 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$$ Help Required to update off days in a tracker

[╰» ℓαℓιт мσαнη]

i have made some changes in Noorain's code :) [?]

PFA

*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 11:16 PM, Seema  wrote:

> hi,
>
> thank you for the effort. but the sheet is not getting updated instead
> throws an error asking to debug at line15.
> also, please let me know the logic applied here.
>
> Regards
>
> On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Vaseema,
>>
>> Please see attached workbook, Hope it will help to you.
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.**com
>>
>> On Fri, May 4, 2012 at 11:29 AM, Seema  wrote:
>>
>>>
>>> hello,
>>>
>>> i am using a form as a user interface for an employee to enter the off
>>> day of their choice week on week.
>>>
>>> i want to update the tracker based on the entries from the combobox.
>>>
>>> Attached is the sample file with the entry format.
>>>
>>> Any help is highly apprecaited.
>>>
>>> Regards
>>> Seema
>>>
>>>
>>> --
>>> 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
<<330.gif>>

Tracker (Solved).xlsm
Description: Binary data

Re: $$Excel-Macros$$ Chart-Secondary Axis option

[╰» ℓαℓιт мσαнη]

Try these link also

www.nios.ac.in/basiccomp/l12.pdf

http://mac2.microsoft.com/help/office/14/en-us/excel/item/301ec775-d4b3-452d-85af-55df53ff6db8

*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 10:56 PM, NOORAIN ANSARI wrote:

> PFA
>
> On Fri, May 4, 2012 at 7:59 PM, Sweet Kishore wrote:
>
>> hai friends,
>>
>> I would like to learn Excel basics. Can anyone please provide me with
>> notes and examples.
>>
>> Regards,
>>
>> Kishore
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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$$ Rounding value of six digit

[╰» ℓαℓιт мσαнη]

Or you can use this

=INT(ROUND(A1/1000,3))*1000

*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation>



On Fri, May 4, 2012 at 10:11 PM, ╰» ℓαℓιт мσαнη wrote:

> Hi
>
> please explain because the rounding of a number is based on some rules.
>
>
>
> *Regards,*
> *Lalit Mohan*
> *https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation>
>
>
>
> On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma wrote:
>
>> Hi Experts,
>>
>> Kindly help me with rounding a value of six digit.
>>
>> Example:
>>
>> Cell A1 has value as : 59687
>> I want a formula available in excel to convert this value into 59000.
>>
>> I have used
>>
>> =ROUND(A1/1000,0)*1000,
>> however its not a perfect way to convert this value.
>>
>> Let me know if you are aware of any typical formula available with in
>> excel.
>>
>> --
>> Shekhar Sharma
>> 9910010060
>> "Life consists not in holding good cards but in playing
>> those  you hold well"
>>  "Before you judge another, think of your own last mistake."
>>
>> --
>> 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$$ Rounding value of six digit

[╰» ℓαℓιт мσαнη]

Hi

please explain because the rounding of a number is based on some rules.



*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma wrote:

> Hi Experts,
>
> Kindly help me with rounding a value of six digit.
>
> Example:
>
> Cell A1 has value as : 59687
> I want a formula available in excel to convert this value into 59000.
>
> I have used
>
> =ROUND(A1/1000,0)*1000,
> however its not a perfect way to convert this value.
>
> Let me know if you are aware of any typical formula available with in
> excel.
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those  you hold well"
>  "Before you judge another, think of your own last mistake."
>
> --
> 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$$ Chart-Secondary Axis option

[╰» ℓαℓιт мσαнη]

Hi,

Another solution

Try these links

http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 4:03 PM, NOORAIN ANSARI wrote:

> Hi Hilary,
>
> Please try it..
> http://www.andypope.info/tips/tip008.htm
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, May 3, 2012 at 10:05 PM, hilary lomotey  wrote:
>
>> Hello Gurus,
>>
>> For some reason when i right click in the attached file(bar chart) and
>> click on format data series and i want to turn on the secondary axis
>> option(from the plot series on) in the series option it looks faded out,
>> pls how do i turn it on? thanks
>>
>> --
>> 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$$ Require VBA examples and notes on VBA 2007

[╰» ℓαℓιт мσαнη]

Hi,


You can also try these links

http://www.excel-vba-easy.com/

http://www.youtube.com/watch?v=wH03Xnr3Pug

http://www.vbtutor.net/vb.html


*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 8:52 AM,  wrote:

> Hi noorain,
> really useful one.
>
> Regards,
> venkat
> Chennai
> --
> Sent from my Nokia phone
>
> --Original message--
> From: NOORAIN ANSARI 
> To: 
> Date: Thursday, May 3, 2012 11:53:00 PM GMT+0530
> Subject: Re: $$Excel-Macros$$ Require VBA examples and notes on VBA 2007
>
> Dear Aruna,
>
> Please find attached Basic note of VBA with example.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Thu, May 3, 2012 at 11:41 PM, Aruna jayaram 
> wrote:
>
> > Hi
> >
> > I would like to learn VBA from basics and Macros. Can anyone provide me
> > with notes and examples, macros examples for 2007.
> >
> > Thank you
> >
> > Aruna
> >
> > --
> > 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
>

-- 
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$$ Need macro to verify part numbers between 2 sheets

[╰» ℓαℓιт мσαнη]

Hi

PFA


*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Fri, May 4, 2012 at 12:52 AM, Tony Wu  wrote:

> Hello,
>
> I have 2 sheets in one file, one sheet "A" has less part numbers than the
> other sheet "B", would like to have a macro to verify the part number in
> "A" vs. "B", anything missing in "B" will be added to the bottom of sheet
> "A".
>
> My logical is trying to use "iserror(vlookup(...),0) to see if the logical
> is false, if so, copy the cell value to sheet "A", but don;t know how to
> translate that into VBA language ...
>
> Need your help.
>
> Thanks,
>
> Tony
>
>  --
> 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


Solution.xlsm
Description: Binary data

Re: $$Excel-Macros$$ VB.net notes and examples programs, source code required

[╰» ℓαℓιт мσαнη]

Try these links

http://www.homeandlearn.co.uk/net/vbnet.html

http://www.vbnettutorial.com/

http://howtostartprogramming.com/vb-net/


*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*



On Thu, May 3, 2012 at 11:43 PM, Aruna jayaram  wrote:

> Hi
>
> I would like to learn VB.net from basics. Can anyone please provide me
> with notes and example programs, source code which can help me learn easily.
>
> Thanks
>
> Aruna
>
> --
> 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$$ Update cells based on combo box selection

[╰» ℓαℓιт мσαнη]

Please attach file with sample data for understanding.

*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 7:45 PM, Seema  wrote:

>
> hi,
>
> I want to have an application which enables the employee to select the day
> to mark as off.  i have started with and excel sheet with Names in a column
> and days on the rows. the days are grouped under week1, week2, week3 etc..
>
> i have a userform with 3 combo box , one for selecting a week, one for
> name and one for day.
>
> i want the cell in the sheet to be updated based on the selection of week,
> name and day.
>
> any help is highly appreciated.
>
> regards
> Seema
>
> --
> 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$$ Rajan verma : Most Helpful Member- Apr'2012

[╰» ℓαℓιт мσαнη]

Congratulation bhai
*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 6:21 PM, Rajan_Verma wrote:

> Thank you all. J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff
> *Sent:* 03 May 2012 01:40
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
> Apr'2012
>
> ** **
>
> Congratulations Rajan, you're very generous with your time and expertise!*
> ***
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
> *Sent:* Wednesday, May 02, 2012 9:01 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012***
> *
>
> ** **
>
> Hello Everyone,
>
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> April'2012
> He has posted 185 posts in April 2012 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and has
> acheived this recognition many times.
>
>
> Thanks to Don, Noorain, Asa, Maries, 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
>

-- 
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$$ working with array

[╰» ℓαℓιт мσαнη]

Try This

Sub lmTest()

Dim test(50) As String

With ActiveSheet
test(0) = .Cells(1, 2)   ' cells(1,2)= "LT12"
test(15) = .Cells(1, 3)  ' cells(1,3) "121"

.Cells(1, 10) = CDbl(test(0)) + CDbl(test(15))
End With

End Sub

*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 7:11 PM, Rajan_Verma wrote:

> ** **
>
> If you want to store the information in Array from worksheets, you can do
> that by this way
>
> ** **
>
> *Sub StoreRangeInArray()*
>
> *  Dim Arr*
>
> *  Arr = Selection*
>
> *If IsArray(Arr) Then*
>
> *MsgBox "Information Stored in Array" & vbCrLf & "Row  =" &
> UBound(Arr, 1) & vbCrLf & "Column =" & UBound(Arr, 2)*
>
> *End If*
>
> *End Sub*
>
> ** **
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 03 May 2012 18:17
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ working with array
>
> ** **
>
> Dear Eduardo,
>
> ** **
>
> Please try in this way..
>
> ** **
>
> Sub Array_Testing()
>
> Dim test(50) As String
>
> test(0) = Cells(1, 2)
>
> test(15) = Cells(1, 3)
>
> Cells(1, 10) = test(0) & " " & test(15)
>
> End Sub
>
> ** **
>
> ** **
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
>
> www.excelmacroworld.blogspot.com
>
> ** **
>
> ** **
>
> On Thu, May 3, 2012 at 6:11 PM, Eduardo Cereja 
> wrote:
>
> Hi , i need help to work with arrays. I want to create an array and
> put information ( from cells) in a specific position of that array.  For
> example.
>
>  
>
> Dim test(50) as string
>
> test(0)= Cells(1,2) ' cells(1,2)= "LT12"
>
> test(15)=cells(1,3) ' cells(1,3) "121"
>
>  
>
> cells(1,10)=test
>
>  
>
>  
>
> but in cells(1,10) does note appear test(0) +test(15)
>
>  
>
> could anyone help-me?
>
>  
>
> Best regards.
>
> --
> 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
>

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

Re: $$Excel-Macros$$ lotus notes mails

[╰» ℓαℓιт мσαнη]

Dear Prabhat


Try this

Sub sendEmail(EmailSubject As String, EMailSendTo As String, EMailBody As
String, MailServer as String)

Dim objNotesSession As Object
Dim objNotesMailFile As Object
Dim objNotesDocument As Object
Dim objNotesField As Object
Dim sendmail As Boolean

'added for integration into reporting tool
Dim dbString As String

dbString = "mail\" & Application.UserName & ".nsf"

On Error GoTo SendMailError
'Establish Connection to Notes
Set objNotesSession = CreateObject("Notes.NotesSession")
On Error Resume Next
'Establish Connection to Mail File
Set objNotesMailFile = objNotesSession.GETDATABASE(MailServer, dbString)
'Open Mail
objNotesMailFile.OPENMAIL
On Error GoTo 0

'Create New Memo
Set objNotesDocument = objNotesMailFile.createdocument

Dim oWorkSpace As Object, oUIdoc As Object
Set oWorkSpace = CreateObject("Notes.NotesUIWorkspace")
Set oUIdoc = oWorkSpace.CurrentDocument

'Create 'Subject Field'
Set objNotesField = objNotesDocument.APPENDITEMVALUE("Subject",
EmailSubject)

'Create 'Send To' Field
Set objNotesField = objNotesDocument.APPENDITEMVALUE("SendTo",
EMailSendTo)

'Create 'Copy To' Field
Set objNotesField = objNotesDocument.APPENDITEMVALUE("CopyTo",
EMailCCTo)

'Create 'Blind Copy To' Field
Set objNotesField = objNotesDocument.APPENDITEMVALUE("BlindCopyTo",
EMailBCCTo)

'Create 'Body' of memo
Set objNotesField = objNotesDocument.CREATERICHTEXTITEM("Body")

With objNotesField
.APPENDTEXT emailBody
.ADDNEWLINE 1
End With

'Send the e-mail

Call objNotesDocument.Save(True, False, False)
objNotesDocument.SaveMessageOnSend = True
'objNotesDocument.Save
objNotesDocument.Send (0)

'Release storage
Set objNotesSession = Nothing
Set objNotesMailFile = Nothing
Set objNotesDocument = Nothing
Set objNotesField = Nothing

'Set return code
sendmail = True

Exit Sub

SendMailError:
Dim Msg
Msg = "Error # " & Str(Err.Number) & " was generated by " _
& Err.Source & Chr(13) & Err.Description
MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext
sendmail = False
End Sub



*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 3:59 PM, prabhat.shrivasta...@gmail.com <
prabhat.shrivasta...@gmail.com> wrote:

> Dear Experts,
>
> I need urgent help to developed the macro, i've a list of my customer as
>
> Customer Name   Address   Client Code Mailid   Amout Due
>
> I'm using the lotus notes application & wanna send them individual email
> with above data fitted in our standard format, the client code is a unique
> value among all data. I wanna that the mail should go automatically, i
> tried to use mail merge but mails are not sending automatically, user
> required to click on the send button again n again which is again consuming
> time.
>
> Request your urgent help..
>
> Thanks in advance,
> Prabhat S
>
> --
> 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$$ Rising lagna-astrology

[╰» ℓαℓιт мσαнη]

Dear  Nemi

can u please explain step wise your issue.

*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma wrote:

> ** **
>
> Hi,
>
> As I remember ,I have seen this file before 3-4 months on group, can you
> please explain it more .. what you want to do ?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Nemi Gandhi
> *Sent:* 03 May 2012 16:18
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Rising lagna-astrology
>
> ** **
>
> Attached herewith sheet for solution. Please help.
>
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
> 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$$ Spelling problem

[╰» ℓαℓιт мσαнη]

Try this link

http://office.microsoft.com/en-us/word-help/turn-on-or-off-autocorrect-options-HP005189430.aspx

*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 6:25 PM, Rajan_Verma wrote:

> *You can Check the office autocorrect option *
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara
> *Sent:* 03 May 2012 11:12
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Spelling problem
>
> ** **
>
> Dear sir,
>
> ** **
>
> I face the problem regarding a spelling in which I write a word "Veh." in
> excel but it automatically write "Vet." so kindly know me whats problem
> going on.
>
> ** **
>
> Thanks & regards
>
> ** **
>
> Ashish
>
> --
> 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$$ Automatic insert of row at each change in particular data

[╰» ℓαℓιт мσαнη]

Dear Vaibhav

Please attach sample for reference.

*Regards,*
*Lalit Mohan*



On Thu, May 3, 2012 at 12:17 PM, NOORAIN ANSARI wrote:

> Dear Vaibhav,
>
> Please select required range and run this code..
>
> Sub InsertRows_Vaibhav()
> Dim InsQuan As Integer
> On Error Resume Next
> InsQuan = InputBox("Enter number of rows to insert", "Your Call")
> If InsQuan <= 0 Then
> MsgBox "Invalid number entered", vbCritical, "Stop!"
> Exit Sub
> End If
> Application.ScreenUpdating = False
> Do Until Selection.Value = ""
> ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
> Selection.Insert Shift:=xlDown
> ActiveCell.Offset(InsQuan, 0).Select
> Loop
> [A1].Select
> Application.ScreenUpdating = True
> End Sub
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, May 3, 2012 at 10:28 AM, vaibhav joshi wrote:
>
>> Dear all
>>
>> I am having a sheet ,which contains data of various parties.
>> I want to insert row at each change in party name automatically ,whether
>> it can be done automatically or i have to make it manually
>>
>> Regards
>>
>> Vaibhav
>>
>>
>> --
>> 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$$ Need Your Help

[╰» ℓαℓιт мσαнη]

*Hi karthik*
*
*
*PFA*
*
*
*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη
wrote:

> *Hi karthik*
> *
> *
> *PFA*
>
> *Regards,*
> *Lalit Mohan*
>
>
>
> On Sun, Apr 29, 2012 at 1:38 PM, karthik N  wrote:
>
>> Hi friends,
>>
>> Find the attachment of company address,how to spreat'up the colomn wise
>> data
>>
>> Sample data is attached.
>>
>>
>> Regards
>> karthik.N
>>
>> --
>> 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


data.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Need Your Help

[╰» ℓαℓιт мσαнη]

*Hi karthik*
*
*
*PFA*

*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 1:38 PM, karthik N  wrote:

> Hi friends,
>
> Find the attachment of company address,how to spreat'up the colomn wise
> data
>
> Sample data is attached.
>
>
> Regards
> karthik.N
>
> --
> 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$$ data needed in this format

[╰» ℓαℓιт мσαнη]

*Hi Sara *
*
*
*PFA*

*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee  wrote:

> Attached is the file with 2 sheets - input and output.
> output i require is based on input tab--- i need every reference value to
> be listed as columns and then list down the load nos in which these
> reference values exist  in the input tab.example
>
>
>  reference7151865O  is in 2 load nos below
>
>  load 0241  load 0243
>
> --
> 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


Book21.xlsm
Description: Binary data

Re: $$Excel-Macros$$ FORMULA FOR DATE AND TIME

[╰» ℓαℓιт мσαнη]

*Try this also:*
*
*
*Formula in A1 is =NOW()*
*
*
*Formula in A2 is*
*
*
*=IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2)
= 6,
IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)))+2,IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2)
=
7,IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)))+1,IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)
*

*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 11:19 AM, Maries  wrote:

> Hi,
>
> Try it,
>
>
> =IF(AND(WEEKDAY(A1,1)=6,A1-INT(A1)>0.705),INT(A1)+3.4167,IF(WEEKDAY(A1,1)=7,INT(A1)+2.4167,IF(WEEKDAY(A1,1)=1,INT(A1)+1.4167,IF(A1-INT(A1)>=0.705,INT(A1)+1.4167,A1+0.00347
>
> Regards,
>
> MARIES.
>
>
> On Sat, Apr 28, 2012 at 8:44 PM, vivek  wrote:
>
>> I want to add time to a particular date and time by 5 minutes in every
>> subsequent cell. The time range should be between 10:00 AM to 5:00 PM. I.e.
>> after 5:00 PM the date should be changed to next day 10:00 AM. And the day
>> range will be Monday to Friday. i.e. if it’s a Saturday or Sunday it
>> should be changed to Monday. Is it possible by giving some formula.
>>
>> ** **
>>
>> Sample
>>
>> Monday 02/07/2012 10:05
>>
>> Monday 02/07/2012 10:10
>>
>> Monday 02/07/2012 10:15
>>
>> Monday 02/07/2012 10:20
>>
>> Monday 02/07/2012 10:25
>>
>> Monday 02/07/2012 10:30
>>
>> Monday 02/07/2012 10:35
>>
>> Monday 02/07/2012 10:40
>>
>> Monday 02/07/2012 10:45
>>
>> ** **
>>
>> ** **
>>
>> Thanks & Regards...
>>
>> CA Vivek Jain, FCA, DISA (ICAI)
>>
>> Vivek Shantilal Jain & Co.
>>
>> Chartered Accountants
>>
>> 3010 Ram Kumar Arcade,
>>
>> Chatribari Road, A T Road,
>>
>> Guwahati-781001
>>
>> 0361-2603895,9435019908
>>
>> [image: save earth]
>>
>> ** **
>>
>> --
>> 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$$ Attendance tracking

[╰» ℓαℓιт мσαнη]

Please find the attached file with solution


*Regards,*
*Lalit Mohan*



On Wed, Apr 25, 2012 at 9:22 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:

> Hi Experts
>
> I would require your help in making it simple
>
> For Example
>
> Employee No 111 has taken a leave from 02/04/2012 to 10/04/2012 -
> 7days which i would require a auto update on below table for given
> date range  as "SCL" ( as per column "E")
>
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
>
> --
> 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


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