Re: $$Excel-Macros$$ Need some help in excel

[Mahesh Parab]

Hi Abhishek

Try : UDF mention on below link
http://jonvonderheyden.net/excel/displaying-autofilter-criteria/

Regards
Mahesh


On Tue, Feb 18, 2014 at 8:22 PM, abhishek agarwal <
abhishekagarwal...@gmail.com> wrote:

> Dear Sir,
>
> Please help me out i need some help
> i need that if i choose some option in filter the header comes out from
> that name
>
> kindly please see the example
>
> Raw Data:-
>
>  Colour  Red  Yellow  Green  pinky  Brown
> If i filter like that
>
>  Colour  pinky  Brown
> So result comes out like that
>  *Colour,pinky,Brown*  pinky  Brown
> in that header name change accordingly the name which i chose in filter
> option '
>
> if there is any fourmula or macro for the same
>
> kindly please do the needfull
>
>
> Regads
> Abishek
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Date of Retirement.

[Mahesh Parab]

Hi Prabhakar

perhaps you can use,
=DATE(YEAR(H2)+60,MONTH(H2),DAY(H2))

Regards
Mahesh


On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara
wrote:

> Dear Prabhakar, see the attached file to know the retire age as per your
> example
>
>
> On Tue, Feb 18, 2014 at 2:50 PM,  wrote:
>
>> Hi Team,
>>
>> I need your help to find out date of retirement with simple formula in
>> attached excel file.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Multiple excel sheets in merge in single excel sheet

[Mahesh parab]

Hi Kishore

Try :
Change worksheet name as per your requirement

Sub Mtest()
Dim i As Integer
Dim ws As Worksheet
Worksheets(Worksheets.Count).Activate
For i = 1 To Worksheets.Count
'Change sheet name where you want to copy data from all other sheets
If Sheets(i).Name <> "Mainsheet" Then
'change you range here
Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
'OR if header of all sheets are common  & copy used rows
'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
1).Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
End If
Next i
End Sub

HTH
Mahesh

On Fri, Jun 1, 2012 at 2:38 PM, Kishore wrote:

> Hi , Pls help
>
> On Friday, June 1, 2012 1:15:22 PM UTC+5:30, Kishore wrote:
>>
>> Hi Excel Gurus,
>>
>> I have three different excel sheets with data & top of the first at rows
>> names are described, all though three excel sheets headings at rows are
>> little vary , I would like to merge all these 3 excel sheets in single
>> workbook excel sheet.
>>
>> Please help& do the needful.
>>
>>  File attached.
>>
>> Regards,
>>
>> Kishore K.
>>
>>  --
> 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$$ Unique value formula required

[Mahesh parab]

Hi  Avinash

Perhaps ..! you can use below Array formula with dynamic name range
and without any helper column

=IFERROR(INDEX(DESIG,MATCH(0,COUNTIF($F$1:F1,DESIG),0)),"")

DESIG refers to Dynamic Name Range : =OFFSET(Sheet1!$C$2, 0, 0,
COUNTA(Sheet1!$C:$C), 1)

Use ctrl+shfit+Enter to enter formula

HTH
Mahesh

On Sat, Jun 2, 2012 at 12:50 AM, Avinash  wrote:

> Hi NOORAIN,
>
> Thanks for your help man both the formula and macro works fine.
>
> you are just awesome man simply great only 5 lines of code and doing
> exceptional task.
>
> salute for your logic and your knowledge.
>
> not just words ! :)
>
> simply great.
>
> Regards,
>
> Avinash
>
> On Friday, June 1, 2012 11:17:27 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>> Dear Avinash,
>>
>> Please try this macro to create unique list
>>
>> *Sub Unique_List()
>> Dim rng As Range
>> Set rng = Application.InputBox("Select a range", , , , , , , 8)
>> rng.AdvancedFilter Action:=xlFilterCopy, Copytorange:=Range("G2"),
>> Unique:=True
>> End Sub
>> *
>>
>> See attached sheet..
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.**com
>>
>>
>> On Fri, Jun 1, 2012 at 11:08 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Avinash,
>>>
>>> Please try it with ctrl+shfit+Enter
>>> *=INDEX($D$2:$D$21,SMALL(IF($A$2:$A$21=1,ROW($D$2:$D$21),""),ROW(A1))-1)
>>> *
>>>
>>> See attached sheet
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.**com
>>>
>>> On Fri, Jun 1, 2012 at 10:59 PM, Avinash wrote:
>>>
 Hi Excel's,

 I want to retrieve unique records from the data. 1st preference will be
 formula.

 otherwise if anyone can help me with the macro or function will also
 welcome.


 please find attached sheet for better understanding.


 Regards,

 Avinash

 --
 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+unsubscribe@**
 googlegroups.com 
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.**com
>>
>>
>>
>>
>>
> On Friday, June 1, 2012 11:17:27 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>> Dear Avinash,
>>
>> Please try this macro to create unique list
>>
>> *Sub Unique_List()
>> Dim rng As Range
>> Set rng = Application.InputBox("Select a range", , , , , , , 8)
>> rng.AdvancedFilter Action:=xlFilterCopy, Copytorange:=Range("G2"),
>> Unique:=True
>> End Sub
>> *
>>
>> See attached sheet..
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.**com
>>
>>
>> On Fri, Jun 1, 2012 at 11:08 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Avinash,
>>>
>>> Please try it with ctrl+shfit+Enter
>>> *=INDEX($D$2:$D$21,SMALL(IF($A$2:$A$21=1,ROW($D$2:$D$21),""),ROW(A1))-1)
>>> *
>>>
>>> See attached sheet
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.**com
>>>
>>> On Fri, Jun 1, 2012 at 10:59 PM, Avinash wrote:
>>>
 Hi Excel's,

 I want to retrieve unique records from the data. 1st preference will be
 formula.

 otherwise if anyone can help me with the macro or function will also
 welcome.


 please find attached sheet for better understanding.


 Regards,

 Avinash

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

Re: $$Excel-Macros$$ Bold and italics

[Mahesh parab]

Hi  Joseph

formula in cell A40 =TEXT(A1,"0% "&A24)

On Sat, May 26, 2012 at 1:21 AM, Mahesh parab  wrote:

> Hi  Joseph
>
> In cell A40 try below formula & run below macro
> =CONCATENATE(TEXT(A1,"0% "&A24))
>
> Sub Mtest()
> With Range("A40")
> .Value = .Value
> End With
> With Range("A40").Characters(Start:=1, Length:=3).Font
> .FontStyle = "Bold"
> End With
> With Range("A40").Characters(Start:=5, Length:=1).Font
> .FontStyle = "Italic"
> End With
> End Sub
>
> HTH
> Mahesh
>
>
> On Sat, May 26, 2012 at 1:09 AM, Rajan_Verma wrote:
>
>> Not possible as far as I know
>>
>>
>> Regards
>> Rajan verma
>> +91 7838100659 [IM-Gtalk]
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
>> ]
>> On Behalf Of joseph.cam...@gmail.com
>> Sent: 26 May 2012 12:13
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Bold and italics
>>
>> Hi,
>>
>> I have concatenated two values.
>> E.g., cell A1 has 12%, and A24 has 1. I want to concatenate both values in
>> cell A40 as 12% 1, but 12% should be bold and 1 italics.
>>
>> Please help.
>>
>> Thanks,
>> Joseph
>> Sent on my BlackBerryR 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
>>
>> 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$$ Bold and italics

[Mahesh parab]

Hi  Joseph

In cell A40 try below formula & run below macro
=CONCATENATE(TEXT(A1,"0% "&A24))

Sub Mtest()
With Range("A40")
.Value = .Value
End With
With Range("A40").Characters(Start:=1, Length:=3).Font
.FontStyle = "Bold"
End With
With Range("A40").Characters(Start:=5, Length:=1).Font
.FontStyle = "Italic"
End With
End Sub

HTH
Mahesh


On Sat, May 26, 2012 at 1:09 AM, Rajan_Verma wrote:

> Not possible as far as I know
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of joseph.cam...@gmail.com
> Sent: 26 May 2012 12:13
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Bold and italics
>
> Hi,
>
> I have concatenated two values.
> E.g., cell A1 has 12%, and A24 has 1. I want to concatenate both values in
> cell A40 as 12% 1, but 12% should be bold and 1 italics.
>
> Please help.
>
> Thanks,
> Joseph
> Sent on my BlackBerryR 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
>
> 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$$ queary

[Mahesh parab]

Hi Anil

Assuming cell A1 = 901+k then in cell B1 try below formula

=LOOKUP(MID(A1,FIND("+",A1,1)+1,1),{"a","i","k","l","p";"b","d","a","e","c"})


HTH
Mahesh


On Thu, May 24, 2012 at 8:58 PM, NOORAIN ANSARI wrote:

> Dear Anil,
>
> Please try it and see attached sheet.
>
> *
> =IF(COUNTIF($B$3:B3,LEFT(B3,3)&"*")>1,VLOOKUP(LEFT(B3,3)&"*",$B$2:C3,2,0),CHAR(96+COUNTA($B$3:B3)))
> *
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, May 24, 2012 at 4:18 PM, anil kumar  wrote:
>
>> Hello friends,
>>
>> I have a queary plz find attahcment.
>>
>>
>> Thanks & Regards
>> Anil
>>
>> --
>> 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$$ data download from different Sites, Through VBA Coading

[Mahesh parab]

Hi

you can do it through web queries. Check below link.
http://www.jkp-ads.com/Articles/WebQuery.asp

HTH
Mahesh

On Wed, Apr 25, 2012 at 8:59 AM, prince sethi wrote:

> Hi
>
> Can you please guide me as i have to download the data from Different
> sites for reporting purpose. For that i have to click several links copy
> from there & paste it to Excel sheets. Could someone guides me or if
> someone has any material where can i learn the same.
>
> Regards
> Prince
>
> --
> 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 SOME ATT.

[Mahesh parab]

Hi Anil

Perhaps u can try this as well

Sub Mtest()
Dim rng As Range, c As Range
Dim i As Long
Set rng = Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
For i = 65 To 90
For Each c In rng
If Not IsEmpty(c) Then
c.Replace Chr(43), ""
c.Replace Chr(i), ""
End If
Next c
Next i
End Sub

HTH
Mahesh

On Sat, Apr 7, 2012 at 11:27 AM, anil kumar  wrote:

>
> Thanks rajan and viper I will try
>
>
> Anil
>
>
>>
>  --
> 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$$ Simple VBA to Fill in blanks

[Mahesh parab]

Hi Jim

Please always reply to group for  prompt response of your query & better
solution.
someone else may find the solution helpful.


HTH
Mahesh
On Fri, Mar 23, 2012 at 11:12 PM, Jim Schug  wrote:

> Hi Mahesh, 
>
> Thank you very much. I works perfectly.
>
> ** **
>
> I’m new to posting.  Do I reply to you and post a reply to the group as
> well.
>
> Jim
>
> ** **
>
> *From:* Mahesh parab [mailto:mahes...@gmail.com]
> *Sent:* Friday, March 23, 2012 12:07 PM
> *To:* excel-macros@googlegroups.com; sch...@gmail.com
> *Subject:* Re: $$Excel-Macros$$ Simple VBA to Fill in blanks
>
> ** **
>
> Hi
>
> ** **
>
> PFA
>
> Try :
>
> Sub Mtest()
>
> Dim i As Long
>
> Dim Temp As String
>
> Temp = Cells(1, 1)
>
> For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
>
> If Trim((Cells(i, 1)) = "") Then
>
> Cells(i, 1) = Temp
>
> Else
>
> Temp = Cells(i, 1)
>
> End If
>
> Next
>
> End Sub
>
> ** **
>
> HTH
>
> Mahesh
>
> ** **
>
> On Fri, Mar 23, 2012 at 6:34 PM, dguillett1  wrote:*
> ***
>
> http://contextures.com/xlDataEntry02.html#Fill 
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Jim Schug  
>
> *Sent:* Thursday, March 22, 2012 8:34 PM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Simple VBA to Fill in blanks
>
>  
>
> Hi,
>
> I'm nearly brain dead (tired) and can't think straight. I have a simple
> issue. A macro to fill in blank values if found with the value from the
> cell above.
>
>  
>
> For example
>
>  
>
> 101
>
>  
>
>  
>
>  
>
> 1015
>
>  
>
> Would fill the blank rows with 101 until the next number 1015 is found,
> then it would use 1015 until another number...
>
>  
>
> A file with sample data is attached. Thanks in advance.
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> --
> 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$$ Rank Formula required

[Mahesh parab]

Hi  Pankaj

PFA,
Try :
=RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2 wrote:

> Shorter. Also enter using CSE (ctrl+shift+enter)
>
> =COUNTIF($F$2:$F$9,">"&F2)+**SUM(IF(F2=$F$2:F2,1,0))
>
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Secret Shot
> Sent: Sunday, March 18, 2012 4:02 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Rank Formula required
>
> Dear Expert,
>
> I want any formula to find Rank in Excel but that rank should be
> Unique.. if the value are same for ranking its should check second
> pereority. attach is the file for understanding the problme.
>
> Kindly help pls. i have tried with rank formula but it dosent work.
> --
> Pankaj Pandey
> Bhopal
>
> --
> 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


Ranking required_19032012.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

[Mahesh parab]

Hi

you can do it by using web
queryor recording it
or You can download sample workbook from below link.
http://www.marketcalls.in/spreadsheet/vba-macro-to-download-bhavcopy.html


HTH
Mahesh

On Sun, Mar 11, 2012 at 1:50 PM, rajeyssh  wrote:

> will you help me by telling me how can i make spreadsheet for the
> data. i am attaching the link of bhav copy and want to save day by day
> data in the spreadsheet. If any body in this group already have it and
> want to share it, welcome.
> http://www.mcxindia.com/SitePages/BhavCopy.aspx
>
> --
> 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$$ Add business address in a single row

[Mahesh parab]

Hi

You can use CONCATENATE
attach sample workbook if you are looking something different.

HTH
Mahesh

On Sun, Mar 11, 2012 at 8:11 PM, Lokesh Loki wrote:

> Hi Experts,
>
>
> I need to add these business addresses in a single row, so could you
> please provide me a formula so that I can do further needful action.
>
>
> *Example :- **Shapers Hair Salon & Spa, 27- 565 Bernard Ave., Kelowna,
> British Columbia, V1Y 8R4, Kelowna, NULL*
>
> **
>
>
>
> Name:Shapers Hair Salon & Spa
>
> Address:   27- 565 Bernard Ave., Kelowna, British Columbia, V1Y 8R4
>
> City:   Kelowna
>
> State:  NULL
>
>
>
>
> 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 to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Basics of excel & vba -plz send

[Mahesh parab]

Hi

check this

http://groups.google.com/group/excel-macros/browse_thread/thread/d23c567bf291be61/c79f558a40407eee?q=#c79f558a40407eee


HTH
Mahesh

On Sat, Mar 10, 2012 at 10:55 PM, Anil Kumar wrote:

> Hi Dear members,
>
> I am new to this group.
>
>
> thnx in adv.
>
> --
> 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$$

[Mahesh parab]

Hi

check whether this helps !

http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/


HTH
Mahesh

On Fri, Mar 9, 2012 at 11:34 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

>
> hi experts,
>
> Need your expert advise.
>
> please provide  a vba code which copiesText frame box copied from excel
> and then pastes it to ppt slide in bottom.
>
>
> --
> --
> Thanks & Regards,
> Rajasekhar.P
>
>
>  --
> 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 VBA for repeating copy and paste special

[Mahesh parab]

Hi Eric

Try :

Sub Mtest()
Dim LR As Long
LC = Sheet1.Cells(1, Columns.Count).End(xlToLeft).Column
LR = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To LC
'change sheet name here
'Use below line if you dont want to copy header of columns
'Sheet1.Range(Cells(2, i), Cells(LR, i)).Copy
Sheet1.Range(Cells(1, i), Cells(LR, i)).Copy
Sheet2.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial
Paste:=xlValues, Transpose:=True
Next
End Sub

HTH
Mahesh

On Thu, Mar 8, 2012 at 8:54 PM, Erick C  wrote:

> Hi everybody -
>
> I am hoping someone may be able to help me out.  I am still quite a
> novice with writing VBA, so I am sure there is an easy way to make
> what I am trying to do. I am working in Excel 2010.
> I have a spreadsheet with a tab that has data vertically from column A
> through column ZW.  I am trying to copy a specific range and paste
> special/trasnpose the column info into a row in a different tab.  I am
> trying to figure out an easier way to write some VBA to go to the
> first range, copy, go to the first line in the other tab, paste, go
> back and move right 7 columns to the next range, copy, back to the
> other tab, move down one line and paste, and so on...
> I have a bit of code that kind of illustrates what I am doing.  Is
> there a better way to do this so I do not have to write a giant string
> that goes all the way through column ZA, basically repeating over 100
> times, or should I just keep on going with what I have now?
>
>Sheets("CMFX First 30").Select
>Range("E8:E407").Select
>Selection.Copy
>Sheets("Combined Sheet").Select
>Range("B2").Select
>Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
> SkipBlanks:= _
>False, Transpose:=True
>Sheets("CMFX First 30").Select
>Range("L8:L407").Select
>Application.CutCopyMode = False
>Selection.Copy
>Sheets("Combined Sheet").Select
>Range("B3").Select
>Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
> SkipBlanks:= _
>False, Transpose:=True
>Sheets("CMFX First 30").Select
>Range("S8:S407").Select
>Selection.Copy
>Sheets("Combined Sheet").Select
>Range("B4").Select
>Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
> SkipBlanks:= _
>False, Transpose:=True
>
> Any help I can get would be greatly appreciated!
>
> Thanks!
>
> Erick
>
>
> --
> 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$$ VBA Help

[Mahesh parab]

Hi Pavan

Try

Public Sub CloseAll()
Dim WB As Workbook
Application.DisplayAlerts = False
For Each WB In Workbooks
If Not WB.Name = ThisWorkbook.Name Then
WB.Close SaveChanges:=False ' Or True if you want changes saved
End If
Next WB
ThisWorkbook.Close SaveChanges:=False
End Sub

HTH
Mahesh

On Thu, Mar 8, 2012 at 3:18 PM, pavan chowdary
wrote:

> Hi,
>
> This is pavan.
> Here i had a doubt. is there any vba code to close whole excel application?
> if it there you please let me know by reply to this mail.
>
> Thanks,
> Pavan.
>
> --
> 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

[Mahesh parab]

Hi

Try :

Sub Mtest()
Dim i As Long
Application.ScreenUpdating = False
On Error Resume Next
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If InStr(1, Cells(i, 1).Value, "This page", 1) Or _
InStr(1, Cells(i, 1).Value, "Search Results", 1) Or _
InStr(1, Cells(i, 1).Value, "Pick Ticket/ Release #", 1) Or _
Cells(i, 1).Value = "" _
Then Cells(i, 1).EntireRow.Delete
Next i
End Sub

Thanks
Mahesh

On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote:

> hi shaik.
>
> Sorry. i need code for ths..
>
>
> On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote:
>
>> Hi Sahik,,
>>
>> Sorry ..i need required code for ths .. Thanks''
>>
>>
>> On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote:
>>
>>> Hi,
>>> PFA solved, hope this is what u need.
>>>
>>> Steps:1) Select ur data range--> click on "data" menu, ---> Remove
>>> Duplicates--->Just click OK.
>>>
>>> On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA 
>>> wrote:
>>>
 Hi



 Please find the attached query///


 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
>

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

[Mahesh parab]

Try :

http://makeagif.com/
http://picasion.com/

On Tue, Mar 6, 2012 at 12:00 AM, Asa Rossoff  wrote:

> Hi Rekha,
>
> Outlook doesn't support animated GIFs.  Hasn't for many years.  They will
> just appear as a still image in Outlook, although they will probably still
> be animated for your mail recipients that use other mail clients, at least
> for web mail accounts.
>
> ** **
>
> Alternatively you can send a video file for the recipient to open, or a
> file with an embedded video, perhaps using Powerpoint; a link to an
> animated GIF or PNG on a web server, or a link to a hosted video such as on
> Youtube.
>
> Asa
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Monday, March 05, 2012 1:44 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need advise
>
> ** **
>
> Thanks Xls time, if i want to send  mail using outlook will it work over
> there if so please can you 
>
> ** **
>
> help me out in this concern.
>
> On Mon, Mar 5, 2012 at 7:58 AM, xlstime  wrote:
>
>
> use Google Insert Image option  in G mail or you can use link a .gif
> file...
> [image: Inline image 1]
>
>
>
>
> 
>
> On Mon, Mar 5, 2012 at 12:41 AM, rekha siri 
> wrote:
>
> hi Experts,
>
> ** **
>
> I Am excel trainer, just wanted to know how can we place this kind of
> animation in mail for excel functions or training's
>
> ** **
> Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)
>
> created by *Raja Sekhar P* 
> on
> Mar 4, 2012 1:34 PM, last modified by *Raja Sekhar 
> P* on
> Mar 4, 2012 1:39 PM
>
> *Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)*
>
>  
>
> 
>
> Here is a quick Excel tip to kick start your 
> week.
>
> Sometimes, we want to enter same data in to several cells. You can use
> CTRL+Enter to do this in a 
> snap.
>
> (1) Select all the cells where you want to enter the same data.
> (2) Type the data
> (3) Press CTRL+Enter
> (4) 
> Done!
>
> ** 
> **
>
> ** 
> **
>
> --
> 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 help for hyperlink execution without using mouse PFA

[Mahesh parab]

Hi

Do you want to send bulk emails to respective person from that worksheet ?


HTH
Mahesh

On Tue, Feb 14, 2012 at 9:14 PM, dguillett1  wrote:

>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Renukachari Kasee 
> *Sent:* Tuesday, February 14, 2012 6:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ need help for hyperlink execution without
> using mouse PFA
>
> Hi
> All experts
>
> good evening
>
> here one sheet is having hyperlinks click on that link(with the help of
> mouse) outlook new mail window will be open,
>
>
> but i am expecting without using mouse.
>
>
>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
> (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> **
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
> --
> 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$$ Synchronizing two Pivot tables.

[Mahesh parab]

it would be great if you could send sample workbook..!

On Sat, Feb 11, 2012 at 9:31 AM, Awal  wrote:

> I have two  pivot tables with the same underlying data set but show
> different views to the user. I need help synchronizing the 2 Pivot
> tables with one report filter.
> Thanks in advance for your Help !
>
> --
> 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$$ Excel and Macro PPT or Materials required

[Mahesh parab]

Hi

You can download ebooks from below links

   - *Excel 2007 VBA Macro Programming*

 http://www.mediafire.com/?9sl8iagf5e51144


   - *Microsoft Office Specialist (MOS) 2010 Study Guide for Microsoft®
   Excel*

 http://www.mediafire.com/?bs2dpn9qbwhih0n

HTH
Mahesh

On Wed, Feb 8, 2012 at 11:56 PM, NOORAIN ANSARI wrote:

>
>
> On Wed, Feb 8, 2012 at 8:03 PM, Liyakath Khan wrote:
>
>> Hi,
>>
>> I am new to excel field but want to learn excel and macros, could you
>> please provide me training materials. And also add my Id to this
>> group.
>>
>>
>> Thanks
>> Liyakath Ali Khan
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Urgent Required

[Mahesh parab]

Hi Neeraj

Mr Noorain has already reply for this
please explain in detail if you are looking apart from this

http://groups.google.com/group/excel-macros/msg/5ab13460ec7b96c6?pli=1

HTH
Mahesh

On Wed, Jan 18, 2012 at 11:06 PM, xlstime  wrote:

> what you want?
>
>
> On Tue, Jan 17, 2012 at 12:46 PM, Neeraj Chauhan <
> neerajchauhan...@gmail.com> wrote:
>
>>  Dear All
>>
>> The correct sheet attachd
>>
>> --
>> 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 help in building pivot using vba

[Mahesh parab]

Hi Rekha

Try :

Sub Mtest()
On Error Resume Next
'delete existing pivot sheet
Application.DisplayAlerts = False
Sheets("Pivot West").Delete
Application.DisplayAlerts = True
Sheets("West").Select
ActiveSheet.UsedRange.Select
'Count the column
colcount = Selection.Columns.Count
'Add Dynamic Name Range
ActiveWorkbook.Names.Add Name:="Pvtd", RefersToR1C1:= _
"=OFFSET(West!R1C1,0,0,COUNTA(West!C1)," & colcount & ")"
'Add New sheet for pivot
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = "Pivot West"
Sheets("West").Select
'create pivot table
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, _
SourceData:="Pvtd").CreatePivotTable _
TableDestination:=Sheets("Pivot West").Cells(3, 1), _
TableName:="PivotTable1", _
DefaultVersion:=xlPivotTableVersion10
 ' Turn off updating while building the table
PivotTable.ManualUpdate = True
' Set up the row & Column fields
Sheets("Pivot West").PivotTables(1).AddFields RowFields:=Array("Account"), _
ColumnFields:="Cost Ctr"
' Set up the data fields
With Sheets("Pivot West").PivotTables(1).PivotFields("Amount in local cur.")
.Orientation = xlDataField
.Function = xlSum
.Position = 1
End With

   ' Calc the pivot table
   PivotTable.ManualUpdate = False
   PivotTable.ManualUpdate = True
End Sub

HTH
Mahesh

On Wed, Jan 18, 2012 at 9:59 PM, rekha siri wrote:

> hi experts,
>
> Please provide the code to build pivot using vba
>
> this macro is provided to me in past by rajan really  thank full for the
> concern.
>
> adding to that i need to prepare pivot for  west bu  from attached macro
> raw data sheet.
>
> pivot format is also attached it should be as per West december2011 file's
> pivot manner.
>
> attached are macro and west december workbooks which contain pivot ..
>
>
>
> kindly help in this concern thanks.
>
> Rekha
>
> --
> 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$$ convert numbers into words

[Mahesh parab]

Dear  Noorain

it would be great if could explain about how you have hide formula's by
defining "formulahide" (='From Excel'!$W$1:$AG$13)  name range on From
Excel worksheet


Thanks
Mahesh

On Tue, Jan 17, 2012 at 7:02 PM, Rajan_Verma wrote:

> You Inword(Yourdigit) after install this add-in
>
> ** **
>
> Rajan
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Jan/Tue/2012 06:46
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ convert numbers into words
>
> ** **
>
> Updated Sheet
>
> On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa  wrote:**
> **
>
> Dear Noorain 
>
> ** **
>
> It converts with Rupees and i want only for words 
>
> ** **
>
> E.g. I have "23" in A1 so by formula we need "Twenty Three Only" 
>
> ** **
>
> I hope there may be something in excel treasure for this
>
> ** **
>
> On Tue, Jan 17, 2012 at 3:54 PM, NOORAIN ANSARI 
> wrote:
>
> Dear Priyanka,
>
> Please check attached sheet.
> Hope it will help to u.
>
> ** **
>
> On Tue, Jan 17, 2012 at 3:06 PM, PrIyAnKa  wrote:**
> **
>
> In "From Excel" Sheet i have written  525575
>  (Five Lac Twenty-Five Thousand Five hundred and Seventy-Five)
>
> ** **
>
> but we are getting result as per below : (Red highlighted)
>
> ** **
>
>   
>
> ** **
>
> *Type No Here*
>
> 525575
>
> ** **
>
> *Convert in Text*
>
> five hundred and twenty-five thousand five hundred and seventy-five
>
> ** **
>
> On Tue, Jan 17, 2012 at 1:43 PM, NOORAIN ANSARI 
> wrote:
>
> Hi Priyanka,
>
> Can you explain what error you are getting..
> because VBA+Excel both are working fine
>
> ** **
>
> On Tue, Jan 17, 2012 at 12:56 PM, PrIyAnKa  wrote:*
> ***
>
> Dear Noorain
>
> ** **
>
> Kindly see there is some error in for excel file
>
> ** **
>
> On Mon, Jan 16, 2012 at 5:07 PM, PrIyAnKa  wrote:**
> **
>
> Thanks Noorain
>
> ** **
>
> On Mon, Jan 16, 2012 at 4:54 PM, NOORAIN ANSARI 
> wrote:
>
> Dear Priyanka,
>
> Please see attached sheet with Excel & VBA both
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://excelmacroworld.blogspot.com/*
> 
>
> *http://noorain-ansari.blogspot.com/*
> 
>
> ** **
>
> On Mon, Jan 16, 2012 at 4:42 PM, PrIyAnKa  wrote:**
> **
>
> Dear Team
>
> ** **
>
> Can we have a formula which converts numbers in to word?
>
> ** **
>
> E.g. I have "23" in A1 so by formula we need "Twenty Three Only"
>
> ** **
>
> We do not need Rupees or pound any just simple word
>
> ** **
>
> ** **
>
> --
> 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) C

Re: $$Excel-Macros$$ Macro to send Email various recipients

[Mahesh parab]

Hi

You can download sample workbook from below link.

http://www.rondebruin.nl/sendmail.htm


HTH
Mahesh

On Tue, Jan 10, 2012 at 6:14 PM, PrIyAnKa  wrote:

> Dear Team
>
> I need a macro which send mail from excel to the mentioned id in Excel
> with data
>
> E.g. : from A to D data in excel is like as below :
>
> Name |Amount| Count | Email ID
>
> i have data for 100 to 200 persons and email id of each is mentioned in
> front of their name
>
> I want to send mail the data to concern person (of his only) to the email
> id mentioned in the sheet
>
> --
> 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$$ Unique count in Pivot table

[Mahesh parab]

Hi Amit

find attach workbook; i have added one column in pivot data & taken Sum of
Unique Values in pivot
i think "Count of unique cabs = Sum of Unique Values"
check whether this helps

 Data  WS Count of Cab # Sum of Bill amount Sum of Count of unique
cabs  Mahindra 6 218500 4  TATA 6 255000 4  Grand Total 12 473500 8
HTH
Mahesh
On Tue, Jan 10, 2012 at 6:30 PM, Rajan_Verma wrote:

> HI Krishna,
>
> Output is required within Pivot table as a calculated field I think.
>
> ** **
>
> Rajan.
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kris
> *Sent:* Jan/Tue/2012 06:45
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Unique count in Pivot table
>
> ** **
>
> Hi,
>
> ** **
>
> In K14 and copied down,
>
> ** **
>
>
> =SUM(IF(FREQUENCY(IF($B$2:$B$13=H14,IF($C$2:$C$13<>"",MATCH($B$2:$B$13&$C$2:$C$13,$B$2:$B$13&$C$2:$C$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))
> 
>
> ** **
>
> It's an array formula. Confirmed with CTRL + SHIFT + ENTER.
>
> ** **
>
> Kris
>
> --
> 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


Unique count in Pivot_10012012.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Unique count in Pivot table

[Mahesh parab]

Hi Amit

find attach workbook. hope this will help
Add one column in your pivot table data & use below formula
Assuming you want to count unique values from Range A:A in pivot table
=1/COUNTIF(A:A,A2)

it would be great if you could attach sample workbook.

HTH
Mahesh

On Sun, Jan 8, 2012 at 2:14 PM, Amit Desai (MERU)
wrote:

>  Dear Friends,
>
> ** **
>
> Generally we get count or sum of the data in a range of a column. Is it
> possible to get unique count in Pivot? If yes, please explain how?
>
> ** **
>
> Regards,
>
> *Amit Desai*
>
> 
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> 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


Unique count in Pivot table.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Copy multiples tables from one worksheet to separate worksheets

[Mahesh parab]

Hi

Try :

Sub Mtest()
Dim ws2 As Worksheet
Dim c As Range
For Each c In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
  If c.MergeCells Then
  c.CurrentRegion.Copy
  Set ws2 = Worksheets.Add(After:=Sheets(Sheets.Count))
  With ws2
  .Name = c.Value
  .Range("A1").PasteSpecial Paste:=xlPasteValues
   Application.CutCopyMode = False
  .ListObjects.Add(xlSrcRange,
.UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count - 1), ,
xlYes).Name = " "
  .Range("D2:F" & Cells(Rows.Count, 6).End(xlUp).Row).NumberFormat =
"0.00%"
  .Range("A2").Resize(3).EntireRow.Insert shift:=xlDown
  .Range("A3").Formula = "=""Number of School in Table :
""&COUNTA(C[1])-1"
  End With
  End If
  Next
End Sub

HTH
Mahesh

On Thu, Dec 22, 2011 at 8:02 AM, 0 1  wrote:

> (Second attempt to attach file. ... )
>
> Attached is a file with some sample tables. The README worksheet includes
> some notes and the tasks I'm trying to automate (the main one is moving the
> tables to separate worksheets, but I'd of course welcome suggestions for
> any of the others).
>
> Thanks for any guidance.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ To remove the character "*" from the cells with a date in it.

[Mahesh parab]

Hi Tan

Try :

Sub Mtest()
Cells.replace What:="~*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
*special character must be precede by “~” when you use find & replace option
*

Formula : Assuming Date with special char in cell A1
you can get the ASCII code of character using CODE formula (Excel 2007)
=SUBSTITUTE(A1,CHAR(42),"")

HTH
Mahesh

On Fri, Dec 9, 2011 at 9:12 PM, dguillett1  wrote:

>   Just select the columns ( D & E ) desired and use
> edit>replace  ~*  with (leave BLANK)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* tan dennis 
> *Sent:* Friday, December 09, 2011 5:46 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ To remove the character "*" from the cells
> with a date in it.
>
>
>
> Hi All
> I have a spreadsheet with 4000 row of records, I need to remove the
> character "*" in cells with date follow by "*". Can anyone provide a
> formula to remove this.
> Regards
> Tan BH
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Urgent Help required

[Mahesh parab]

Hi Prathap


Assuming u r value in cell A1
'=A1/10^6

HTH
Mahesh

On Thu, Oct 13, 2011 at 8:22 PM, Prathap  wrote:

> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
>  Attached is the sample file
>
> Best Regards,
> PRATHAP D
> M +91 9899-370-328
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Want to Highlight find Cell

[Mahesh parab]

Hi

Try:

Sub Mtest()
Dim found As Range
Dim m As String, Temp As String
Dim count As Integer
Dim ws As Worksheet
count = 0
m = InputBox(prompt:="Enter value for search", Title:="Excel Find")
For Each ws In ActiveWorkbook.Worksheets
Set found = ws.Cells.Find(What:=m, LookIn:=xlValues, lookat:=xlPart)
If Not found Is Nothing Then
count = count + 1
MsgBox found.Worksheet.Name & found.Cells.Address, Title:="Excel Find"
found.Cells.Interior.ColorIndex = 6
Temp = MsgBox(prompt:="Clear highlighting", Title:="Excel Find",
Buttons:=vbOKCancel + vbQuestion)
If Temp = vbOK Then found.Cells.Interior.ColorIndex = xlNone
End If
Next ws
If count = 0 Then MsgBox prompt:="Not found", Title:="Excel Find"
End Sub

HTH
Mahesh

On Sat, Oct 8, 2011 at 12:41 PM, B.N.Chethan kumar <
chetankumar1...@gmail.com> wrote:

> Hi,
>
> you give a name to cell...by using name managerand later need u call
> name to .
>
> i have attached sample file for easy understanding
>
> Regards
> Chethan Kumar BN
>
> On Fri, Oct 7, 2011 at 7:36 PM, satish 
> wrote:
>
>> Dear all,
>>
>> Sometimes I work with large data, if i want to find some data,
>> normally I type the key word in find option, I want to highlight the
>> cell with some colour to view it clearly, which cell is highlighted.
>> Normally it goes to cell but i have some problem ( eye sight).
>>
>> Thanks in advance
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> B.N Chetan kumar
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ can I unprotect a sheet

[Mahesh parab]

Hi Anil

find attach workbook to unprotect worksheet


HTH
Mahesh

On Sat, Oct 8, 2011 at 2:58 AM, ChilExcel  wrote:

> hi Dilip
>
>
> straxx  password ,,does not work, this discontinued
>  Chilexcel
>
>
> 2011/10/7 ChilExcel 
>
>> Please see attachment
>>
>>
>>
>>
>>
>>
>> 2011/10/7 Bé Trần Văn 
>>
>>>
>>>
>>> 2011/10/7 Dilip Pandey 
>>>
 Hi Anil,

 see the below link.
 www.straxx.com/excel/password.html

 Regards,
 DILIPandey
   On 7 Oct 2011 13:12, "anil kumar"  wrote:

> Hello everybody,
>
> I have a excel file in which i use protect op. but I have forgot
> password. becoz i use this file some time not daily.
> If we can unprotect sheet than tell soon.
>
>
> Anil
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

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

>>>
>>> You tried to remember the password, if not remember, use   unlocking
>>> software to open it
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Visita ; http://sites.google.com/site/chilexcel/Home
>> Visita ; http://www.youtube.com/user/timextag41
>>
>>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Unprotect Sheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Want to separate Alphabet and Numeric Values

[Mahesh parab]

Hi Suman

u can try below UDF also

'Below User Define Function extract Number from string
Function ExtractNumber(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
Select Case Asc(Mid(rng.Value, i, 1))
Case 0 To 64, 123 To 197
ExtractNumber = ExtractNumber & Mid(rng.Value, i, 1)
End Select
Next i
End Function

'Below User Define Function extract Text from string
Function ExtractText(stdText As String)
Dim str As String, i As Integer
stdText = Trim(stdText)
For i = 1 To Len(stdText)
If Not IsNumeric(Mid(stdText, i, 1)) Then
str = str & Mid(stdText, i, 1)
End If
Next i
ExtractText = str
End Function


HTH
Mahesh

On Thu, Oct 6, 2011 at 2:27 PM, NOORAIN ANSARI wrote:

> Dear Suman,
>
> Please try below function and see attached sheet
>
> Through Excel
>
>
> B1=MID(B3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B3&"0,1,2,3,4,5,6,7,8,9")),LEN(B3))
> Press ctrl+shift+Enter
> C1==LEFT(A3,LEN(A3)-LEN(B3))
>
> Through VBA
>
> Function extractonlytxt(txt)
> Dim txt1 As String
> txt1 = ""
> For i = 1 To Len(txt)
> If (Asc(Mid(txt, i, 1)) > 64 And Asc(Mid(txt, i, 1)) < 90) Or (Asc(Mid(txt,
> i, 1)) > 96 And Asc(Mid(txt, i, 1)) < 123) Then
> txt1 = txt1 & Mid(txt, i, 1)
> End If
> Next i
> extractonlytxt = txt1
> End Function
> Function exctractonlynumber(abc)
> Dim abc1 As String
> abc1 = ""
> For i = 1 To Len(abc)
> If IsNumeric(Mid(abc, i, 1)) Then
> abc1 = abc1 & Mid(abc, i, 1)
> End If
> Next
> exctractonlynumber = abc1
> End Function
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Wed, Oct 5, 2011 at 3:12 PM, Suman  wrote:
>
>> Hi Group
>> I have multiple data in column A (Alphabet with numeric values) n i want
>> to separate them?
>>
>> Available Data
>>
>>*A*
>>  suman1456  Sam221  Manni457
>>
>> I want like this:
>>
>>suman 1456  Sam 221  Manni 457
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Suman Kumar
>>
>> Mob: +91 9810333884
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[Mahesh parab]

Hi Craig

you can use Track changes option from excel

http://office.microsoft.com/en-us/excel-help/about-tracking-changes-HP005230064.aspx

HTH
Mahesh

On Thu, Oct 6, 2011 at 1:24 PM, Sam Mathai Chacko wrote:

> Goto VBE, insert a new module in your workbook vba project, and add this
> function
>
> Function HASFORMULA(rngCell As Range) As Boolean
>
> HASFORMULA = rngCell.HASFORMULA
>
> End Function
>
> In your conditional format rule, use =HASFORMULA(A1)
>
> Regards,
>
> Sam
>
>
> On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt wrote:
>
>> Conditional Formatting Highlight of Changed Cells
>> I have a large spreadsheet where users occasionally will overwrite the
>> builtin formula with a value. I would like Conditional Formatting to
>> highlight these cells that were changed from a formula to a numeric
>> value. My first shot in Cell “A1” was a conditional formula of
>> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
>> a formula. Did nothing and I cannot find an alternate solution. I saw
>> suggestions of using a user defined Function but very limited exposure
>> to that and didn’t have any success in making it work.
>>
>> Thanks for any help,
>> Craig
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Splitting of files

[Mahesh parab]

Hi Shrinivas

Try :

Sub Mtest()
Dim Rng As Range
Dim ws As Worksheet
Dim shname As String
Dim i As Integer
Dim shn As Long
Dim mx As Variant
Dim x As Integer
Dim LR As Long
Dim sPath As String, sFileName As String
On Error Resume Next
Application.DisplayAlerts = False
Sheets("Temp").Delete
Application.DisplayAlerts = True
Set Rng = Sheets("Div").Range("A6:A" & Cells(Rows.Count, 1).End(xlUp).Row)
Set ws2 = Worksheets.Add(After:=Sheets(Sheets.Count))
With ws2
Rng.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("A1"),
unique:=True
.Name = "Temp"
End With
Sheets("Temp").Columns("A").SpecialCells(xlCellTypeBlanks).Delete
shift:=xlShiftUp
LR = Sheets("Temp").Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To LR
Cname = Sheets("Temp").Cells(i, 1)
Set ws2 = Workbooks.Add
mx = Array("Div", "bon", "right")
shn = 1 - LBound(mx)
For x = LBound(mx) To UBound(mx)
Sheets(x + shn).Name = mx(x)
Next x
m = ws2.Name
ThisWorkbook.Activate

For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Temp" Then
ws.UsedRange.AutoFilter Field:=1, Criteria1:=Cname
ws.UsedRange.SpecialCells(xlCellTypeVisible).Copy
shname = ws.Name
Application.Goto _
Workbooks(m).Sheets(shname).Cells(1, 1)
ActiveSheet.Paste
ThisWorkbook.Activate
End If
Next ws
ws2.Activate
'Save the new workbook
sPath = ThisWorkbook.Path & "\"
'sPath = "C:\Users\MAHESH\Downloads\Delete\"
sFileName = Cname & ".xls"
Application.DisplayAlerts = False
ws2.SaveAs (sPath & sFileName)
ws2.Close True
ThisWorkbook.Activate
Next i
End Sub

HTH
Mahesh

On Sat, Oct 1, 2011 at 4:34 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:

> Dear All,
>
> I have dump file of 3 sheets which contain the data of some clients in each
> sheet, I want to split the files into client wise and also note the client
> name is all sheet is in column A.
>
> Please advise me to create macro. Find attached sample of dump file and
> client file for your reference.
>
> Regards,
> Shrinivas
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Excel expert required .

[Mahesh parab]

Hi Jatin

i recommend,

Krishnakumar KC

http://www.freelancer.co.nz/users/513618.html

http://www.linkedin.com/profile/view?id=14325892&authType=name&authToken=wPDQ&locale=en_US&pvs=pp&trk=ppro_viewmore

if you are looking someone from India, even some expert from this group can
help you.


HTH
Mahesh

On Fri, Sep 30, 2011 at 6:49 PM, Paul Schreiner wrote:

> That's what I do DAILY.
> (currently maintining over 80,000 lines of VBA code)
>
> If it can be done remotely, I'd be glad to help.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Jattin Agarwal 
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, September 30, 2011 4:35:02 AM
>
> *Subject:* $$Excel-Macros$$ Excel expert required .
>
> Dear Excel experts
>
>
> I would request  that  if  any VBA expert  can help in automating some
> reports .
> fees can be discussed over meeting . we are based in Mumbai
>
>
> Regards
>
> Jatin Agarwal
>
> 09322335208
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Numbers errors

[Mahesh parab]

Hi Anil

If you are not doing calculation with numbers then you can change the format
to text

check whether this helps
http://office.microsoft.com/en-us/excel-help/display-numbers-as-credit-card-numbers-HA010236840.aspx


HTH
Mahesh

On Wed, Sep 28, 2011 at 9:39 PM, XLS S  wrote:

> Hey Anil,
>
>
> Microsoft Excel stores numbers with up to 15 digits of precision. If a
> number contains more than 15 significant digits, Microsoft Excel converts
> the extra digits to zeros (0).
>
> You have 2 options:-
>
> You already know one of them
> Put an apostrophe (') in front of the number.
> That's OK for occasional use.
>
> The other is to set the number format for the range of cells to Text
> 
> Category: Text..Click [OK]
> Now whatever you type in the cells will be interpreted as text, including
> numbers and formulas.
>
>
>
>
> On Wed, Sep 28, 2011 at 1:39 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
>> Hi Experts,
>>
>> ** **
>>
>> I wanted your help in below points,
>>
>> ** **
>>
>> **1.**In excel my companies Bank account number is more than 20 digit
>> 
>>
>> **2.**And there are approx. 100 bank account numbers
>>
>> **3.**When I copy those numbers from one excel to another digits
>> after 15 alphabet convert to “0”
>>
>> **4.**What I understood is after 15 digit excel doesn’t recognize the
>> numbers and convert it to “0”
>>
>> ** **
>>
>> I tried using Value formula & Text formula but still it doesn’t work
>> because at the time of copy paste it again converting to number format.**
>> **
>>
>> And if I do F2 and enter it shows “0” after 15 digit.
>>
>> ** **
>>
>> *Anil Bhange*
>>
>> *Assistant Manager*
>> Financial Reporting & Compliance,
>>
>> TATA Communications Ltd.
>> VSB, Fort,  Mumbai – 400 001,
>> India
>>
>> ** **
>>
>> ' Desk : + 91 22 6659 2320
>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>>
>> anil.bha...@tatacommunications.com
>>
>> ** **
>>
>> ** **
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$

[Mahesh parab]

Hi

if you want to search blank value in the cell (C11) in all the sheets and
enter values into it then

Try

Sub Mtest()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC"
Next ws
End Sub

HTH
Mahesh

On Sat, Sep 24, 2011 at 11:33 PM, Mahesh parab  wrote:

> Hi
>
> Try
>
> Sub Mtest()
> Dim i As Integer
> Dim ws As Worksheet
> Worksheets(Worksheets.Count).Activate
> For i = 1 To Worksheets.Count
> 'Change sheet name where you want to copy data from all other sheets
> If Sheets(i).Name <> "Mainsheet" Then
> 'change you range here
> Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> 'OR if header of all sheets are common and used rows are 25
> 'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
> 1).Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> End If
> Next i
> End Sub
>
> HTH
> Mahesh
>
> On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:
>
>> I have around 100 sheets .
>>
>> I want to search blank value in the cell (C11) in all the sheets and enter
>> values into it
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

[Mahesh parab]

Hi

find attach sample workbook.


HTH
Mahesh

On Sat, Sep 24, 2011 at 11:36 AM, Raj Kumar  wrote:

> Hi Dear,
>
> I just want to know about pareto Chart in Excel. So i would request you
> that kindly suggest me about the same.
>
> Regards
> Raj Kumar
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


PARETOCH.XLS
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$

[Mahesh parab]

Hi

Try

Sub Mtest()
Dim i As Integer
Dim ws As Worksheet
Worksheets(Worksheets.Count).Activate
For i = 1 To Worksheets.Count
'Change sheet name where you want to copy data from all other sheets
If Sheets(i).Name <> "Mainsheet" Then
'change you range here
Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
'OR if header of all sheets are common and used rows are 25
'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
1).Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
End If
Next i
End Sub

HTH
Mahesh

On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:

> I have around 100 sheets .
>
> I want to search blank value in the cell (C11) in all the sheets and enter
> values into it
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Date from textbox reversed.

[Mahesh parab]

Hi

Try

ActiveCell.Value = Format(FrmApplications.TextBox1.Value,"dd/mm/")


Thanks
Mahesh



On Fri, Sep 9, 2011 at 10:26 PM, Brian  wrote:

> I am using a form to enter data and then from the textbox complete
> data in an excel spreadsheet.  This is my code
>ActiveCell.Value = Date
>ActiveCell.Offset(0, 1).Select
>ActiveCell.Value = FrmApplications.TextBox1.Value
>ActiveCell.Offset(0, 1).Select
>
> Activecell.Value = Date works perfectly as it places the date in
> column A correctly in the format set for my computer dd/mm/
> In textbox 1 I am entering a date in the form but when this is pulled
> into the cell in column B it reverses the date to mm/dd/ although
> my windows setting has been set to the format that appears in colmn A
>
>
> How do I correct this?
>
>
> I am using Excel 2007
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

[Mahesh parab]

Hi Prabhu

just change

Kill sPath & sFname

Thanks

On Sun, Sep 4, 2011 at 9:41 AM, Prabhu  wrote:

> Hi Mahesh,
>
> Plz find the same sheet i using for run this macro.
>
> Still a getting the same  runtime error.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

[Mahesh parab]

Hi Prabhu

it would be great if you send workbook which u r using & path of workbook.
that code is working fine for me.


Thanks
Mahesh

On Fri, Sep 2, 2011 at 12:33 PM, Rajan_Verma wrote:

>  *Try this Also..*
>
> * *
>
> *Option Explicit*
>
> *Sub Mtest()*
>
> *On Error GoTo Err:*
>
> *Application.DisplayAlerts = False*
>
> *Application.ScreenUpdating = False*
>
> *Dim sPath As String, sFname As String*
>
> * *
>
> *Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose
> Location to save"*
>
> *Application.FileDialog(msoFileDialogFolderPicker).Show*
>
> *sPath =
> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"*
>
> * *
>
> *sFname = "Statement as on " & Format(Date, "mm-dd-")*
>
> *With ActiveWorkbook.ActiveSheet*
>
> *Sheets(Array(.Name, .Previous.Name)).Select*
>
> *Sheets(Array(.Name, .Previous.Name)).Copy*
>
> *End With*
>
> * *
>
> *ActiveWorkbook.SaveAs (sPath & sFname)*
>
> *ActiveWorkbook.Close True*
>
> *Application.DisplayAlerts = True*
>
> *Application.ScreenUpdating = True*
>
> *Err:*
>
> *If Err.Number <> 0 Then*
>
> *MsgBox "Do Not select First Sheet", vbInformation*
>
> *End If*
>
> *End Sub*
>
> * *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mahesh parab
> *Sent:* Wednesday, August 31, 2011 6:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ ***VBA code to copy and save as new
> book***
>
> ** **
>
> Hi Prabhu
>
> ** **
>
> Try
>
> ** **
>
> Option Explicit
>
> Sub Mtest()
>
> Dim sPath As String, sFname As String
>
> sPath = ThisWorkbook.Path & "\"
>
> sFname = "Statement as on " & Format(Date, "mm-dd-")
>
> With ThisWorkbook
>
> Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
>
> Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Copy
>
> End With
>
> ActiveWorkbook.SaveAs (sPath & sFname)
>
> ActiveWorkbook.Close True
>
> Application.DisplayAlerts = False
>
> End Sub
>
> ** **
>
> Thanks
>
> Mahesh
>
> ** **
>
> On Wed, Aug 31, 2011 at 5:57 PM, Prabhu  wrote:**
> **
>
> Hi Friends,
>
> I need VBA code for copy existing sheet(s) in to a new workbook.
>
> i.e. I needs to copy two sheets (Active sheet and previous to the active
> sheet)from a workbook and the same two sheet needs to same as a new work
> book In a specified location with specified name(example like "Statement as
> on *31stAugust 2011*(current date)" 
>
> *Note:Sheet name may varies.I need to copy active and previous to the
> active sheet*
>
> Plz any one can help me to get the same.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our

Re: $$Excel-Macros$$ Pivot Table data extract

[Mahesh parab]

Hi Anil

copy below code in thisworkbook model

Private Sub Workbook_NewSheet(ByVal Sh As Object)
 Dim sht As Worksheet
Dim oLo As ListObject
Set sht = ActiveSheet
For Each oLo In sht.ListObjects
sht.ListObjects(oLo.Name).TableStyle = ""
Next
End Sub


Thanks
Mahesh

On Fri, Sep 2, 2011 at 6:02 PM, Shaik Waheed  wrote:

> Dear Anil.
>
> When u get the details in "Table Format", Goto 'Design Tab->Table
> Styles-->Select "Clear".dats it.
>
> U dont have any other easier option than this
>
> Regards,
> Waheed
> On Fri, Sep 2, 2011 at 5:00 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
>>  Sorry.. just to reframe the question…
>>
>> ** **
>>
>> I wanted all the details but not in “Table” format, because there I again
>> need to convert the table to Range
>>
>> ** **
>>
>> I want the information in normal format without any formatting.
>>
>> ** **
>>
>> Regards,Anil Bhange
>>
>> IP Phone - 512320 | Mobile - 90290 32123
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed
>> *Sent:* Friday, September 02, 2011 04:54 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Pivot Table data extract
>>
>> ** **
>>
>> Right Click on the pivot table, select Pivot Tabel Options, move to
>> 'Data' tab and then Uncheck- "Enable Show Details".
>>
>> On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange <
>> anil.bha...@tatacommunications.com> wrote:
>>
>> Hi Expert,
>>
>>  
>>
>> In Pivot table data details, when we double click on any value the details
>> of those values extract from main database and another worksheet get
>> prepared.
>>
>>  
>>
>> In this process, new worksheet details (extracted one) by default
>> extracted in “Table Format” and everytime we have to do “Convert to Range”
>> 
>>
>>  
>>
>> Is there any shortcut where I don’t get these details in Table format and
>> will get in the normal data details.
>>
>>  
>>
>>  
>>
>> *Anil Bhange*
>>
>> *Assistant Manager*
>> Financial Reporting & Compliance,
>>
>> TATA Communications Ltd.
>> VSB, Fort,  Mumbai – 400 001,
>> India
>>
>>  
>>
>> ' Desk : + 91 22 6659 2320
>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>>
>> anil.bha...@tatacommunications.com
>>
>>  
>>
>>  
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> ** **
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http:

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

[Mahesh parab]

Hi Prabhu

Try

Sub Mtest()
Dim sPath As String, sFname As String, fname As String
Dim OutApp As Object, OutMail As Object
fname = ThisWorkbook.Name
sPath = ThisWorkbook.Path & "\"
sFname = "Statement as on " & Format(Date, "mm-dd-") & ".xls"
With ThisWorkbook
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Copy
End With
ActiveWorkbook.SaveAs (sPath & sFname)
Application.DisplayAlerts = False
With ActiveWorkbook
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.TO = "a...@gmail.com"
.CC = ""
.BCC = ""
.Subject = fname
.Body = "Test Email"
.Attachments.Add ActiveWorkbook.FullName
.Display
'.send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
ActiveWorkbook.Close True
End With
kill sPath & sFname & ".xls"
End Sub

Thanks
Mahesh

On Thu, Sep 1, 2011 at 11:40 PM, NOORAIN ANSARI wrote:

> Dear Prabhu,
>
> See attached sheet if it help..
>
> On Thu, Sep 1, 2011 at 10:26 PM, Prabhu  wrote:
>
>> Hi Mahesh,
>>
>> Thanks it is working now.. Can you help me , if the same file needs to be
>> an attachment in a new outlook mail with the subject name has to be the
>>  file name, instead of saving in particular location.
>>
>> Regards,
>>
>> Prabhu.
>>
>>
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Speech Recognition software for excel

[Mahesh parab]

Thanks Ranjan

but i am aware of Application.Speech.speak. speak cell in excel 2007 its
inbuilt
i am looking for software which operate excel through Speech Recognition.

further info.
http://www.nuance.com/for-business/by-product/dragon/dragon-for-the-pc/dragon-premium/index.htm
http://www.youtube.com/watch?v=io40bTjlYCY

Thanks
Mahesh

On Wed, Aug 31, 2011 at 11:36 PM, rajan verma wrote:

> Hi,
> I just use this
>
> Sub speak()
> Application.Speech.speak "Hellow EveryOne, Look I M speaking"
> End Sub
>
>
> On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab  wrote:
>
>> Hi
>>
>> does any one aware of Speech Recognition software for excel, below are
>> some link i found on net
>> anyone using "Dragon NaturallySpeaking - Speech recognition software" ?
>>
>> http://dragon-naturallyspeaking.lastdownload.com/download.html
>> http://www.youtube.com/watch?v=OsqU31EcUS8&feature=related
>>
>>
>> Thanks
>> Mahesh
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

[Mahesh parab]

Hi Prabhu

check path of your file
sPath = ThisWorkbook.Path & "D:\Reports\"

*should be*

sPath = "D:\Reports\"

Thanks
Mahesh

On Wed, Aug 31, 2011 at 11:25 PM, Prabhu  wrote:

> Hi Ashish,
>
> Same Run time error "1004"
>
>- Make sure the specified folder is exists
>- Make sure the folder that contains the file is not read-only
>- Make sure the file name does not contain any of the following
>characters< > ? [ ] :| or *
>
>
>
> Debug shows the below yellow mark line item.
>
>
> Sub Mtest()
> Dim sPath As String, sFname As String
> sPath = ThisWorkbook.Path & "D:\Reports\"
> sFname = "Statement as on " & Format(Date, "mm-dd-")
> With ThisWorkbook
> Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
> Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Copy
> End With
> ActiveWorkbook.SaveAs (sPath & sFname)
> ActiveWorkbook.Close True
> Application.DisplayAlerts = False
> End Sub
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

[Mahesh parab]

Hi Prabhu

Try

Option Explicit
Sub Mtest()
Dim sPath As String, sFname As String
sPath = ThisWorkbook.Path & "\"
sFname = "Statement as on " & Format(Date, "mm-dd-")
With ThisWorkbook
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Copy
End With
ActiveWorkbook.SaveAs (sPath & sFname)
ActiveWorkbook.Close True
Application.DisplayAlerts = False
End Sub

Thanks
Mahesh

On Wed, Aug 31, 2011 at 5:57 PM, Prabhu  wrote:

> Hi Friends,
>
> I need VBA code for copy existing sheet(s) in to a new workbook.
>
> i.e. I needs to copy two sheets (Active sheet and previous to the active
> sheet)from a workbook and the same two sheet needs to same as a new work
> book In a specified location with specified name(example like "Statement as
> on *31stAugust 2011*(current date)"
> *Note:Sheet name may varies.I need to copy active and previous to the
> active sheet*
>
> Plz any one can help me to get the same.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Book2.xlsx

[Mahesh parab]

Hi

not sure what exactly you looking for, even if you *sort* the Party Name
column you will get results as per highlighted in yellow


thanks
Mahesh
On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar wrote:

> *Data Table*
>
> * *
>
> * *
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Date
>
> Party Name
>
> Amount
>
> ** **
>
> ** **
>
> *Hi can u suggest here for Sumproduct formula*
>
> 8/30/2011
>
> Anuvanshika -Kanpur
>
> 3
>
> ** **
>
> ** **
>
> * *
>
> * *
>
> * *
>
> * *
>
> 8/30/2011
>
> Kelvin Elec.
>
> 49649
>
> ** **
>
> ** **
>
> *Name of Parties*
>
> *Date*
>
> *Amt.*
>
> ** **
>
> 8/30/2011
>
> Anand Agencies
>
> 15
>
> ** **
>
> ** **
>
> Kelvin Elec.
>
> 30-Aug
>
> 49649
>
> ** **
>
> 8/30/2011
>
> Kelvin Elec.
>
> 1
>
> ** **
>
> ** **
>
> Kelvin Elec.
>
> 30-Aug
>
> 1
>
> ** **
>
> 8/30/2011
>
> Vijeta Elec-BR-DDN
>
> 3
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> HI
>
> ** **
>
> I WANT RESULT IN 
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sundarvelan N
> *Sent:* Wednesday, August 31, 2011 4:35 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Book2.xlsx
>
> ** **
>
> Please refere the attached file.
>
>
>  
>
> Thanks
>
> N.Sundarvelan 
>
> 9600160150
>
>
>
> 
>
> On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar 
> wrote:
>
> Dear All
>
>  
>
> Please suggest a formula of Sumproducts
>
>  
>
> Thanking u
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Book2.xlsx

[Mahesh parab]

Hi

Try

 =SUMPRODUCT((A3:A7=G5)*(B3:B7=F5)*(C3:C7))  *OR*
 =SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5)

On Wed, Aug 31, 2011 at 5:05 PM, Sundarvelan N  wrote:

> Please refere the attached file.
>
>
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar 
> wrote:
>
>>  Dear All
>>
>> ** **
>>
>> Please suggest a formula of Sumproducts
>>
>> ** **
>>
>> Thanking u
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Hide Rows that are NOT Yellow

[Mahesh parab]

Hi Bob

find attach.

Try :

Sub Mtest()
Dim c As Range
On Error Resume Next
With ActiveSheet
For Each c In .Range("A1:A100")
If c.Interior.ColorIndex <> 6 Then c.EntireRow.Hidden = Not
c.EntireRow.Hidden
Next c
End With
On Error GoTo 0
End Sub

Thanks
Mahesh

On Sat, Aug 20, 2011 at 8:45 PM, dguillett1  wrote:

> Post your file with a complete explanation and tell us your excel version.
>
> -Original Message- From: Bob
> Sent: Saturday, August 20, 2011 7:46 AM
>
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Hide Rows that are NOT Yellow
>
> On Sheet2 I have some rows that are highlighted in yellow and some
> not. I'd like for when the user clicks on the command button to hide
> all the rows NOT in Yellow. And another command button to unhide. I'm
> familiar with installing the command buttons, just don't know how to
> write the code to hide and unhide. Thanks so much for any help.
>
> --
> --**--**
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/**
> exceldailytip 
> 2. Join our LinkedIN group @ 
> http://www.linkedin.com/**groups?gid=1871310
> 3. Excel tutorials at 
> http://www.excel-macros.**blogspot.com
> 4. Learn VBA Macros at 
> http://www.quickvba.blogspot.**com
> 5. Excel Tips and Tricks at 
> http://exceldailytip.blogspot.**com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>**<><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/**discussexcel
> --
> --**--**
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/**
> exceldailytip 
> 2. Join our LinkedIN group @ 
> http://www.linkedin.com/**groups?gid=1871310
> 3. Excel tutorials at 
> http://www.excel-macros.**blogspot.com
> 4. Learn VBA Macros at 
> http://www.quickvba.blogspot.**com
> 5. Excel Tips and Tricks at 
> http://exceldailytip.blogspot.**com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>**<><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/**discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Hide Rows.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ TAT reporting for assignment

[Mahesh parab]

Hi Amit

use below formula in C3

=IF(B3<=2,"0-2 Days",IF(B3<=7,"3-7 days",IF(B3<=14,"8-14
days",IF(B3<=30,"15-30 days","More than 30 days"


Thanks
Mahesh

On Sat, Aug 20, 2011 at 10:53 AM, Amit Desai (MERU)  wrote:

>  Thanks this helped…
>
> ** **
>
> Now what if I need, TAT range (0 – 2 day, 3 – 7 days, etc…) next to
> “Completion time in Days” column in the attached file?
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Saturday, August 20, 2011 9:54 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ TAT reporting for assignment
>
>  ** **
>
> see if it helps
>
> On Sat, Aug 20, 2011 at 9:21 AM, Amit Desai  wrote:
>
> Dear All,
>
>  
>
> Need your help, to have a formula to get answers in yellow cells for # of
> services completed in TAT in days.
>
>  
>
> Sample sheet attached for your reference.
>
>  
>
> Best Regards,
>
> Amit 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> 
>
> ** **
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

Re: $$Excel-Macros$$ Add 1 to a cell every time the file is opened

[Mahesh parab]

Hi John

One concern , what if i open the workbook n didnt save it,
next time whn i open the workbook it will reflect same number

try below code in Thisworkbook module

Private Sub Workbook_Open()
Sheets("Sheet1").Range("F2").Value = Sheets("Sheet1").Range("F2").Value + 1
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

Thanks
Mahesh


On Thu, Aug 11, 2011 at 3:05 PM, Rajan_Verma wrote:

>  *You can use this :*
>
> *Private Sub Workbook_Open()*
>
> *Range("F2").Value = Range("F2").Value + 1*
>
> *End Sub*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *John A. Smith
> *Sent:* Thursday, August 11, 2011 1:25 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Add 1 to a cell every time the file is opened*
> ***
>
>  ** **
>
> Excel guru's, can I make a receipt file that adds 1 to a specific cell
> everytime the file is opened?
>
>  
>
> Please see attached.
>
>  
>
> Thank you.
>
>  
>
> John
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

[Mahesh parab]

Hi Prabhu

Try

Sub Mtest()
Dim LR As Long, i As Long
LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count
'LR = Range("P" & Rows.Count).End(xlUp).Row
Application.ScreenUpdating = False
For i = LR To 1 Step -1
If Cells(i, 16).Value = 0 Then Cells(i, 16).EntireRow.Delete
Next i
Application.ScreenUpdating = True
End Sub

*OR*
*
*
Sub Mtest1()
Dim LR As Long, r As Long
LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For r = LR To 1 Step -1
If Application.WorksheetFunction.CountIf(Cells(r, 16), "=0") = 1 Then
Rows(r).Delete
Next r
Application.ScreenUpdating = True
End Sub

Thanks
Mahesh

On Thu, Aug 11, 2011 at 10:00 PM, Prabhu  wrote:

> Hi Mahesh,
>
> It is deleting entire row wherever zero appearing. But i required in a
> partiuclar column if Zero value found we need to delete entire row.
>
> Ex. If we use base as  "P" column, In 13th row of "P" column contains "0"
> value it has to delete entire 13th Row. It should not search other columns.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Help in Training room booking system

[Mahesh parab]

Hi

You can download sample workbook here
http://exceltemplate.net/calendar/hotel-reservations/
http://office.microsoft.com/en-us/templates/conference-room-reservation-request-form-TC03617.aspx
http://www.myexceltemplates.com/conference-room-scheduler-excel-template/

Thanks
Mahesh

On Mon, Aug 1, 2011 at 11:24 PM, alisha malhotra <
alisha.malhotr...@gmail.com> wrote:

> Hi,
>
> I want to create a Training room(or Auditorium etc.) booking system. How
> should I create it? What features should I add?
>
> If anyone have this kind of template then please send me.
>
> Waiting for your response.
>
> Thanks & Regards,
> Alisha
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Vba Code required to link every cell of workbook to another workbook

[Mahesh parab]

Hi Kaushik

can you send both sample workbook which r link.


Thanks
Mahesh

On Mon, Aug 1, 2011 at 5:59 PM, KAUSHIK SAVLA wrote:

> Hi All,
>
> Vba code required to link whole workbook (every cell of workbook) to
> another workbook.
>
> Regards,
> Kaushik
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Entered data should be locked

[Mahesh parab]

Hi Muralidhar



Try :
1.First select all cells (Ctrl + A) on worksheet
2.Right Click & Go to Format cells
3.Select Protection Tab
4.uncheck Locked
5.Right Click on sheet tab & select view code
6.Paste below code


Private Sub Worksheet_Change(ByVal Target As Range)
Const pw As String = "password"
With Me
.Unprotect pw
 Target.Locked = True
.Protect pw
End With
End Sub

Thanks
Mahesh

On Mon, Aug 1, 2011 at 9:53 PM, Daniel  wrote:

> HI,
>
> ** **
>
> Sometimes, you have no choice.
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* muralidhar e
> *Envoyé :* lundi 1 août 2011 13:32
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Fwd: $$Excel-Macros$$ Entered data should be locked
>
> ** **
>
> Hello friend,
>
>  
>
> Thank you but i need without macros is it possible to do this it is more
> helpful to me.
>
> Regards,
>
>  
>
> Muralidhar E.
>
> -- Forwarded message --
> From: *Daniel* 
> Date: Sun, Jul 31, 2011 at 8:44 PM
> Subject: RE: $$Excel-Macros$$ Entered data should be locked
> To: excel-macros@googlegroups.com
>
> 
>
> Hello,
>
>  
>
> I protected the sheet (password : excel). In the sheet module I put the
> macro :
>
>  
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Dim c As Range
>
> ActiveSheet.Unprotect "excel"
>
> For Each c In Target
>
> If c <> "" Then c.Locked = True
>
> Next c
>
> ActiveSheet.Protect "excel"
>
> End Sub
>
>  
>
> Have a look at the attached workbook.
>
>  
>
> Regards.
>
>  
>
> Daniel
>
>  
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* muralidhar e
> *Envoyé :* dimanche 31 juillet 2011 14:25
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Entered data should be locked
>
>  
>
> Dear Friends,
>
>  
>
> If any one can helped can be appreciated i have data
> like frequently repeated data so i would like to lock the entered data and
> it should not be modified i.e. my file should allow empty cells should be
> entered, if any correction or modification needed that should ask
> the password.If the help is without macro is better to me.
>
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> *Thanks & Regards,*
>
>  
>
> *Muralidhar E.*
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn

Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

[Mahesh parab]

Hi

Try :
Use below formula in Conditional Formatting
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("65:90"))),"")))=3

Reference :http://dmcritchie.mvps.org/excel/strings.htm


Thanks
Mahesh



On Thu, Jul 28, 2011 at 3:39 AM, qcan  wrote:

> Hi,
>
> Can anyone help me with some sort of formula or Macro that would
> identify any word (minmum 3 letters) that is all in caps. I would like
> whatever is found to be highlighted in yellow.
>
> Thanks.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Reverse Vlookup

[Mahesh parab]

Hi Anil

Find attach
Try
=LOOKUP(2,1/($A$2:$A$12=D3),$B$2:$B$12)

Thanks
Mahesh

On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

> Hi All,
>
> ** **
>
> Could you help me with VB code for Reverse Vlookup function command where
> we can lookup value from Right to Left.
>
> ** **
>
> Some similar to Vlookup but lookup from Right to Left.
>
> ** **
>
> Please give me a function code so that I can able to save this in Personal
> workbook and use in all excel file.
>
> ** **
>
> ** **
>
> *Anil Bhange*
>
> *Business Planning & Management Reporting*
> Financial Planning & Analysis,
>
> TATA Communications Ltd.
> 6th Floor, B Wing,
> Bandra Kurla Complex, Bandra (East),
> India
>
> ** **
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>
> anil.bha...@tatacommunications.com
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Vlookup_R.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

[Mahesh parab]

Hi
Try

Sub Mtest()
Dim LR As Long, r As Long
LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For r = LR To 1 Step -1
If Application.WorksheetFunction.CountIf(Rows(r), "=0") = 1 Then
Rows(r).Delete
Next r
Application.ScreenUpdating = True
End Sub

Thanks
Mahesh

On Thu, Jul 28, 2011 at 9:54 PM, Prabhu  wrote:

> Hi Friends,
>
>
> I Required Macro code if we find zero(0) in a particular row then we need
> to delete entire row.
>
> Example: In"P' column P27,48,57 cells contain 0 then entire 27,48,57th row
> needs to delete from the sheet.
>
> Plz help
>
> Regards,
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ minimum numeric positive value

[Mahesh parab]

Hi

find attach
Try : {=MIN(IF($A$2:$A$16>0,$A$2:$A$16))}

Thanks
Mahesh


On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote:

>
> Hi friends,
>
> i have a data, in which so many numeric value, some are positive( like
> 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc),
> so how can i find minimum positive numeric value?
> example(1,2,3,4,6,-1,-7,-8,-2.)  in this data, minimum numeric positive
> value is 1.
>
> please suggest..
> --
> Thanks & regards,
> Sunder Singh Nayal
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Min_Number.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

[Mahesh parab]

Hi
check info on this
http://www.youtube.com/watch?v=SYpHjReBbmA&feature=share


Thanks
Mahesh

On Wed, Jul 27, 2011 at 3:53 PM, Venkat CV  wrote:

> Thanks to All...
>
>
>
>
> On Wed, Jul 27, 2011 at 9:40 AM, Dilip Pandey wrote:
>
>> Hi Venkat,
>>
>> Check following links:-
>>
>> www.cpearson.com/excel/array.htm
>> www.ozgrid.com/Excel/arrays.htm
>>
>> Regards,
>> DILIPandey
>>
>> On 7/26/11, Venkat CV  wrote:
>> > Dear All,
>> >
>> > any one Explain Difference between Array formula and Normal Formula...
>> >
>> > With Examples..&Use of Array formulas ...
>> >
>> > *Best Regards,*
>> > *Venkat*
>> > *Chennai*
>> > *
>> > *
>> > *
>> > *
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> >
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>
>
>
> --
> *Best Regards,*
> *Venkat*
> *Chennai*
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ filter of nonblank cell

[Mahesh parab]

Hi

find attach as per your requirement.

try :

Sub test()
Sheet1.UsedRange.Copy
Sheet2.Select
Sheet2.Range("A1").PasteSpecial Paste:=xlPasteValues
On Error Resume Next
Columns("B").SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
On Error GoTo 0
End Sub

On Mon, Jul 25, 2011 at 7:42 PM, vickey  wrote:

> Is thereany way to filter / copy nonblank values toanother sheet.
>
> considering followng example.
>
> ID  NAME
> 1   
> 2   BBB
> 3   CCC
> 4
> 5
> 6
> 7   DDD
> 8   FFF
> 9   EE
>
>
>
>
>
> ID  NAME
> 1   
> 2   BBB
> 3   CCC
> 7   DDD
> 8   FFF
> 9   EE
>
>
>
> thanks in advance
>
> vikas
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Sample sheet_2507.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ to find particular column and insert one column and perform Vlookup using vba

[Mahesh parab]

Hi

For Vlookup you can use static Name range which is predetermined
RANGE
=SBUMapping!$A$1:$D$789
OR
dynamic Name range range which resize dynamically
RANGE
=OFFSET(SBUMapping!$A$1,0,0,COUNTA(SBUMapping!$A:$A),COUNTA(SBUMapping!$1:$1))


Thanks
Mahesh


On Mon, Jul 18, 2011 at 11:05 PM, Mahesh parab  wrote:

> Hi Prathima
>
> Assuming your Data 1,2 & 3 columns contain data
>
> Try :
>
> Sub test()
> Dim LR As Long
> Sheets("Summary").Select
>
> Set Found = Sheets("Summary").Rows(1).Find(what:="Data 1",
> LookIn:=xlValues, lookat:=xlWhole)
> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
> Found.Offset(, 1).EntireColumn.Insert
> Cells(1, Found.Column + 1).Value = "SBU"
> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
> Range("RANGE"), 2, False)
>
> Set Found = Sheets("Summary").Rows(1).Find(what:="Data2", LookIn:=xlValues,
> lookat:=xlWhole)
> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
> Found.Offset(, 1).EntireColumn.Insert
> Cells(1, Found.Column + 1).Value = "Region"
> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
> Range("RANGE"), 3, False)
>
> Set Found = Sheets("Summary").Rows(1).Find(what:="Data3", LookIn:=xlValues,
> lookat:=xlWhole)
> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
> Found.Offset(, 1).EntireColumn.Insert
> Cells(1, Found.Column + 1).Value = "Division"
> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
> Range("RANGE"), 4, False)
> End Sub
>
> Thanks
> Mahesh
>   On Sun, Jul 17, 2011 at 12:02 PM, Prathima R wrote:
>
>> hi experts,
>>
>> Please help me in this concern.
>>
>> i need to perform vlookup function using VBA
>>
>> i have attached sample work book for referance
>>
>> From the attached workbook i need update summary sheet using the company
>> code as base  from SBU Mapping sheet.
>>
>> i need to insert one column after Data1 , Data2, Data3 Columns and pull
>> the SBU,DIVISION, REGION
>>
>> Please provide the vba code code to find the data1 column and then insert
>> one column after it.then i need to pull data using vlookup.
>>
>> like wise i will be updating for all rest.
>>
>> Thanks,
>> Prathima.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ to find particular column and insert one column and perform Vlookup using vba

[Mahesh parab]

Hi Prathima

Assuming your Data 1,2 & 3 columns contain data

Try :

Sub test()
Dim LR As Long
Sheets("Summary").Select

Set Found = Sheets("Summary").Rows(1).Find(what:="Data 1", LookIn:=xlValues,
lookat:=xlWhole)
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Found.Offset(, 1).EntireColumn.Insert
Cells(1, Found.Column + 1).Value = "SBU"
Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
Range("RANGE"), 2, False)

Set Found = Sheets("Summary").Rows(1).Find(what:="Data2", LookIn:=xlValues,
lookat:=xlWhole)
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Found.Offset(, 1).EntireColumn.Insert
Cells(1, Found.Column + 1).Value = "Region"
Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
Range("RANGE"), 3, False)

Set Found = Sheets("Summary").Rows(1).Find(what:="Data3", LookIn:=xlValues,
lookat:=xlWhole)
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Found.Offset(, 1).EntireColumn.Insert
Cells(1, Found.Column + 1).Value = "Division"
Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
Range("RANGE"), 4, False)
End Sub

Thanks
Mahesh
On Sun, Jul 17, 2011 at 12:02 PM, Prathima R  wrote:

> hi experts,
>
> Please help me in this concern.
>
> i need to perform vlookup function using VBA
>
> i have attached sample work book for referance
>
> From the attached workbook i need update summary sheet using the company
> code as base  from SBU Mapping sheet.
>
> i need to insert one column after Data1 , Data2, Data3 Columns and pull the
> SBU,DIVISION, REGION
>
> Please provide the vba code code to find the data1 column and then insert
> one column after it.then i need to pull data using vlookup.
>
> like wise i will be updating for all rest.
>
> Thanks,
> Prathima.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ To Generate a Code

[Mahesh parab]

Hi Kurikkal

find attach

Thanks
Mahesh


On Sun, Jul 17, 2011 at 4:59 PM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:

> Dear Experts,
>
> Hope somebody could help me to solve the problem mentioned in the attached
> sheet.
>
> Thanks in advance.
>
> Regards,
> Kurikkal.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


To_generate_a_code_Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ excel user form objects

[Mahesh parab]

Hi Pascal

Try:
Private Sub CommandButton1_Click()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Columns("A:A").Hidden = Not ws.Columns("A:A").Hidden
Next
End Sub

Thanks
Mahesh

On Sat, Jul 16, 2011 at 11:11 PM, bpascal123 wrote:

> Hi,
>
> I would like to know if there is a way to use the same code for an
> activeX toggle button present one time on all sheets in a workbook.
>
> For instance, when the toggle button is toggled, it should hide some
> columns and when "untoggled" it should show the hidden columns. Column
> numbers are the same for all sheets so the code for the button present
> on every sheet is the same.
>
> Do I need to write the code for every sheet where this object is
> located or can I make it global for the workbook ?
>
> Thanks for any help or advice.
>
> Pascal
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

[Mahesh parab]

Hi

U have consider G1 = 2527 in pivot table & not in sumproduct sheet. Please
check


Thanks
Mahesh

On Fri, Jul 15, 2011 at 6:20 PM, Pascal Baro wrote:

> Hi,
>
> This time there really is a difference between the pivot table and
> productsum function.
> It seems it's all about decimal values. Productsum seems to round up
> numbers in a different way than the pivot table. For large numbers we
> then get a difference.
> Please look a the file for more ...
>
> Pascal
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Excel Macro

[Mahesh parab]

Hi

Paste below code in thisworkbook module

Private Sub Workbook_Open()
If MsgBox("Do u want to Disable macro?", vbYesNo, "Information") = vbYes
Then
ActiveWorkbook.Close savechanges:=True
End If
End Sub

Thanks
Mahesh
On Thu, Jul 14, 2011 at 10:07 PM, karthikeyan <
karthikeyansankar...@gmail.com> wrote:

> Hi all,
>
> How to call *Macro confirmation Dialog box* open my macro excel book
> in excel-2007/10.
> If i click *Disable macro* macro excel book should goes to close.How
> to do that.Pls help.
>
> Thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Rename Sheet as datawise How?

[Mahesh parab]

Hi
Try

Sub test()
Dim i As Long
Dim ws As Worksheet
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
Set ws = Worksheets.Add(After:=Sheets(Sheets.Count))
ws.Name = Sheets("sheet1").Cells(i, 1)
Next i
End Sub


On Sun, Jul 10, 2011 at 10:23 PM, SAJID MEMON wrote:

>  Dears
>
> I have enclosed a simple file with my problem plz help me in my project.
>
> awaiting your positive responce
>
> Sajid Memon
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[Mahesh parab]

Hi Ashish

Heartiest Congratulations on your success ! Keep it up !





On Fri, Jul 1, 2011 at 10:20 PM, ashish koul  wrote:

> Thank you all
>
>
> On Fri, Jul 1, 2011 at 9:36 PM, Venkatesan c wrote:
>
>> *Dear Asish,*
>> *
>> *
>> *Congrats...*
>> *
>> *
>> *Best Regards,*
>> *Venkat*
>>   *
>> *
>>
>> On Fri, Jul 1, 2011 at 9:25 PM, Ayush  wrote:
>>
>>> Dear Group,
>>> I am extremely happy to share a good news with you. One of our dearest
>>> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
>>> his exceptional MS Excel skills and voluntary contribution.
>>> He is well deserving for the award and I am very happy and proud of his
>>> recognition. The guy has been top poster in the group from last 7-8 months.
>>>  Let see who becomes the next MVP from the group. The group has now
>>> three active MVPs.
>>>
>>> Dear Ashish,
>>> Many Many congratulations for the award.I am very proud of you to be part
>>> of this group.
>>> Keep your valuable contribution to the group. I wish your long
>>> association with this group.
>>> Cheers !!
>>> Best Regards,
>>> Ayush Jain
>>> Group Manager
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>>   *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

$$Excel-Macros$$ Find IE browsing history excel vba

[Mahesh parab]

Hi

below code retrieve internet browsing history in excel sheet, Amazing !

Try :

'unknown Author

Public Const ERROR_CACHE_FIND_FAIL As Long = 0
Public Const ERROR_CACHE_FIND_SUCCESS As Long = 1
Public Const ERROR_FILE_NOT_FOUND As Long = 2
Public Const ERROR_ACCESS_DENIED As Long = 5
Public Const ERROR_INSUFFICIENT_BUFFER As Long = 122
Public Const MAX_PATH As Long = 260
Public Const MAX_CACHE_ENTRY_INFO_SIZE As Long = 4096
Public Const LMEM_FIXED As Long = &H0
Public Const LMEM_ZEROINIT As Long = &H40
Public Const LPTR As Long = (LMEM_FIXED Or LMEM_ZEROINIT)
Public Const NORMAL_CACHE_ENTRY As Long = &H1
Public Const EDITED_CACHE_ENTRY As Long = &H8
Public Const TRACK_OFFLINE_CACHE_ENTRY As Long = &H10
Public Const TRACK_ONLINE_CACHE_ENTRY As Long = &H20
Public Const STICKY_CACHE_ENTRY As Long = &H40
Public Const SPARSE_CACHE_ENTRY As Long = &H1
Public Const COOKIE_CACHE_ENTRY As Long = &H10
Public Const URLHISTORY_CACHE_ENTRY As Long = &H20
Public Const URLCACHE_FIND_DEFAULT_FILTER As Long = NORMAL_CACHE_ENTRY Or _
COOKIE_CACHE_ENTRY Or _
URLHISTORY_CACHE_ENTRY
Or _

TRACK_OFFLINE_CACHE_ENTRY Or _
TRACK_ONLINE_CACHE_ENTRY
Or _
STICKY_CACHE_ENTRY
Private Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer
wHour As Integer
wMinute As Integer
wSecond As Integer
wMilliseconds As Integer
End Type
Private Type FILETIME
 dwLowDateTime As Long
 dwHighDateTime As Long
End Type
Private Type INTERNET_CACHE_ENTRY_INFO
 dwStructSize As Long
 lpszSourceUrlName As Long
 lpszLocalFileName As Long
 CacheEntryType As Long
 dwUseCount As Long
 dwHitRate As Long
 dwSizeLow As Long
 dwSizeHigh As Long
 LastModifiedTime As FILETIME
 ExpireTime As FILETIME
 LastAccessTime As FILETIME
 LastSyncTime As FILETIME
 lpHeaderInfo As Long
 dwHeaderInfoSize As Long
 lpszFileExtension As Long
 dwExemptDelta  As Long
End Type
Public Type Internet_Cache_Entry
 'dwStructSize As Long
 SourceUrlName As String
 LocalFileName As String
 'CacheEntryType  As Long
 UseCount As Long
 HitRate As Long
 Size As Long
 'dwSizeHigh As Long
 LastModifiedTime As Date
 ExpireTime As Date
 LastAccessTime As Date
 LastSyncTime As Date
 HeaderInfo As String
 'dwHeaderInfoSize As Long
 FileExtension As String
 'ExemptDelta  As Long
End Type
'==
'   Déclarations API
Private Declare Function FileTimeToLocalFileTime Lib "KERNEL32" (lpFileTime
As FILETIME, lpLocalFileTime As FILETIME) As Long
Private Declare Function FileTimeToSystemTime Lib "KERNEL32" (lpFileTime As
FILETIME, lpSystemTime As SYSTEMTIME) As Long
Private Declare Function LocalFileTimeToFileTime Lib "KERNEL32"
(lpLocalFileTime As FILETIME, lpFileTime As FILETIME) As Long
Private Declare Function SystemTimeToFileTime Lib "KERNEL32" (lpSystemTime
As SYSTEMTIME, lpFileTime As FILETIME) As Long
Private Declare Function FindFirstUrlCacheEntry Lib "Wininet.dll" _
 Alias "FindFirstUrlCacheEntryA" _
(ByVal lpszUrlSearchPattern As String, _
 lpFirstCacheEntryInfo As Any, _
 lpdwFirstCacheEntryInfoBufferSize As Long) As Long
Private Declare Function FindNextUrlCacheEntry Lib "Wininet.dll" _
 Alias "FindNextUrlCacheEntryA" _
(ByVal hEnumHandle As Long, _
 lpNextCacheEntryInfo As Any, _
 lpdwNextCacheEntryInfoBufferSize As Long) As Long
Private Declare Function FindCloseUrlCache Lib "Wininet.dll" _
 (ByVal hEnumHandle As Long) As Long
Public Declare Function DeleteUrlCacheEntry Lib "Wininet.dll" _
 Alias "DeleteUrlCacheEntryA" _
(ByVal lpszUrlName As String) As Long

Private Declare Sub CopyMemory Lib "KERNEL32" _
 Alias "RtlMoveMemory" _
 (pDest As Any, _
pSource As Any, _
ByVal dwLength As Long)
Private Declare Function lstrcpyA Lib "KERNEL32" _
(ByVal RetVal As String, ByVal Ptr As Long) As Long

Private Declare Function lstrlenA Lib "KERNEL32" _
(ByVal Ptr As Any) As Long

Private Declare Function LocalAlloc Lib "KERNEL32" _
 (ByVal uFlags As Long, _
ByVal uBytes As Long) As Long

Private Declare Function LocalFree Lib "KERNEL32" _
 (ByVal hMem As Long) As Long
Public Function GetURLCache(URL() As Internet_Cache_Entry, URLHistory() As
Internet_Cache_Entry, Cookies() As Internet_Cache_Entry)
 Dim ICEI As INTERNET_CACHE_ENTRY_INFO
 Dim hFile As Long
 Dim cachefile As String
 Dim posUrl As Long
 Dim posEnd As Long
 Dim dwBuffer As Long
 Dim pntrICE As Long

 dwBuffer = 0
 ReDim URL(0)
 ReDim URLHistory(0)
 ReDim Cookies(0)
 hFile = FindFirstUrlCacheEntry(0&, 

Re: $$Excel-Macros$$ small doubt help me.

[Mahesh parab]

Hi

i have sent with attachment

Try:
Sub test1()
Dim LR As Long, i As Long, j As Long, k As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
If Cells(1, 1).Value <> "" Then Cells(1, 1).EntireRow.Insert
Results = Array("Address :", "Area :", "Pin :", "Phone :")
Columns("A:A").Copy Destination:=ActiveSheet.Range("B1")
For p = 0 To UBound(Results, 1) Step 1
Columns("B:B").Replace What:=Results(p), Replacement:="",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
  Next
j = 1
k = 7
For i = 1 To LR
With Range("B" & i)
If .Value = "" Then
j = j + 1
k = 7
Else
k = k + 1
Cells(j, k).Value = .Value
End If
End With
Next i
Columns("B").Delete
Cells(1, 7) = "Company Name"
Cells(1, 8) = "Address"
Cells(1, 9) = "Area"
Cells(1, 10) = "Pincode"
Cells(1, 11) = "Phone No"
Columns("A:K").AutoFit
End Sub

Thanks
Mahesh

On Mon, Jun 20, 2011 at 8:52 PM, ICWAI Help  wrote:

> Can some one please provide the VB code or somehitng automationi for all
> this processure
>
>
> On Mon, Jun 20, 2011 at 5:16 PM, Vasant  wrote:
>
>> use copy, and then paste special with transpose
>>
>> On Mon, Jun 20, 2011 at 3:46 PM, kannan excel wrote:
>>
>>> Hi Guru
>>>
>>>
>>> Pls help me i am waiting for your reply.
>>>
>>>
>>> regards
>>>
>>> Kannan V
>>> 9941077703
>>> onechennaiproperty.com
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Regards
>>
>> Vasant
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

[Mahesh parab]

Hi

Try
=IF(COUNTIF(B:B,A2)>0,A2,"")

Thanks
Mahesh

On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR  wrote:

> I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
> THANKS IN ADVANCE..
>
> HARI
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

[Mahesh parab]

Hi Saravanan

check whether this help

http://www.rondebruin.nl/key.htm

Thanks
Mahesh

On Fri, Jun 17, 2011 at 8:35 PM, saravanan R  wrote:

> Hi Excelates,
>
> I need an Urgent help on disabling the Sort in the filter dropdown.
> Is there a way to disable only the short cut key i.e only the letter s
> & a in the Filter Drop down list.(available in the Excell 2007)
>
> thanks & regards,
> Saravanan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Email address is not showing in the from option

[Mahesh parab]

Hi

check

http://www.rondebruin.nl/mail/tips2.htm

On Mon, Jun 6, 2011 at 11:48 PM, Mahesh parab  wrote:

> Hi
>
> which version of Excel you are using ?
> in 2007 its .SendUsingAccount property
> in 2003 its .SentOnBehalfOfName property
> can you send sample workbook.
>
>
> Thanks,
> Mahesh
>
>   On Mon, Jun 6, 2011 at 9:47 PM, Simran Singh wrote:
>
>> Hello experts,
>>
>> I am using email sending macro to send emails to the employees internally,
>> sometimes I have to send email from a particular DL for which i use below
>> mention line in the coding but it is not showing any DL name in from box.
>>
>> .from=email address.
>> .to=employee email address
>>
>> Kindly look into the matter. thanks in advance.
>>
>> Regards,
>> Simran Singh
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Email address is not showing in the from option

[Mahesh parab]

Hi

which version of Excel you are using ?
in 2007 its .SendUsingAccount property
in 2003 its .SentOnBehalfOfName property
can you send sample workbook.


Thanks,
Mahesh

On Mon, Jun 6, 2011 at 9:47 PM, Simran Singh  wrote:

> Hello experts,
>
> I am using email sending macro to send emails to the employees internally,
> sometimes I have to send email from a particular DL for which i use below
> mention line in the coding but it is not showing any DL name in from box.
>
> .from=email address.
> .to=employee email address
>
> Kindly look into the matter. thanks in advance.
>
> Regards,
> Simran Singh
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Print only A3:K

[Mahesh parab]

Try :

Sub test()
Sheet1.PageSetup.PrintArea = "$A$3:$K$100"
Sheet1.PrintOut , , 1
End Sub

On Mon, Jun 6, 2011 at 3:01 PM, Daniel  wrote:

> A guess :
>
> Sub RangePrint()
> Dim Rg As Range
> With Sheets("Sheet1")
>Set Rg = .Range(.[A3], .Cells(Rows.Count, "K").End(xlUp))
>Rg.PrintOut
> End With
> End Sub
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> De
> la part de Bob
> Envoyé : lundi 6 juin 2011 02:12
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ Print only A3:K
>
> How do you write a macro to print Sheet1, A3:K only. Nothing from L over.
> Thanks in advance!!!
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
> Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Help on macro to next empty worksheet to another workbook

[Mahesh parab]

Hi

Try :

Sub Test()
Dim ws As Worksheet
Sheets("Brands").Select
Sheets("Brands").UsedRange.Copy
Windows("Comparsheet.xls").Activate
For Each ws In Worksheets
If ws.UsedRange.Cells.Count < 1 Then ws.Delete
Next ws
Application.DisplayAlerts = True
Set ws = Worksheets.Add(After:=Sheets(Sheets.Count))
'ws.Name = ActiveSheet.Name
With ws
ws.Range("A1").PasteSpecial Paste:=xlPasteValues
End With
Application.CutCopyMode = False
End Sub


On Wed, Jun 1, 2011 at 3:37 PM, Jorge Marques  wrote:

> Hi guys i have this macro to copy paste sheets to another sheet on another
> workbook, can you help me?i need everytime i run the macro to paste it to
> the next blank worksheet of the destiny workbook. 1001 thanks in advance
>
>
> Sub copy_another_sheet()
> '
> ' copy Macro
> '
> ' Atalho por teclado: Ctrl+p
> '
>
> Application.ScreenUpdating = False
> Sheets("Brands").Select
> Cells.Select
> Selection.copy
> Windows("Comparsheet.xlsx").Activate
> Sheets("Sheet1").Select  --> I think i
> have to change this but i don´t know how!
> Cells.Select
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
> :=False, Transpose:=False
> Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
> SkipBlanks:=False, Transpose:=False
> Windows("Brand.xlsx").Activate
> Range("A1").Select
> Application.ScreenUpdating = True
>
> End Sub
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ MAC Address

[Mahesh parab]

Hi

try:
For Each objAdapter In colAdapters
Cells(1, 1) = "Physical address: " & objAdapter.MACAddress
Next objAdapter
End Sub

On Sun, May 29, 2011 at 4:46 PM, Rajesh K R wrote:

> HI
>
> What are the changes required to get the result in a cell instead of msg
> box.
>
> Regards
>
> Rajesh kainikkara
>
>
> On 5/28/11, GoldenLance  wrote:
> > This is because MAC addresses are attached physically to the network
> > adapter hardware and not to the base computer itself. Computers with
> > multiple network adapters installed (sometimes called multihomed
> > systems) therefore possess multiple unique MAC addresses.
> >
> > On May 28, 7:47 pm, Mahesh parab  wrote:
> >> Hi Rajesh
> >>
> >> dont know about this in details, other way you can enter ipconfig/all in
> >> cmd
> >> prompt and find Physical address i.e MAC address
> >> check info on below linkhttp://ecs.rutgers.edu/physicaladdr.php3
> >> Thanks
> >> Mahesh
> >> On Sat, May 28, 2011 at 7:16 PM, Rajesh K R
> >> wrote:
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> > Hi
> >> > Thanks for the reply. It shows two different results eg
> >> > 00.1C:10:F2:FO:C6 then 00:10:IF:08:15
> >> > what does it mean will u explain it a little bit more.
> >>
> >> > Reagards & Thanks
> >>
> >> > Rajesh kainikkara
> >>
> >> > On 5/27/11, Mahesh parab  wrote:
> >> > > Hi Rajesh
> >> > > Try:
> >> > > Sub test()
> >> > > Dim strComputer As String
> >> > > Dim objWMIService As Object
> >> > > Dim colAdapters As Object
> >> > > Dim objAdapter As Object
> >> > > strComputer = "."
> >> > > Set objWMIService = GetObject _
> >> > > ("winmgmts:" & "!\\" & strComputer & "\root\cimv2")
> >> > > Set colAdapters = objWMIService.ExecQuery _
> >> > > ("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled =
> >> > True")
> >> > > For Each objAdapter In colAdapters
> >> > > MsgBox "Physical address: " & objAdapter.MACAddress
> >> > > Next objAdapter
> >> > > End Sub
> >>
> >> > > On Fri, May 27, 2011 at 8:37 PM, Rajesh K R
> >> > > wrote:
> >>
> >> > >> Hi Experts
> >>
> >> > >> Is there any code to get MAC address of the computer.
> >>
> >> > >> Regards
> >> > >> Rajesh kainikkara
> >>
> >> > >> --
> >>
> >> >
> --
> >> > >> Some important links for excel users:
> >> > >> 1. Follow us on TWITTER for tips tricks and links :
> >> > >>http://twitter.com/exceldailytip
> >> > >> 2. Join our LinkedIN group
> >> > >> @http://www.linkedin.com/groups?gid=1871310
> >> > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >>
> >> > >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> > >> <><><><><><><><><><><><><><><><><><><><><><>
> >> > >> Like our page on facebook , Just follow below link
> >> > >>http://www.facebook.com/discussexcel
> >>
> >> > > --
> >>
> >> >
> --
> >> > > Some important links for excel users:
> >> > > 1. Follow us on TWITTER for tips tricks and links :
> >> > >http://twitter.com/exceldailytip
> >> > > 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >>
> >> > > To post to this group, send email to excel-macros@googl

Re: $$Excel-Macros$$ How to change Date format in to number

[Mahesh parab]

Hi

Try

Sub Format()
Dim LR, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
Range("A" & i).Offset(0, 1).Value = Range("A" & i).Value
Range("A" & i).NumberFormat = "mmdd"
Range("A" & i).Offset(0, 1).NumberFormat = "mmdd"
Next i
End Sub

Thanks
Mahesh

On Sun, May 29, 2011 at 9:35 AM, Prabhu  wrote:

> Hi Friends,
>
> I have change my cell which in the date format ex.MMDD or DDMM to
> original number i.e smiler to
> type date.I have attached the sheet in which Column A shows date format and
> Column B is what i need to convert A in to B as a number.
>
> Plz help.
>
> Regards
>
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Re: How to remove space in excel cell

[Mahesh parab]

Hi Prabhu

 Try

'=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))

http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-beginning-and-end-of-a-cell-HP003056131.aspx

Thanks

Mahesh

On Sun, May 29, 2011 at 9:55 AM, Prabhu  wrote:

> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
> But below formula is not working.
>
> Kind do the needful.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ MAC Address

[Mahesh parab]

Hi Rajesh

dont know about this in details, other way you can enter ipconfig/all in cmd
prompt and find Physical address i.e MAC address
check info on below link
http://ecs.rutgers.edu/physicaladdr.php3
Thanks
Mahesh
On Sat, May 28, 2011 at 7:16 PM, Rajesh K R wrote:

> Hi
> Thanks for the reply. It shows two different results eg
> 00.1C:10:F2:FO:C6 then 00:10:IF:08:15
> what does it mean will u explain it a little bit more.
>
> Reagards & Thanks
>
> Rajesh kainikkara
>
> On 5/27/11, Mahesh parab  wrote:
> > Hi Rajesh
> > Try:
> > Sub test()
> > Dim strComputer As String
> > Dim objWMIService As Object
> > Dim colAdapters As Object
> > Dim objAdapter As Object
> > strComputer = "."
> > Set objWMIService = GetObject _
> > ("winmgmts:" & "!\\" & strComputer & "\root\cimv2")
> > Set colAdapters = objWMIService.ExecQuery _
> > ("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled =
> True")
> > For Each objAdapter In colAdapters
> > MsgBox "Physical address: " & objAdapter.MACAddress
> > Next objAdapter
> > End Sub
> >
> >
> >
> > On Fri, May 27, 2011 at 8:37 PM, Rajesh K R
> > wrote:
> >
> >> Hi Experts
> >>
> >> Is there any code to get MAC address of the computer.
> >>
> >> Regards
> >> Rajesh kainikkara
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ MAC Address

[Mahesh parab]

Hi Rajesh
Try:
Sub test()
Dim strComputer As String
Dim objWMIService As Object
Dim colAdapters As Object
Dim objAdapter As Object
strComputer = "."
Set objWMIService = GetObject _
("winmgmts:" & "!\\" & strComputer & "\root\cimv2")
Set colAdapters = objWMIService.ExecQuery _
("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled = True")
For Each objAdapter In colAdapters
MsgBox "Physical address: " & objAdapter.MACAddress
Next objAdapter
End Sub



On Fri, May 27, 2011 at 8:37 PM, Rajesh K R wrote:

> Hi Experts
>
> Is there any code to get MAC address of the computer.
>
> Regards
> Rajesh kainikkara
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Formula required

[Mahesh parab]

Hi Vikarm

check this link
http://www.exceltip.com/st/Preventing_Duplicates_When_Entering_Data/886.html

Thanks
Mahesh

On Mon, May 16, 2011 at 11:07 PM, vikram  wrote:

>  Hi,
>
>
>
> Please help regarding formula for validation:
>
>
>
> If we enter any numeric value in particular column it does not allow a
> duplicate entry and shows error message.
>
>
>
> For example;if we enter 1 to 5 numeric value in particular column and try
> to enter 1 again or any value between already entered value it shows error
> message and does allow user to enter any value.
>
>
>
> Regards,
>
>
>
> Vikram
>
>
>
>
>
>
>
>
>
>
>
> Download: www.eType.com 
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Excel Macro Request!

[Mahesh parab]

Hi
Try

Sub fillUp()
Dim lLastRow As Long
Dim lCounter As Long
Dim sThisCust As String
lLastRow = Cells(Rows.Count, "B").End(xlUp).Row
sThisCust = Cells(1, "B")
For lCounter = 2 To lLastRow
If Trim((Cells(lCounter, "B")) = "") Then
Cells(lCounter, "B") = sThisCust
Else
sThisCust = Cells(lCounter, "B")
End If
Next
End Sub


On Sun, May 15, 2011 at 10:12 PM, ashish koul  wrote:

> try this
>
> http://www.contextures.com/xlDataEntry02.html
>
> Fill Blank Cells From Above
> http://www.contextures.com/Excel-Videos-Data-Entry.html#FillBlanks
>
>
> On Sun, May 15, 2011 at 11:34 AM, Prabhu  wrote:
>
>> Hi friends,
>>
>> I need a macro for a selected column to fill previous cell
>> automatically where ever blank cell in the sheet.This Macro should
>> copy the previous cell content.I.e. B2 has "xxx" B3 and B4 is blank
>> means when we run the macro from B2 to B4 should show "xxx".
>>
>> Request. Filling must be column wise not row wise.
>>
>> Regards,
>>
>> Prabhu
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Copy some files from a folder to another folder

[Mahesh parab]

Hi Ashish

well done ! Appreciate your knowledge & help !

On Sat, May 14, 2011 at 12:19 PM, ashish koul  wrote:

> use move to move files and copy to copy the files
>
>
> Public f As Object, d As Object
> Sub Main()
>
> Dim Fso As Object
> Set Fso = CreateObject("Scripting.FileSystemObject")
> Set RootFolder = Fso.GetFolder("C:\Documents and
> Settings\ashish\Desktop\ashish koul")
> FolderRead RootFolder
> End Sub
> Sub FolderRead(ByRef myFolder)
> Dim sw As Object
> Set sw = CreateObject("Scripting.FileSystemObject")
>For Each f In myFolder.Files
> Var = f.Path
> If Right(f.Name, 4) = ".xls" Or Right(f.Name, 5) = ".xlsx" Then
>
>   sw.copyFile f.Path, "C:\Documents and Settings\ashish\Desktop\excel\"
>
> 'sw.MoveFile f.Path, "C:\Documents and Settings\ashish\Desktop\excel\"
>End If
>
>
>If Right(f.Name, 5) = ".jpeg" Then
> sw.copyFile f.Path, "C:\Documents and Settings\ashish\Desktop\jpeg\"
> 'sw.MoveFile f.Path, "C:\Documents and Settings\ashish\Desktop\jpeg\"
>End If
>
> If Right(f.Name, 4) = ".pdf" Then
>
> sw.copyFile f.Path, "C:\Documents and Settings\ashish\Desktop\pdf\"
>
> 'sw.MoveFile f.Path, "C:\Documents and Settings\ashish\Desktop\pdf\"
>End If
>
>Next f
>For Each d In myFolder.SubFolders
>  FolderRead d
>Next d
> End Sub
>
>
>
>
> On Sat, May 14, 2011 at 7:15 AM, Rafael Bruno wrote:
>
>> Hi friends,
>>
>> I have a simple request that it's confusing me. I have a folder (let's
>> call "c:\motherfolder\"), that has thousands of subfolders. In each
>> subfolder there are 3 files: 1 .pdf, 1 excel (may be .xls or .xlsx), and 1
>> .jpeg.
>> I need to copy all pdfs to one folder (let's say "c:\pdfs_folder\"), all
>> excel files to another, and all jpegs to another.
>>
>> Can it be done? A long time ago (years) I remember doing something
>> similar, but only with .xls files (and even this I can't remember how).
>>
>> Thanks in advance,
>> Rafael
>>  WebRep
>> Overall rating
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Rank the data

[Mahesh parab]

Hi Rajesh

Try
in F5 cell use below formula and drag it
'=RANK(E5,$E$5:$E$14)


On Fri, May 13, 2011 at 8:20 PM, Rajesh K R wrote:

> Hi Experts,
>
> Pls find the attachment and tell me how to rank the rooms as per the
> collection received from them.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Please help to make my project good.

[Mahesh parab]

Hi

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

> Respected Sirs/Mam,
>
> I need your help making my project good.  Please find attachment. I will be
> very obliged if someone can help me as earlier as possible.
>
> --
> Basically I have to do that when I click on drop down list & select another
> career i.e. Building and Construction so In sub career list data should
> comes from the Building and construction's sheet and If I select another
> career i.e. Catering and Hospitality so data should comes from its list
> (Catering and Hospitality) and scroll bar should work with the same. I have
> 16 careers so please tell me how can I do this.
>
>
> Thnx in Advance
>
> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Help_Required_Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help Please

[Mahesh parab]

Hi
check attach, whether its as per u r requirement

On Tue, May 3, 2011 at 8:29 PM, m7md.gmail  wrote:

> all,
> please i need help to solve my problem
>
> if there cell i give it red color in another cell record the date whose i
> colored 1st cell - if there any function make this
>
>
> **
> *
> --
> *
>
> Regards,
>
> Mohamed Mahmoud
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


Colour_CELL.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ HELP SECOND MAIL

[Mahesh parab]

Hi

it would be great if u could explain some steps; it seems confusing, keep it
as simple as you can;
which is the first step, what are the 6 vlookups ? which workbook contain
base data of your pivot.


On Mon, May 2, 2011 at 10:07 AM, Prathima R  wrote:

> Hi Experts,
>
>
> Due size constance i am sending in two zip folders please check second mail
> for excel files dump.
>
> (This is Second mail please check this  one as well -- thanks
> for cooperation)
>
> This report is sent on daily basis please help in this concern if it is
> automated
> it could be very much thankful really wonderful thing . please find the
> attached sop and zipped folder which contains all the raw data .
>
> Please kindly help in this concern if it is possible .
>
> it has 6 v lookups  and two pivot tabs.
>
> Thanks for your help in advance.
>
> Regards,
> Prathima
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Copy and paste

[Mahesh parab]

Hi Bob

it would be great if you could provide sample file, you will get solution
from other members as well

On Sun, May 1, 2011 at 5:32 PM, Bob  wrote:

> Saying that the copy and paste area are not the same size. But I
> changed to same size and still will not work. Thanks for your help!!
> Getting an error here:
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
>:=False, Transpose:=FalseOn May 1, 1:49 am, Mahesh parab
>  wrote:
> > Hi Bob
> > Try
> >
> > Sub copydata()
> > 'Copy contents from Sheet2 Columns A & B
> > Sheets("Sheet2").Select
> > Range("B1").End(xlDown).Select
> > Temp1 = ActiveCell.Address
> > Range("A1" & ":" & Temp1).Select
> > Selection.Copy
> > 'Paste contents on next available blank row on Sheet1 in Columns A & B
> > Sheets("Sheet1").Select
> > Range("A1").End(xlDown).Offset(1).Select
> > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
> > :=False, Transpose:=False
> > Application.CutCopyMode = False
> > End Sub
> >
> >
> >
> > On Sun, May 1, 2011 at 3:06 AM, Bob  wrote:
> > > I'd like some help in Copying and Pasting in different worksheets.
> > > Copy contents from Sheet2 Columns A & B
> > > Paste contents on next available blank row on Sheet1 in Columns A & B
> > > Thanks in advance!
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Copy and paste

[Mahesh parab]

Hi Bob
Try

Sub copydata()
'Copy contents from Sheet2 Columns A & B
Sheets("Sheet2").Select
Range("B1").End(xlDown).Select
Temp1 = ActiveCell.Address
Range("A1" & ":" & Temp1).Select
Selection.Copy
'Paste contents on next available blank row on Sheet1 in Columns A & B
Sheets("Sheet1").Select
Range("A1").End(xlDown).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
On Sun, May 1, 2011 at 3:06 AM, Bob  wrote:

> I'd like some help in Copying and Pasting in different worksheets.
> Copy contents from Sheet2 Columns A & B
> Paste contents on next available blank row on Sheet1 in Columns A & B
> Thanks in advance!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Macro Help

[Mahesh parab]

Hi

Try

Sub Test()
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If IsError(Cells(i, "A")) Then
Cells(i, "A").EntireRow.Delete
End If
Next i
End Sub

On Fri, Apr 15, 2011 at 3:24 PM, Prabhu  wrote:

> Hi,
>
> I want to delete particular rows only in my work sheet which contains #N/A
> in a particular column?
>
> Assuming the column containing the #N/A errors is column A, and i need to
> delete the entire row where '#N/A' if found in column A.
>
> Plz help with macro code *which should delete enter #N/A at one time not
> line by line*.
>
> Regards,
> Prabhu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ querry

[Mahesh parab]

Thanks Siti, Ranjan

for sharing useful information

On Mon, Apr 11, 2011 at 1:25 PM, rajan verma wrote:

> *"=_xlfn shows that the following Fuction exist in higher Version of excel
>  but not in Lower Version.. Exce Automatically Include =_xlfn .. when file
> open in Lower Version of Excel,,*
>
>  On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan wrote:
>
>> Dear Ashish,
>>
>> Pl. explain what is *"=_xlfn."*
>> SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5)
>>
>>
>>
>> Regards,
>>
>> Dhananjay
>>
>>   On Sat, Apr 9, 2011 at 4:07 PM, ashish koul wrote:
>>
>>> see if it helps
>>>
>>>
>>> On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi wrote:
>>>
 Please reply.

 --
 Nemi Gandhi
 98204 92963

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

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

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ querry

[Mahesh parab]

Hi Nemi

find attach

On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi  wrote:

> Please reply.
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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


QUERRY_Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Compare strings in cells, return differences

[Mahesh parab]

Well done Seti ! Appreciate your knowledge & Help in this forum

On Fri, Apr 8, 2011 at 1:23 PM, SHC wrote:

> Thanks STDEV(i) - very appreciated.
>
>
> On Apr 8, 6:29 am, "STDEV(i)"  wrote:
> > *=TextDif(A2,B2)*
> >
> > TextDif is an UDF, like this:
> >
> > Function TextDif(S1 As String, S2 As String) As String
> >Dim Arr1, Arr2
> >Dim n As Integer, i As Integer, t As String
> >
> >Arr1 = Split(S1, ","): Arr2 = Split(S2, ",")
> >
> >For i = LBound(Arr2) To UBound(Arr2)
> >   For n = LBound(Arr1) To UBound(Arr1)
> >  If Arr1(n) = Arr2(i) Then Arr2(i) = ""
> >   Next n
> >Next i
> >
> >For i = LBound(Arr2) To UBound(Arr2)
> >   If Len(Arr2(i)) > 0 Then t = t & Arr2(i) & ","
> >Next i
> >
> >TextDif = t
> >If Len(t) > 0 Then TextDif = Left(t, Len(t) - 1)
> > End Function
> >
> > On Fri, Apr 8, 2011 at 4:46 AM, SHC  >wrote:
> >
> >
> >
> >
> >
> >
> >
> > > I'd like a function script that compares the strings from two cells,
> > > and returns, in a third cell, the parts of the 2nd string that do not
> > > match parts of the 1st string (I don't need to return the parts of 1st
> > > string that do not match parts of the 2nd string).
> >
> > > Examples:
> > > Cell1: Chris
> > > Cell2: Carl,Chris,Peter
> > > Result in Cell3: Carl,Peter
> >
> > > Cell1: Chris,Carl
> > > Cell2: Carl,Peter,Chris
> > > Result in Cell3: Peter
> >
> > > Cell1: Chris,Dave
> > > Cell2: Carl,Chris,Peter
> > > Result: Carl,Peter
> >
> > > Cell1: Chris,Dave,Peter,Carl
> > > Cell2: Dave,Chris,Carl
> > > Cell3 is empty
> >
> > > Note, parts of the strings (separated by commas) will not necessarily
> > > be in the same order.
> >
> > > Any help would be most appreciated
> >
> > > Thanks.
> >
> >
> >
> >  ctv_TextDif about Chris and Peter.xls
> > 29KViewDownload
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Excel help

[Mahesh parab]

Hi

Use
=SUBSTITUTE(A1,"0","")

On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash  wrote:

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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

Re: $$Excel-Macros$$ Help in Excel

[Mahesh parab]

Hi

this link will help u

http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx



On Wed, Mar 9, 2011 at 4:07 PM, Rajiv Kumar  wrote:

>
> Dear Sir.
>
>
> Please Experts I have duplicates data from one column so how do complete
> data from duplicate with vlookup and any more...
>
> Plz find attc.
>
>
>
>
>
>
>
>
>
>
>
> --
> *Thanks & Regards
>
> *
> *Rajiv Kumar
> *
> *Mawana Sugar Works, Mawana
> *
> *Mo.No: 09027414899*
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

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