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

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

$$Excel-Macros$$ Find specified word is contained in a text string

[mahesh parab]

Dear All

i need help to modify below mention user define function. i got this code on
below mention link.
i herewith attach the excel sheet. I will appreciate any help on this.
http://spreadsheetpage.com/index.php/tip/is_a_particular_word_contained_in_a_text_sring

I want to modify this user define Function so the code will reflect in H2
Cell when I enter the formula
E1 value will check in Range F:F column
if find then offset Active.cell



Function ExactWordInString(Text As String, Word As String) As Boolean
ExactWordInString = " " & UCase(Text) & " " Like "*[!A-Z]" & UCase(Word) &
"[!A-Z]*"
End Function

Thank You,

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

ExactWordInString.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Find specified word is contained in a text string

[mahesh parab]

Hi Praveen

Thank you so much ! it's amazing , i appreciate your knowledge & help.

On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar wrote:

> Hi Mahesh,
>
> Use this function along with the Exactwordinstring function.
>
> Function checkthis(Text As String, rng As Range)
> For Each entry In rng
> result = ExactWordInString(Text, entry.Value)
> If result Then
> checkthis = entry.Offset(0, 1).Value
> End If
> Next
> End Function
>
> Now in cell h2 write the formula *=checkthis(E2,F:F) *
> This should give you the desired result.
>
> Let me know if this helps
>
> Regards,
> Praveen
>
>
> On Wed, Dec 23, 2009 at 11:09 PM, mahesh parab  wrote:
>
>> Dear All
>>
>> i need help to modify below mention user define function. i got this code
>> on below mention link.
>> i herewith attach the excel sheet. I will appreciate any help on this.
>>
>> http://spreadsheetpage.com/index.php/tip/is_a_particular_word_contained_in_a_text_sring
>>
>> I want to modify this user define Function so the code will reflect in H2
>> Cell when I enter the formula
>> E1 value will check in Range F:F column
>> if find then offset Active.cell
>>
>>
>>
>> Function ExactWordInString(Text As String, Word As String) As Boolean
>> ExactWordInString = " " & UCase(Text) & " " Like "*[!A-Z]" & UCase(Word) &
>> "[!A-Z]*"
>> End Function
>>
>> Thank You,
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. Let friends and co-workers know they can
>> subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Merge Cell value in single cell

[mahesh parab]

Dear All


I need help in attach sheet,if value in column B is same then, it merge cell
of A column, in one cell,
till column B contain same value. i go through net but didnt get any such
formula or
vb code.

I will appreciate any help on this.




i am trying to modify below mention code as per my requirement but it didnt
works.

Sub BT()
Const iCol  As Long = 1 ' pick your column

Dim iRowAs Long
Dim jRowAs Long
Dim cellAs Excel.Range
Dim rMrgAs Excel.Range

iRow = 2' pick your start row
Application.DisplayAlerts = False

Do while not IsEmpty(Cells(iRow, iCol))
  Set rMrg = Cells(iRow, iCol)
  jRow = 1

  Do While Cells(iRow + jRow, iCol).Value = Cells(iRow, iCol).Value
Set rMrg = Union(rMrg, Cells(iRow + jRow, iCol))
jRow = jRow + 1
  Loop

  rMrg.Merge
  iRow = iRow + jRow
Loop
Application.DisplayAlerts = True
End Sub

-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


sample merge cell.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Merge Cell value in single cell

[mahesh parab]

Hi Alokeshwar

Thank you so much for your help, Can you explain if condition if you can !
it will enhance my knowledge



Hi Praveen

Again, Thank you so much for your help & better explanation of your code.


On Sun, Dec 27, 2009 at 6:37 PM, kvc praveen kumar wrote:

> Hi,
>
> You can try the following code:
>
> I wrote two macros: Mergecontents and move contents.
> Mergecontents will merge teh contents into the d column of your last row of
> the email pattern
> movecontents can be used to move the result to the first row of your email
> pattern
>
> Execute the mergecontents first and then the movecontants.
>
> Let me know if this helps!!
>
> Regards,
> Praveen
>
> *Sub mergecontents()
> ' Coded by Praveen
> ' This code sets up the CC into D column into the last row of the email id
> pattern
>
> last_row = Range("B65536").End(xlUp).Row 'To Retrieve the last Row in col B
> First_val = Range("b2").Value   'Setting up Initial Value
> curr_first_row = 2  'curr_first_row indicates the first row of new
> email id pattern found
> For i = 2 To last_row + 1
> curr_val = Range("B" & i).Value
> If (curr_val = First_val) Then
> If (i <> 2) Then
> 'For all rows except first row concatenating the contents with ";"
> Range("D" & i).Value = Range("D" & i - 1).Value & ";" & Range("A" &
> i).Value
> Else
> ' This is executed only for the first row
> Range("D" & i).Value = Range("A" & i).Value
> End If
> Else
> ' Removing Unnecessary contents in othe rows
> For j = curr_first_row To i - 2
> Range("D" & j).Value = ""
> Next
> ' setting up values for the next email id pattern
> curr_first_row = i
> First_val = curr_val
> Range("D" & i).Value = Range("A" & i).Value
> End If
> Next
> End Sub
>
> Sub movecontents()
> ' This code can be used to move the contents to the first row of your email
> pattern
> last_row = Range("D65536").End(xlUp).Row 'To Retrieve the last Row in col D
> fill_row = 2
> For i = 2 To last_row
> If Range("D" & i) <> "" Then
> Range("D" & fill_row) = Range("D" & i)
> Range("D" & i) = ""
> fill_row = i + 1
> End If
> Next
> End Sub*
>
>
> On Sun, Dec 27, 2009 at 11:50 AM, mahesh parab  wrote:
>
>> Dear All
>>
>>
>> I need help in attach sheet,if value in column B is same then, it merge
>> cell of A column, in one cell,
>> till column B contain same value. i go through net but didnt get any such
>> formula or
>> vb code.
>>
>> I will appreciate any help on this.
>>
>>
>>
>>
>> i am trying to modify below mention code as per my requirement but it
>> didnt works.
>>
>> Sub BT()
>> Const iCol  As Long = 1 ' pick your column
>>
>> Dim iRowAs Long
>> Dim jRowAs Long
>> Dim cellAs Excel.Range
>> Dim rMrgAs Excel.Range
>>
>> iRow = 2' pick your start row
>> Application.DisplayAlerts = False
>>
>> Do while not IsEmpty(Cells(iRow, iCol))
>>   Set rMrg = Cells(iRow, iCol)
>>   jRow = 1
>>
>>   Do While Cells(iRow + jRow, iCol).Value = Cells(iRow, iCol).Value
>> Set rMrg = Union(rMrg, Cells(iRow + jRow, iCol))
>> jRow = jRow + 1
>>   Loop
>>
>>   rMrg.Merge
>>   iRow = iRow + jRow
>> Loop
>> Application.DisplayAlerts = True
>> End Sub
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us in TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><>&

$$Excel-Macros$$ Auto Filter data & copy to another sheet

[mahesh parab]

Dear All
I herewith attach sample workbook, I need help for macro which autofilter
data & copy to another sheet.
 below mention are the steps, I will appreciate any help on this.

Auto Filter Date 2(Column C)
Select First Month (eg.May 09)
Auto Filter Date 1 (Column B)
from the month which filter in Date 2 (from May 09 to Dec 09..last month of
year)
Auto Filter Column A
Copy each unique value on output sheet


Thank You

-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Sample Data.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help required for Macro_Autofilter & copy data

[mahesh parab]

   If CCount = 0 Then
MsgBox "There are more than 8192 areas for the value : " &
cell.Value _
 & vbNewLine & "It is not possible to copy the visible
data." _
 & vbNewLine & "Tip: Sort your data before you use this
macro.", _
   vbOKOnly, "Split in worksheets"
Else
'Add new workbook with one sheet
Set WSNew = Workbooks.Add(xlWBATWorksheet).Worksheets(1)

'Copy/paste the visible data to the new workbook
My_Range.SpecialCells(xlCellTypeVisible).Copy
With WSNew.Range("A1")
' Paste:=8 will copy the columnwidth in Excel 2000 and
higher
' Remove this line if you use Excel 97
.PasteSpecial Paste:=8
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
.Select
End With

'Save the file in the new folder and close it
On Error Resume Next
WSNew.Parent.SaveAs foldername & _
cell.Value & FileExtStr, FileFormatNum
If Err.Number > 0 Then
Err.Clear
ErrNum = ErrNum + 1

WSNew.Parent.SaveAs foldername & _
"Error_" & Format(ErrNum, "") &
FileExtStr, FileFormatNum

.Cells(cell.Row, "B").Formula = "=Hyperlink(""" &
foldername & _
"Error_" &
Format(ErrNum, "") & FileExtStr & """)"

.Cells(cell.Row, "A").Interior.Color = vbRed
Else
.Cells(cell.Row, "B").Formula = _
"=Hyperlink(""" & foldername & cell.Value & FileExtStr &
""")"
End If

WSNew.Parent.Close False
On Error GoTo 0
End If

'Show all the data in the range
My_Range.AutoFilter Field:=FieldNum

Next cell
.Cells(1, "A").Value = "Red cell: can't use the Unique name as file
name"
.Cells(1, "B").Value = "Created Files (Click on the link to open a
file)"
.Cells(3, "A").Value = "Unique Values"
.Cells(3, "B").Value = "Full Path and File name"
.Cells(3, "A").Font.Bold = True
.Cells(3, "B").Font.Bold = True
.Columns("A:B").AutoFit

End With

'Turn off AutoFilter
My_Range.Parent.AutoFilterMode = False

If ErrNum > 0 Then
MsgBox "Rename every WorkSheet name that start with ""Error_""
manually" _
 & vbNewLine & "There are characters in the name that are not
allowed" _
 & vbNewLine & "in a sheet name or the worksheet already exist."
End If

'Restore ScreenUpdating, Calculation, EnableEvents, 
My_Range.Parent.Select
ActiveWindow.View = ViewMode
ws2.Select
With Application
.ScreenUpdating = True
.EnableEvents = True
.Calculation = CalcMode
End With

End Sub





On 1/5/10, mahesh parab  wrote:
>
> Dear All
>
> I need help for attach file, i write a macro to filter date & copy data but
> i am not
> getting desire output, Can anyone able to find out the reason. Required
> results are
> mention in attach sheet.
>
> below mention is a part of macro which work perfect & filter data but when
> i add macro to copy unique data to another folder AutoFilter Field:=2, not
> working dont knw why. Code is mention in Module 2
>
>
>
> Sub Macrom()
> Dim mydate As Date
>
> mydate = Range("H1").Value
>
>   Selection.AutoFilter
> ActiveSheet.Range("$A$1:$C$35").AutoFilter Field:=3, Criteria1:="=" &
> mydate _
> , Operator:=xlAnd
> ActiveSheet.Range("$A$1:$C$35").AutoFilter Field:=2, Criteria1:= _
> ">=" & mydate, Operator:=xlAnd
>
>
> End Sub
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
&g

$$Excel-Macros$$ Final Code

[mahesh parab]

Sub Macroms()
Dim mydate As Date
Dim wsm As Worksheet
'
' Macro5 Macro
'

'
mydate = Range("H1").Value

  Selection.AutoFilter
ActiveSheet.Range("$A$1:$C$100").AutoFilter Field:=3, Criteria1:="=" &
mydate _
, Operator:=xlAnd
ActiveSheet.Range("$A$1:$C$100").AutoFilter Field:=2, Criteria1:= _
">=" & mydate, Operator:=xlAnd


Cells.Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Set wsm = Worksheets.Add(After:=Sheets(Sheets.Count))
wsm.Name = "Mahesh"
'Sheets.Add After:=Sheets(Sheets.Count)

ActiveSheet.Paste




'End Sub

Dim My_Range As Range
Dim FieldNum As Long
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim CalcMode As Long
Dim ViewMode As Long
Dim ws2 As Worksheet
Dim MyPath As String
Dim foldername As String
Dim Lrow As Long
Dim cell As Range
Dim CCount As Long
Dim WSNew As Worksheet
Dim ErrNum As Long

'Set filter range on ActiveSheet: A11 is the top left cell of your
filter range
'and the header of the first column, D is the last column in the filter
range.
'You can also add the sheet name to the code like this :
'Worksheets("Sheet1").Range("A11:D" & LastRow(Worksheets("Sheet1")))
'No need that the sheet is active then when you run the macro when you
use this.
Set My_Range = Range("A1:C" & LastRow(ActiveSheet))
My_Range.Parent.Select

If ActiveWorkbook.ProtectStructure = True Or _
   My_Range.Parent.ProtectContents = True Then
MsgBox "Sorry, not working when the workbook or worksheet is
protected", _
   vbOKOnly, "Copy to new workbook"
Exit Sub
End If

'This example filters on the first column in the range(change the field
if needed)
'In this case the range starts in A so Field:=1 is column A, 2 = column
B, ..
 FieldNum = 1

'Turn off AutoFilter
 'My_Range.Parent.AutoFilterMode = False




'Set the file extension/format
If Val(Application.Version) < 12 Then
'You use Excel 97-2003
FileExtStr = ".xls": FileFormatNum = -4143
Else
'You use Excel 2007
If ActiveWorkbook.FileFormat = 56 Then
FileExtStr = ".xls": FileFormatNum = 56
Else
FileExtStr = ".xlsx": FileFormatNum = 51
End If
End If

'Change ScreenUpdating, Calculation, EnableEvents, 
With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
.EnableEvents = False
End With
ViewMode = ActiveWindow.View
ActiveWindow.View = xlNormalView
ActiveSheet.DisplayPageBreaks = False

'Delete the sheet RDBLogSheet if it exists
On Error Resume Next
Application.DisplayAlerts = False
Sheets("Summary").Delete
Application.DisplayAlerts = True
On Error GoTo 0

' Add worksheet to copy/Paste the unique list
Set ws2 = Worksheets.Add(After:=Sheets(Sheets.Count))
ws2.Name = "Summary"

'Fill in the path\folder where you want the new folder with the files
'you can use also this "C:\Users\Ron\test"
MyPath = "C:\Documents and Settings\MAHESH\Desktop\Temp\delete"

'Add a slash at the end if the user forget it
If Right(MyPath, 1) <> "\" Then
MyPath = MyPath & "\"
End If

'Create folder for the new files
foldername = MyPath & "Sample Data" & "\"
MkDir foldername

With ws2
'first we copy the Unique data from the filter field to ws2
My_Range.Columns(FieldNum).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("A3"), Unique:=True

'loop through the unique list in ws2 and filter/copy to a new sheet
Lrow = .Cells(Rows.Count, "A").End(xlUp).Row
For Each cell In .Range("A4:A" & Lrow)

'Filter the range
My_Range.AutoFilter Field:=FieldNum, Criteria1:="=" & _

Replace(Replace(Replace(cell.Value, "~", "~~"), "*", "~*"), "?", "~?")

'Check if there are no more then 8192 areas(limit of areas)
CCount = 0
On Error Resume Next
CCount = My_Range.Columns(1).SpecialCells(xlCellTypeVisible) _
 .Areas(1).Cells.Count
On Error GoTo 0
If CCount = 0 Then
MsgBox "There are more than 8192 areas for the value : " &
cell.Value _
 & vbNewLine & "It is not possible to copy the visible
data." _
 & vbNewLine & "Tip: Sort your data before you use this
macro.", _
   vbOKOnly, "Split in worksheets"
Else
'Add new workbook with one sheet
Set WSNew = Workbooks.Add(xlWBATWorksheet).Worksheets(1)

'Copy/paste the visible data to the new workbook
My_Range.SpecialCells(xlCellTypeVisible).Copy
With WSNew.Range("A1")
' Paste:=8 will copy the columnwidth i

Re: $$Excel-Macros$$ Sum Based on date criteria

[mahesh parab]

Hi Praveen,Ankur,Dave

thank you all of you !


On 1/20/10, Dave Bonallack  wrote:
>
> Hi,
> Have a look at the attached. Let me know if it's what you need.
> Regards - Dave.
>
> --
> Date: Wed, 20 Jan 2010 10:59:47 +0530
> Subject: $$Excel-Macros$$ Sum Based on date criteria
> From: mahes...@gmail.com
> To: excel-macros@googlegroups.com
>
> Dear All
> In attach sheet i need a formula to sum status of each sheet based on date
> criteria.
> i dont want to use pivot for it. i will appreciate any help on this.
>
> --
> Start searching NOW! Search for properties that match your 
> lifestyle!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$

[mahesh parab]

Hi Shilp

Please find attach sheet, below mention macro vlookup until last row
in Column A.
Hope this will work.


Sub Example()
Dim LastRow As Long
LastRow = ActiveSheet.UsedRange.Range("A:A").SpecialCells(xlLastCell).Row
Range("B1:B" & LastRow).Formula = "=+VLOOKUP(RC[-1],Sheet2!C[-1]:C,2,0)"
Range("B1").Select
Selection.Copy

Columns("B:B").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub








On 1/24/10, Shilpa Rao  wrote:
>
> Hi Team,
>
> Kindly help me in writing macro for a vlookup formula, since I have line
> item more thant 50k lines so I want get macro for this.
>
> Regards,
> Shilpa
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Test_M.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ If cell contain particular text then autofilter

[mahesh parab]

Dear All
Below mention macro auto filter the cells, which contain words mention in
array, but if within cell another word is there then it dont works
Like if cell contain word like "a Here".
how can i change Criteria?
when i record the macro i got criteria1 as Criteria1:="=*Here*"

i try to modify macro,  Criteria1:="=" & vList,  this dont works.

i will appreciate any help on this

Sub Example2()

Dim lLastRow As Long
Dim rngToCheck As Range
Dim vList

Application.ScreenUpdating = False

vList = Array("Here", "There", "Everywhere")

With Sheet1
'find the last row in column A
lLastRow = .Cells(.Rows.Count, 1).End(xlUp).Row

Set rngToCheck = .Range(.Cells(1, 1), .Cells(lLastRow, 1))
End With

With rngToCheck
.AutoFilter _
Field:=1, _
*Criteria1:=vList,* _
Operator:=xlFilterValues

End With

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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Web query return with no data....

[mahesh parab]

Hi

Can you send link of website & the data which want to import.


On 1/30/10, saurabhn  wrote:
>
> While importing data from 1 site
> got msg like dis
>
>
> This Web query returned no data. To modify the query, click OK, click
> the name of the external data range in the name box on the formula
> bar, and then click Edit Query on the External Data toolbar.
>
>
> can any 1 help me out
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ how to copy a particular column at a particular time to a new sheet

[mahesh parab]

Hi

Check on this link

http://www.ozgrid.com/Excel/run-macro-on-time.htm


On 2/5/10, Ashok Renga  wrote:
>
>
>
>
> hi all
>
>
> iam posting my query to one of the best group in google groups,  excel dons
> please help me
>
>
>
>
> my query is , i want to copy column a and b at 11 am time everyday to
> another sheet
>
>
> is it possible
>
>
>
> thanks
>
> ashok
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Save and Close worksheet automatically

[mahesh parab]

Hi

Check below mention link
http://www.xtremevbtalk.com/archive/index.php/t-283496.html


Private Changed As Boolean

Private Sub Workbook_Open()
Changed = False
Application.OnTime Now + TimeValue("00:00:15"),
procedure:="ThisWorkbook.Auto_Close"
End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Source As Range)
Changed = True
End Sub

Private Sub Auto_Close()
If Changed = False Then
ThisWorkbook.Close SaveChanges:=True
End If
Changed = False
Call Application.OnTime(Now + TimeValue("00:00:15"),
"ThisWorkbook.Auto_Close")
End Sub








On 2/9/10, Ulisses Flores  wrote:
>
>  Hello, I would shut my spreadsheet automatically after 5 minutes of
> inactivity. Is it possible?**
>
> * *
>
> *Att,*
>
> * *
>
> *Ulisses Flores*
>
> *לוהים הוא האש מכלה*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Login to website Using VBA

[mahesh parab]

Dear All

I found vb code to login in website on below mention link. its
Amezing.!

http://vbadud.blogspot.com/2009/08/how-to-login-to-website-using-vba.html


Dim HTMLDoc As HTMLDocument
Dim oBrowser As InternetExplorer
Sub Login_2_Website()

Dim oHTML_Element As IHTMLElement
Dim sURL As String

On Error GoTo Err_Clear
sURL = "https://www.google.com/accounts/Login";
Set oBrowser = New InternetExplorer
oBrowser.Silent = True
oBrowser.timeout = 60
oBrowser.navigate sURL
oBrowser.Visible = True

Do
' Wait till the Browser is loaded
Loop Until oBrowser.readyState = READYSTATE_COMPLETE

Set HTMLDoc = oBrowser.Document

HTMLDoc.all.Email.Value = "sam...@vbadud.com"
HTMLDoc.all.passwd.Value = "*"

For Each oHTML_Element In HTMLDoc.getElementsByTagName("input")
If oHTML_Element.Type = "submit" Then oHTML_Element.Click: Exit For
Next

' oBrowser.Refresh ' Refresh If Needed
Err_Clear:
If Err <> 0 Then
Debug.Assert Err = 0
Err.Clear
Resume Next
End If
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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Need help for macro- changing cell value

[Mahesh parab]

Dear All

I need macro for when i open workbook, A1 cell value, will display 1 to 4
numbers one by one, time interval should be 15sec.
i want this to create animation effects in pie chart, cell A1 is link with
data by Hlookup, so when value in A1 change
it will change pie chart also.

I will appreciate any help on this.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Need help for macro- changing cell value

[Mahesh parab]

Thank u so much Christopher !

On Fri, Feb 26, 2010 at 1:48 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:

> See attached.
>
>
> On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab  wrote:
>
>> Dear All
>>
>> I need macro for when i open workbook, A1 cell value, will display 1 to 4
>> numbers one by one, time interval should be 15sec.
>> i want this to create animation effects in pie chart, cell A1 is link with
>> data by Hlookup, so when value in A1 change
>> it will change pie chart also.
>>
>> I will appreciate any help on this.
>>
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ create email when value in cell changes

[Mahesh parab]

Hi Kevin

Module 1 & 2 for sending emails from excel sheet, u can read further on this
link http://www.rondebruin.nl/sendmail.htm ,  code in sheet 1 to sort your
data when u enter
email id in column B.



On Sat, Mar 20, 2010 at 12:24 AM, KevinM  wrote:

> Mahesh: Why do I need code in module 1 and module 2?  Does it work in
> hand with the sub procedure in sheet1?
>
> On Mar 19, 6:59 am, Mahesh parab  wrote:
> > Hi Kevin
> >
> > Please find attach sheet, hope this is what u want.
> >
> > Right Click on sheet1 tab & view code change this as per your requirement
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > If Not (Application.Intersect(Worksheets("Sheet1").Range("B:B"),
> Target)
> > Is Nothing) Then
> > DoSort
> > End If
> > End Sub
> > Private Sub DoSort()
> > Worksheets("Sheet1").Range("A:Z").Sort
> > Key1:=Worksheets("Sheet1").Range("B1"), Order1:=xlDescending,
> Header:=xlYes
> > End Sub
> >
> >
> >
> > On Fri, Mar 19, 2010 at 7:43 AM, KevinM  wrote:
> > > I want to create an email when the value in column A changes.  In
> > > column A I have the email addresses of managers.  When the email
> > > address changes I want the VBA to compose the email and get the
> > > employees names in column B assoicated to that email address.  I
> > > don't
> > > want it 1 for 1.  I want to take only that one email address and
> > > bring
> > > in that range of employees in to the email.  So in the example below
> > > I
> > > want to email manag...@domain.com and have employees 1,2,and 3 in the
> > > body of the email.  I don't want seperate emails for each employee
> > > going to the manager.  Thanks
> >
> > > Example:
> > > Column A  Column B
> > > manag...@domain.com employee1
> > > manag...@domain.com employee2
> > > manag...@domain.com employee3
> > > manag...@domain.com employee4
> > > manag...@domain.com employee5
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe
> >
> > > To unsubscribe from this group, send email to excel-macros+
> > > unsubscribegooglegroups.com or reply to this email with the words
> "REMOVE
> > > ME" as the subject.
> >
> >
> >
> >  sample file.xls
> > 70KViewDownload- 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 Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and s

Re: $$Excel-Macros$$ Inserting new Sheet condition based

[Mahesh parab]

Hi Kumar

Can you send sample file.  you can crate copy of sheet1 3 times but the
sheet name will not be "sheet1"

On Sat, Mar 20, 2010 at 5:09 PM, C.G.Kumar wrote:

> Thanks Mahesh,
>
> It really worked ... But i would appreciate if the following minor
> modification is possible..
>
> I want to add "SHEET 1 "(a sheet in the same workbook/excel file)  3 TIMES
> since count of the column is 3 .
>
> Regards,
>
> Kumar
>
>
>
>
> On Sat, Mar 20, 2010 at 1:51 PM, Mahesh parab  wrote:
>
>> Hi
>>
>> it seems you want to create separate sheet for each value in column C,
>> Please find attach sheet. Is this what you looking for ?
>>
>>   On Fri, Mar 19, 2010 at 10:11 PM, C.G.Kumar > > wrote:
>>
>>>
>>>
>>> Could anyone suggest the manner i could to the following ;
>>> 1. Add an event in excel macro to insert particular Sheet of an Workbook
>>> depending upon count in a column &
>>> 2. Name of the new worksheet will be content of column.
>>>
>>>
>>> Example: In Workbook named "DATA", Sheet 1,C1 to C3 contain A,B & C
>>> respectively. So , i want to have macro to
>>>
>>> 1. Insert 3 times "DATA"Sheet in the workbook (bcoz Count of C1 to C3 is
>>> 3)
>>> 2. New name of the inserted sheet will be A,B and C.
>>>
>>>
>>> Regards,
>>>
>>>
>>> Kumar
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>> To unsubscribe from this group, send email to excel-macros+
>>> unsubscribegooglegroups.com or reply to this email with the words
>>> "REMOVE ME" as the subject.
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe from this group, send email to excel-macros+
>> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
>> ME" as the subject.
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials 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 grou

Re: $$Excel-Macros$$ Outlook and excel integration

[Mahesh parab]

Hi Putta


F column contain passport expiry date,
Formula in E column is F column date minus today's date
in sheet1 code you will find below mention criteria, if column E value (No
of days)more then 30 then email will get drafted.
 'Above the MyLimit value it will run the macro
MyLimit = 30

change the date value in F column.

On Sun, Mar 28, 2010 at 11:44 AM, Puttaswamy  wrote:

> Can you please tell me how to work out this? I am bit confused. It would be
> great if you provide me the instruction.
>
>
> On Sat, Mar 27, 2010 at 1:29 PM, ~ Z A H E E R ~  wrote:
>
>> Thank you very much Mahesh. This is what i want.
>>
>>
>> On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab  wrote:
>>
>>> Dear Zaheer
>>>
>>> I herewith attach sample sheet as per your requirement, u can read
>>> further on below mention link, write back if u still find
>>> any difficulty http://www.rondebruin.nl/mail/change.htm
>>>
>>>
>>> On Mon, Mar 22, 2010 at 3:09 PM, ~ Z A H E E R ~ wrote:
>>>
>>>> Dear Members,
>>>>
>>>> Is it possible to integrate MS Office 2007 and MS Excel 2007.
>>>>
>>>> For Eg.
>>>> I have 1 excel file contains Employee ID, Employee Name, CID #, CID
>>>> Expiry date, Passport #, Passport Expiry date, email
>>>>
>>>> My requirement :
>>>>
>>>> Whenever any employees CID or Passport is near to expiry date, outlook
>>>> will send an email automatically to respective person notifying him to 
>>>> renew
>>>> his CID or Passport or both.
>>>>
>>>> Regards,
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our Facebook Group @
>>>> http://www.facebook.com/group.php?gid=287779555678
>>>> 3. Excel tutorials 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
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group.Let friends and co-workers
>>>> know they can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>> To unsubscribe from this group, send email to excel-macros+
>>>> unsubscribegooglegroups.com or reply to this email with the words
>>>> "REMOVE ME" as the subject.
>>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>> To unsubscribe from this group, send email to excel-macros+
>>> unsubscribegooglegroups.com or reply to this email with the words
>>> "REMOVE ME" as the subject.
>>>
>>
>>   --
>>
>> --
&

Re: $$Excel-Macros$$ Help In access

[Mahesh parab]

Dear Vikas

Please find required info on below mention link
http://www.techonthenet.com/top10/access.php




On Sun, Mar 28, 2010 at 2:35 PM, Vikas Chouhan  wrote:

>
>  Dear All,
>>
>>
>> Please help me in *access*  please provide access queries and how to put
>> queries,,,
>>
>> *and how to vlookup,concatenate in access *
>>
>>
>> --
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> Vikas Chauhan
>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>> 9911868518,
>> "We can't Spell S_ccess without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

Re: $$Excel-Macros$$ Extracting data from another workbook based on criteria

[Mahesh parab]

Hi

Please find required info on below mention links
http://www.exceltip.com/exceltips.php?view=category&ID=213
http://www.exceluser.com/explore/msquery1_5.htm


On Sat, Apr 17, 2010 at 12:46 PM, OSA  wrote:

> *Dear Group,*
>
> I attached a sample worksheet which i used to extract data from it.  This
> worksheet is part of a large workbook.
> This worksheet is used to dump values resulting from a formula calculated
> from another worksheet in the same workbook.
> I copy the entire range of the worksheet with formulas and dump all the
> data to another worksheet as values.
>
> I like to call this dump data as excel database which i would like to query
> or extract data from it.
>
> For example i would like to extract the Id_no, Names, and Net pay of all
> the records with pay period 1 to another worksheet ( my active sheet) and to
> sum  amount below.
>
> I can do this in the same workbook, but its difficult to extract the data
> from it while within the active sheet of another workbook.
>
> Question:
>
> How to extract that data from another workbook.  The source workbook is
> open. although sometimes it maybe close by user.
>
> Thanks
>
> Grace
>
>
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Filter Query

[Mahesh parab]

Hi karthikeyan

Before you adding the column code Field:=3, Criteria1:="=100"
it will filter Column C where Amount it equal to 100

but when you add the column between A & B your Amount column will shift to
column D
this time code will be Field:=4, Criteria1:="=100"

On Sat, May 1, 2010 at 1:21 PM, karthikeyan
wrote:

> Hi All,
>
> I have create a filter through macro.Crietiria=100,Filed=3
>
> Example:-
> col-"A" col-"B"  col-"C"
> NameId Amt
> X   1   100
> Y   2   200
> Z   3   300
>
> Suppose , Insert one column between col "A" and col"B" . filter not
> working properly?Pls advice.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Need Help for Macro or Formula

[Mahesh parab]

Dear All

for attach sheet i need formula or macro, I will appreciate any help on
this.
1.if for code in column A ,status in column C is paid then D column status
should be process
2.if status in column C is not paid or awaiting then D column status should
be not to process
3. there is blank line between two codes in column A
below mention formula not working.
=IF(A3="","",IF(C3="Paid","Process","Not to process"))

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Sample sheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need Help for Macro or Formula

[Mahesh parab]

Thanks Harry

i want formula for Column D. the formula what i have mention in email needs
to be enhance or change
1. if for code in column A, status in column C is Paid,Not Paid,Awaiting
   then Final Status should be Not to process in column D
2. if for code in column A, status in column C is only paid
   then findal status should be process in column D
3. there is one blank row after each unique code in column A

i hope i have clear my query.


On Sat, May 15, 2010 at 10:28 AM, harpreetgujral
wrote:

> Hi Mahesh,
>
> You wrote:
>
> *"Dear All
> *
>
> *for attach sheet i need formula or macro, I will appreciate any help on
> this.
> 1.if for code in column A ,status in column C is paid then D column status
> should be process
> 2.if status in column C is not paid or awaiting then D column status should
>
> be not to process
> 3. there is blank line between two codes in column A
> below mention formula not working.
> =IF(A3="","",IF(C3="Paid","Process","Not to process")) "
> *
>
>
>
> In the attached sheet, first two points have been closed. 3) point is not
> clear at all.
>
> Syntax of the If formula is as follows:
>
> =IF(Condition,, false>)
>
> If you can throw some more light on what do you want to achieve, then may
> be we can help you
>
>
>
> Thanks
>
>
>
> Harry
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Fwd: $$Excel-Macros$$ Macro to send emails using excel list *

[Mahesh parab]

Hi

You can do below mention changes to add CC,BCC in mail
.To = Cells(cell.Row, "D").Value
.CC = Cells(cell.Row, "E").Value
.BCC = Cells(cell.Row, "F").Value

change the column name as per your requirement.
if you want to add yesterday's date in boday of mail then you can use below
mention code
.Body = (Date - 1)

or you can link cell value in body of mail. forrmula in column Q will be
=today()-1 in excel sheet
& vbNewLine & vbNewLine & Cells(cell.Row, "Q").Value & _

if you still have doubts write back or you can send sample sheet.

 On Mon, May 17, 2010 at 1:08 AM, Intelligent But Crazy <
secrets...@gmail.com> wrote:

>  Intelligent But Crazy (secrets...@gmail.com) was added to your Guest 
> List<https://www.boxbe.com/approved-list>by their request | Delete
> this guest<https://www.boxbe.com/anno?action=remove&tc=2806636259_589131336>| 
> [image:
> Boxbe] <https://www.boxbe.com/overview>
>
> Hi Mahesh,
>
>Thanks a lot for this help, this is really too
> helpfull for all outlook users.
> I also want to know that if i have to add CC or BCC in mail so what
> the changes i have to do in macro. & n pls also tell me if i have to
> add yesterday date in body of the mail every day in every mail so what
> should i do.
>
> Pls help me in this i will be glad to et this help.
>
> Thanks in Advance
> Pankja k Pandey
>
> On 5/15/10, Mahesh parab  wrote:
>  > Hi
> > In attach workbook refer Sendfiles sheet. you can get required info on
> below
> > mention link.
> >
> > http://www.rondebruin.nl/sendmail.htm
> >
> > On Fri, May 14, 2010 at 10:47 PM, Fabio Sascho
> > wrote:
> >
> >>  Dear friends
> >>
> >>
> >>
> >> Below you can find the code I wrote to make Excel send emails thought a
> >> list of names
> >>
> >>
> >>
> >> My problem is the attachment talk.
> >>
> >>
> >>
> >> I need a code that gets all files from a certain directory and attach
> into
> >> the email using the “ .attachment.Add”
> >>
> >>
> >>
> >> Does anyone know how to do that ?
> >>
> >>
> >>
> >> Thanks in advance
> >>
> >>
> >>
> >> Dim olApp As Object
> >>
> >> Dim olMail As Object
> >>
> >> Dim olSubject
> >>
> >> Dim olTratamneto
> >>
> >> Dim olName
> >>
> >> Dim olMsg
> >>
> >> Dim FirstLine
> >>
> >> Dim LastLine
> >>
> >> Dim olAttachment As FileDialog
> >>
> >> Dim olAttachmentDirectory As Object
> >>
> >>
> >>
> >> LastLine = Cells(65536, 1).End(xlUp).Row
> >>
> >>
> >>
> >> olTratamento = InputBox("Insira aqui uma mensagem que vem antes do Nome
> do
> >> seu cliente como Dear,Hello, Etc" _
> >>
> >> , "Tratamento da Mensagem", "Hello ")
> >>
> >>
> >>
> >> olSubject = InputBox("Insira o assunto do email", "Subjetc Box",
> "BROTHERS
> >> IN GRANITE OFFER")
> >>
> >>
> >>
> >> Set olApp = CreateObject("Outlook.application")
> >>
> >> Set olMail = olApp.CreateItem(0)
> >>
> >> Set olAttachment = Application.FileDialog(msoFileDialogFilePicker)
> >>
> >> With olAttachment
> >>
> >> .AllowMultiSelect = True
> >>
> >> End With
> >>
> >>
> >>
> >> FirstLine = 2
> >>
> >> For i = FirstLine To LastLine
> >>
> >> olName = Cells(FirstLine, 1).Value
> >>
> >> With olMail
> >>
> >> .OriginatorDeliveryReportRequested = True ' delivery
> confirmation
> >>
> >> .ReadReceiptRequested = True ' read confirmation
> >>
> >> .Subject = olSubject
> >>
> >> .To = Cells(FirstLine, 2).Value
> >>
> >> .CC = Cells(FirstLine, 3).Value
> >>
> >> .BCC = Cells(FirstLine, 4).Value
> >>
> >> .Body = olTratamneto & Chr(32) & Cells(FirstLine, 1).Value &
> >> Chr(13) & Chr(13) & Sheets("MAIL_OFFER").Cells(1, 1).Value
> >>
> >> .Attachment.Add = “Several file”
> >>
> >> End With
> >>
> >> Next i
> >>
&

$$Excel-Macros$$ Macro to Filter All Sheets

[Mahesh parab]

Hi

I have workbook consist of 4sheets
I want to Autofilter each cell value in column A from sheet1
and same cell value will get Autofilter in sheet2, sheet3, sheet4 also
i got below mention code on net but it autofilter only particular Criteria
in all sheets
i want to Autofilter each value from sheet1 same will get Autofilter on
sheet2,sheet3 & sheet4
& create newworkbook and paste value in respective sheets of new workbook
for each value in sheet1

i will appreciate any help on this.

Sub FilterAllSheets()
Dim i As Long
i = Application.Calculation
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Dim sht As Worksheet
For Each sht In ThisWorkbook.Sheets
ActiveSheet.Select
sht.Range("A1:A20").AutoFilter Field:=1, Criteria1:="Mahesh"
Next
Application.Calculation = i
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ PLZ Help Me

[Mahesh parab]

Hi Vishal

follow below mention steps

   1. Select your column A:A
   2. Go to Data Validation
   3. Click on settings
   4. Choose custom from drop down list
   5. Enter the formula as =IF(COUNTIF(A:A,A1)>1,FALSE,TRUE)
   6. Click Error Alert tab , check or select show error alert box
   7. choose stop from style drop down list
   8. Enter title or error message

or you can use below mention macro to remove duplicate

Sub RemoveDuplicate()
Cells.Sort Key1:=Range("A1")
totalrows = ActiveSheet.UsedRange.Rows.Count
For Row = totalrows To 2 Step -1
If Cells(Row, 1).Value = Cells(Row - 1, 1).Value Then
Rows(Row).Delete
End If
Next Row

End Sub

On Sun, Jun 6, 2010 at 2:04 PM, Vishal Gupta wrote:

> Hello All,
> I need a command or code in excell.
> I want names written in a coloumn sholud not be repeated, error msg
> shouldbe generated when someone writes a duplicate entry.
> Plz help me
>
> regards
> Vishal Gupta
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$

[Mahesh parab]

Hi Deepak

Try
Sub FindCell()
Dim FirstCell As String
Dim i As Integer
FirstCell = "A1"
Range(FirstCell).Select
Do Until ActiveCell.Value = ""
If ActiveCell.Value = "" Then
Exit Do
Else
ActiveCell.Offset(1, 0).Select
End If
Loop
End Sub

Or to select the range from last blank cell

Sub LastCellBeforeBlankInColumn()
Range("A1").End(xlDown).Select
Range(Selection, Selection.End(xlUp)).Select
End Sub

On Sun, Jun 13, 2010 at 1:13 AM, Dave Bonallack
wrote:

> Hi,
> Sorry, didn't see that it might go past 100. This is better:
>
>   Sub selectCells()
> Dim i As Integer
> For i = 1 To 1
>  If Cells(i, 1) = "" Then Cells(i, 1).Select: Exit For
> Next i
> End Sub
>
> Regards from Brazil.
> Dave.
>
> --
> Date: Sat, 12 Jun 2010 21:48:01 +0530
> Subject: Re: $$Excel-Macros$$
> From: deepaktheind...@gmail.com
> To: excel-macros@googlegroups.com
>
>   Thanks Mahesh it works,
> I've an another query for you, i'm writing a code which is given below, now
> in the following loop range from A1 to A100 will be selected, but I want to
> select each cell one by one untill an empty cell comes, it can be after 100
> or before 100, that's wha idon't know.
>
>
> Sub selectCells()
>
> Dim i As Integer
> For i = 1 To 100
> Cells(i, 1).Select
> End Sub
>
>
> Thanks
>
> On Sat, Jun 12, 2010 at 6:46 PM, Mahesh parab  wrote:
>
> Hi Deepak
> find attach sheet, hope its as per u r requirement.
> Change Mypath in Module2.
>
>
>   On Sat, Jun 12, 2010 at 8:17 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
> Hi All,
>
> I've some data in sheet1, people have to work on this data, i've assigned
> the work to the concern people, now what i want a macros should be run and
> then new files should be created ion the same folder in the name of assigned
> peoples and those files should contain individual works that i've assigned
> in the attached file.
> Example there are 3 people who have to work on different states no i what i
> want to do is if i run a macro then 3 new files should be created in the
> name of people who will work on the data, and each file must contain the
> work assigned to them.
>
> Thanks
> Deepak 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. E

Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Mahesh parab]

Hi Kristin

it seems you want to link 3 columns, if you select Particular Prod Name then
base on that, column 2nd & 3rd reflect
values, i herewith attach sheet, where 3 columns are link with drop down,
hope its as per your requirement,

for better understanding of your query send a sample sheet to this group.

On Tue, Jun 15, 2010 at 12:02 AM, Kristin  wrote:

> I am trying to create 3 columns for an ongoing monthly master
> spreadsheet.  The data includes: Product Name (highest level of info),
> Product Item # (essentially, a part #), and Product Description.
> Currently the list is 193 records long.
>
> I'd like for the first column (Product Name) to be a pick list
> consisting of 7 product names (I've got this done).  The second column
> to be a pick list based on which product name was picked in the first
> column and only show that subset of the master list pertaining to that
> product line.  And, the third column to auto-fill the product
> description for column two's product id.
>
> Is this possible?  I've been researching pick lists and conditional
> formatting, but can't seem to find a situation/example to where both
> are utilized within the same cell/column.
>
> I guess I need to know if this is possible and if not, I'll just go
> with pick lists for each column and hope for the best in accurate
> data.  If this is the only option, is there a limit to how long the
> pick list is?
>
> Lastly, I am not a developer and am not familiar with VBA or other
> scripting languages, etc.
>
> Thank you in advance for your help!
>
> Kristin
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Sample dropdown.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ activate sum display function

[Mahesh parab]

Hi

If you are using Excel 2007 then

   1. Right-click on the status bar ( Excel 2007)
   2. You will get Average, Count, Sum option
   3. Select Sum

The sum will be displayed in the status bar.

Thank You,


On Thu, Jun 17, 2010 at 2:23 PM, anu naik  wrote:

> Hey Guys,
> I need help in a matter
>
>
> While using excel ,the sum is displayed below when we select a
> particular range of cells.But i m able to view count instead of sum on
> selection of a particular range of cells.How to rectify this ?
>
> -
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

[Mahesh parab]

Hi

find attach sheet as per your requirement,  find info on below link.


http://www.ozgrid.com/VBA/ExtractNum.htm


On Sun, Jul 4, 2010 at 10:25 AM, memonkavi  wrote:

> DEAR SIR
>
> PLS ME
>
>
> I NEED EXRACT  WHOLE TEXT AND NUMBER  DIFFERENT CELLS
> WITH ONE FUNCTION OR TWO
>
>
> REGRADS
> KAVI
>
> NOTE -HOW ATTACH A SAMPLE FILE THIS GROUP
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


ExtractNumberAndText.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Urgent help....

[Mahesh parab]

Hi

find attach sheet.

On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote:

> Hi,
>
>
> hi to all ..i need a help PFA and help me to get reqired result.
>
> Regards,
> Ankit
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


help_R.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Problem facing attchment

[Mahesh parab]

Hi Sajid

Click on sheet1 tab
right click & select view code
copy below mention code

enter value in c8 & press enter cursor will move to G14

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$8" Then
 Range("G14").Select
End If
End Sub

On Wed, Jul 7, 2010 at 7:36 PM, SAJID MEMON  wrote:

>
>
> --
> Dear aindril plz help me, awaiting your replay.
>
>
> Date: Mon, 5 Jul 2010 12:08:52 +0530
> Subject: Re: $$Excel-Macros$$ Problem facing
> From: aind...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Sajid,
>
> Would it be possible for you to share a sample sheet
>
> Regards,
> Aindril
>
> On Mon, Jul 5, 2010 at 10:23 AM, SAJID MEMON wrote:
>
> Hi
>
> Dear I want in excel, when i press enter key cursor should go to particular
> cell example: my cursor is at A1 and after press enter it should go to D15--
> what is the code?
> My second query is that when i enter any data on the form that should store
> in particular sheet as below cell wise, example: when i typed any name on
> the form it will store as sheet1 and address of cell is B1 after that next
> data store below B1 that is B2, B3 so on. plz help me of these two query
> code to accomplish my project.
>
> Awaiting your replay
>
> sajid memon
>
> --
> Make the world eco-friendly through MSN Green Drag n' 
> drop
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Chin music and high voltage T20 action on MSN Sports Sign up 
> now.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

[Mahesh parab]

Hi Vijay

if you want to convert a figure in to words for other files then either you
have to copy vb code in other files or you can download addin from below
mention link which convert a figure in to words

http://www.simpletaxindia.org/2010/01/convert-figure-to-word-excel-excel.html

On Fri, Jul 23, 2010 at 8:42 AM, Vijay Aggarwal wrote:

> Hi Mahesh,
>
> Convertword formula is working in your file only. If I open a new file it
> doesn't work.
>
> Please let me know what should I do?
>
> regards,
> Vijay Kumar Aggarwal
> 048542
>
>   On Wed, Jul 21, 2010 at 11:57 AM, Mahesh parab wrote:
>
>>   Hi
>>
>> find attach sheet to convert amount into word.
>>
>> On Fri, Jul 16, 2010 at 11:48 AM, preeti vora wrote:
>>
>>>HI IS THAT ANY FORMULA WHEN WE WRIGHT NUMERICAL AMOUNT AND WANT TO
>>> CONVERT IN WORD. ANY BODY KNOW FORMULA ???
>>>
>>> E.G = 25  ( TWENTY FIVE)
>>> On Thu, Jul 15, 2010 at 12:48 PM, Kishanreddy Kethireddy <
>>> kishanreddy.kethire...@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> You can use iserror() function to find out any errors.
>>>>
>>>> You can use If() function to replace error values to zeroes.
>>>>
>>>> use the following formula in adjucent column/row of the actual values
>>>> that you want to sum
>>>>
>>>> eg. you want total the values in column C, then use this formula in
>>>> column D
>>>>
>>>> =IF(ISERROR(C3),0,C3)
>>>>
>>>> then use the SUM function on column D.
>>>>
>>>> Still have a problem, mail me at kishanreddy.kethire...@gmail.com
>>>>
>>>> Bye.
>>>>
>>>> KIshan Reddy.
>>>>
>>>>
>>>>  On Thu, Jul 15, 2010 at 11:27 AM, preeti vora 
>>>> wrote:
>>>>
>>>>>
>>>>> Hi
>>>>>
>>>>> is that any formula when we do sum formula but some time in our data
>>>>> #N/A in list that's WY we not able to see sum total.
>>>>> pls find the below mention example.if anybody know pls tell me formula.
>>>>>
>>>>> *Total* 20 25 #N/A 20 51 10 *#N/A=sum()
>>>>>
>>>>>
>>>>> *
>>>>> On Tue, Jul 13, 2010 at 11:48 PM, Harmeet Singh <
>>>>> harmeet.hew...@gmail.com> wrote:
>>>>>
>>>>>> may b attached tool will help you...
>>>>>> Warm Regards,
>>>>>>
>>>>>> Harmeet Singh
>>>>>> IT Analyst
>>>>>> McKinsey & Company
>>>>>> http://www.facebook.com/Harmeeet
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jul 13, 2010 at 10:21 PM, Anish Shrivastava <
>>>>>> anish@gmail.com> wrote:
>>>>>>
>>>>>>> PLease help me on this.
>>>>>>>
>>>>>>>
>>>>>>> On 7/13/10, Anish Shrivastava  wrote:
>>>>>>>>
>>>>>>>> Hello Experts,
>>>>>>>>
>>>>>>>> Yesterday, while using Google Translator manually I just thought if
>>>>>>>> it
>>>>>>>> can be automated using VBA. Actually what my task includes is to
>>>>>>>> Convert various European language values to Standard English lang.
>>>>>>>>
>>>>>>>> I have values in a single Column (No fixed number of rows/values but
>>>>>>>> it will be in a single column). What I do is, I separate all the
>>>>>>>> European titles in different files according to their language and
>>>>>>>> then upload it to google translator as a file. Then Select the
>>>>>>>> language and click on go. It gives us the result on the next page.
>>>>>>>>
>>>>>>>> Now I just wanted to know, if VBA can do the following job for us.
>>>>>>>> 1. Copies the values from those column.
>>>>>>>> 2. Pastes it into a new file.
>>>>>>>> 3. Saves it, Closes it.
>>>>>>>> 4. Opens Internet Explorer with Google Translator.
>>>>>>>>
>>>>>>>> (I am able to do till here, next points are bit tricky for me or
>>>>>>>> perhaps I dont kn

Re: $$Excel-Macros$$ Hide a single work sheet with password

[Mahesh parab]

Hi Kumar

find required info on below mention link

http://www.vbaexpress.com/kb/getarticle.php?kb_id=380

On Fri, Jul 23, 2010 at 11:51 AM, Kumar Punnam
wrote:

> Dear Friends,
>
>
> I am having important information in Sheet2 which wa named  as "Fuel Item"
> along with Sheet1 "Fuel Summary", i would like to hide the sheet2 and
> protect it with password so that no one can access it at all,
>
> i need a VBA Code or any suggestion
>
>
> Thanking You,
>
>
> With Regards,
> P.V. Ravi Kumar,
> Asst, Engg,
> GKC Projects Ltd.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code Help

[Mahesh parab]

Hi Nikhil

Insert this code in a standard module

Function FirstLetters(rng As Range) As String
Dim arrWords
Dim I As Long
arrWords = Split(rng, " ")

If IsArray(arrWords) Then
For I = LBound(arrWords) To UBound(arrWords)
FirstLetters = FirstLetters & Left(arrWords(I), 1)
Next I
Else
FirstLetters = Left(arrWords, 1)
End If

End Function

find info on below link
http://www.ozgrid.com/forum/showthread.php?t=50353

On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah  wrote:

> Hi Friends,
>
> In Column " A " .. I have written --- > Vishal Pravinchandra Shah .
>
> Now I want
>
> In Column " B " should be VPSautomatically..I want Formula
>
> I want First Letter Of First Name ; First Letter Of Middle Name ; First
> Letter Of Last Name in one column..
>
> Awaiting Reply..
>
> Thanks
> Nikhil
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Month Code Query

[Mahesh parab]

Hi Nikhil

you can use =LEFT(A1,3) , i dont knw what exact you looking for but you can

enter date in column A cell then go to Format cells-custom
select date type as ""
then use =TEXT(A1,"mmm") formula in B column
so even if you change the month in A column it will show only 3 Alphabet in
B column

January Jan February Feb March Mar April Apr
hope this will help you
On Sun, Aug 8, 2010 at 7:18 PM, Nikhil Shah  wrote:

> Hi Friends,
>
> I have written In Column " A " ...January ...
>
> Now I want in Column " B " should be ..Jan ...only...I want formula..( No
> Macro )
>
> Awaiting Reply
>
> Thanks
> Nikhil
>
>
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ trend analysis in excel

[Mahesh parab]

Dear All

it would be great if someone could provide ppt or sample workbook on trend
analysis.
with explanation


Thank You,

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How to delete blank columns & rows using VBA

[Mahesh parab]

Hi
find required info on below link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=395


On 10/7/10, Rajat Kapoor  wrote:
>
> I wanted to know how can one delete all blank rows & columns using
> VBA? Suppose in Cell A1 there is data but in other cells with row 1
> there is no data. Thus we can say this row is not blank. BUt taking
> other example suppose there is data in Cell C1, A3, A4. But entire row
> i.e ROW - 2 is blank. How can one delete all such entire blank rows
> using VBA. Similarly this apply to columns also.
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How to Automate Vlookup

[mahesh parab]

Dear All

I herewith attach the Excel sheet on which i have to run daily vlookup with
other Reports
i have recored the macro which automate the vlookup but the problem is every
sheet contain
data about 2500 cells, when i run the macro the excel sheet get hang & also
my PC. i have to
shut down my PC & restart it.
Can i write vb script which will Automate Vlookup? though there is huge
data.
in attach sheet i have to run vlookup in Month sheet & Report Sheet for
Status column

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



MIS Report.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Embed a flash into Excel

[mahesh parab]

Dear All

Any one knw the way how to embed a flash project into Excel ?

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: MS Excel -Animation

[mahesh parab]

Thanks Alokeshwar
but can u explain me the steps ?


On 3/29/09, Alokeshwar Tiwary  wrote:
>
>   Though it looks like flash or something but its not. There are several
> picture in each sheet which become visible and invisible one after another.
> See attached and you will get it.
>
>
>
> _
> "There are known knowns. These are things we know that we know. There are
> known unknowns. That is to say, there are things that we know we don't know.
> But there are also unknown unknowns. There are things we don't know we don't
> know."
>
>
>  --
> *From:* mahesh parab 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, 29 March, 2009 11:00:50 AM
> *Subject:* $$Excel-Macros$$ MS Excel -Animation
>
> Dear All
>
> The attach excel sheet contain animation in sheet. can anyone explain me
> the steps,
> how this is done
>
> --
> Check out the all-new Messenger 9.0! Click 
> here.<http://in.rd.yahoo.com/tagline_messenger_7/*http://in.messenger.yahoo.com/>
> >
>
>
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Macro which can speak the cell content

[mahesh parab]

Dear All

Any knw macro in excel which can speak the cell content. or any user define
function is there. if any one have
example sheet please mail it to me.

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel Macro for Email through Outlook

[mahesh parab]

Dear All

I have excel sheet. This excel sheet has data for many receipnts,
I want a macro to be created so that when i run macro a new mail is
drafted for each recipant including CC through Outlook. what will be the
script ? Can anybody help?
please find attach example sheet.

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Mail Macro.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Macro to send email through Excel

[mahesh parab]

Dear All

i herewith attach the sample file on which i want to work,i took script from
Mudassar Ramzans File which he posted to this group, i have already go
through the code, but i have all my data on sheet1, when i run the macro
it dont get connect to *MS Outlook* or cursur moves to sheet2,please help to
resolve this.

Thanks in advance

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Macro Outlook.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Macro for NAV Calculation

[mahesh parab]

Dear All

i want to wirte macro for attach NAV calculation. i want when i click on
button
the macro will calculate the results,steps are mention in sheet, please find
the attach sheet.

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



NAV Sample.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Run macro at specific time on specific date

[mahesh parab]

Dear All

Any one knw how to set time for macro or run at speacified time, if any one
have sample sheet
please send it to me.




Thank You

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Macro for NAV calculation

[mahesh parab]

Hi Ashish

i have alrady mail this query to this group, now can any one help to write
macro for attach excel sheet.
if any one can mail me steps it will be helpful for me.



Thanks in advance

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



NAV Sample.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Insert Excel Sheet table in E mail body

[mahesh parab]

Dear All
I send email through attach sheet to more then one person, now i want to
insert Excel sheet data in row in table format to mail body,how can i do
it?please find below mention format of table which i want to put in Email
body, and how can i attach more then one attachment to email. please find
attach worksheet.

   A B
C  D E F Total 1 2 3 4 5 6 21

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Email_Sample File.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Error- Can not execute code in break mode

[mahesh parab]

Dear All

while running vb script i m getting "Can not execute code in break mode"
error, Can any one explain the cause of this
error

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Help required to modify vb code

[mahesh parab]

Dear All
i herewith attach the code to send row of excel through outlook, i have
modify it as per my requirement
but the body of mail not get draft as per the code

it should be

Dear (Cell value A)

Line 1

Line 2

Line 3

Table (mean row of Excel sheet)

Line 4

but when i run the macro mail drafted as per below

Dear (Cell value A) Line 1 Line 2 Line 3
Table
Line 3

Can anyone please help me to modify the code, Thanks in advance

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

Option Explicit

Sub Send_Row()
' Don't forget to copy the function RangetoHTML in the module.
' Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Dim rng As Range
Dim Ash As Worksheet
 
Set Ash = ActiveSheet
On Error GoTo cleanup
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
 
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
 
For Each cell In Ash.Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?...@?*.?*" And LCase(cell.Offset(0, 1).Value) = 
"yes" Then

Ash.Range("A1:O100").AutoFilter Field:=2, Criteria1:=cell.Value

With Ash.AutoFilter.Range
On Error Resume Next
Set rng = .SpecialCells(xlCellTypeVisible)
On Error GoTo 0
End With
 
Set OutMail = OutApp.CreateItem(0)
 
On Error Resume Next
With OutMail
.To = cell.Value
.Subject = "Application Pending for requirement at IDBIfortis 
Back Office"
.HTMLBody = "Dear" & Cells(cell.Row, "A").Value & _
vbNewLine & vbNewLine & vbNewLine & _
"Line 1" & _
" Line 2" & _
"Line 3" & _
vbNewLine & vbNewLine & _
RangetoHTML(rng) & _
vbNewLine & vbNewLine & vbNewLine & _
"Line 4"

.Display  'Or use Send
End With
On Error GoTo 0

Set OutMail = Nothing
Ash.AutoFilterMode = False
End If
Next cell

cleanup:
Set OutApp = Nothing
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub

$$Excel-Macros$$ vb script -Set ChipLable

[mahesh parab]

Dear All

does anyone knows what use of  'Set ChipLabel' function in vb, what is
syntax, please find below mention script, if you have any
other information please mail it.


 Set ChipLabel = WS.Shapes.AddLabel(msoTextOrientationHorizontal, cCenterX,
_
(cCenterY + cFaceRadius / 2), Width:=100, Height:=20)
With ChipLabel
 With .TextFrame
.Characters(1, 100).Caption = "Line"
.Characters(1, 100).Font.Bold = True
.Characters(1, 100).Font.Color = RGB(255, 0, 0)
End With
.IncrementLeft ChipLabel.Width * -0.5
.Name = "ChipLabel"
End With

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ vlookup from multiple sheet

[mahesh parab]

Dear All
Does anyone knows how to vlookup from multiple sheet, i got below mention
formula on net but its not working

=IF(ISNA(VLOOKUP(A2,Wrk1!$F:$G,2,0)),
IF(ISNA(VLOOKUP(A2,Wrk2!$F:$G,2,0)),
IF(ISNA(VLOOKUP(A2,Wrk3!$F:$G,2,0)),
VLOOKUP(A2,Wrk3!$F:$G,2,0)),
VLOOKUP(A2,Wrk2!$F:$G,2,0)),
VLOOKUP(A2,Wrk1!$F:$G,2,0))

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Outlook

[mahesh parab]

Hi Sahil

below mention link will help you.

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



On 8/2/09, Sahil Thakkar  wrote:
>
>
> Hi, I need your help.
>
> I use to send about 400 emails daily and want outlook to autofill the
> subject line whenever I click on reply or forward. (Do not want it for
> new email) only for reply or forward. Subject line is Completed, MT,
> current date (mm/dd/yy).
>
> Please help.
>
> regards
>
> Sahil
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Help for Hlookup using if function

[mahesh parab]

Dear All

In attach sheet i am getting error in hlookup if i use if condition, please
assist.

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



HLOOKUP_Sheet.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Inserting an animated gif in Excel

[mahesh parab]

Dear All

i am trying to insert gif image in Excel but its not working,I will greatly
appreciate any help on this, i herewith attach sample sheet,
i got the steps form below mention link

http://en.kioskea.net/faq/sujet-1402-inserting-an-animated-gif-in-excel

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Sample File.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Inserting an animated gif in Excel

[mahesh parab]

Thank you so much

On 8/31/09, jonell  wrote:
>
>   On Aug 30, 10:43 pm, mahesh parab  wrote:
> > Dear All
> >
> > i am trying to insert gif image in Excel but its not working,I will
> greatly
> > appreciate any help on this, i herewith attach sample sheet,
> > i got the steps form below mention link
> >
> > http://en.kioskea.net/faq/sujet-1402-inserting-an-animated-gif-in-excel
> >
> >  Sample File.xls
> > 24KViewDownload
>
>
> Hi Mahesh,
>
> You need to resize the frame to suit the size of your image.
> Go back to the ControlsToolbar and click on the top left hand icon to go
> into design mode.
> Your image will appear to disappear! Click in the area that you know is
> where your image is and
> the little circles that indicate the outline of your image will appear.
> Drag and resize your image to match what you want to see.
>
> Regards,
> Jonell
>
> >
>
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Calculate Latest Value

[mahesh parab]

Dear All

in attach sheet i want to find latest value of column B (i.e Prod Type) from
Sheet2,
i use below mention formula to find latest value for column A

=LOOKUP(2,1/('Main Data '!A18:A25=Sheet1!A19),'Main Data '!D18:D25)

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Calculate Latest Value.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Multiples eMails through Excel with attachment

[mahesh parab]

Hi Haresh

below mention link will help you. download sample workbook and change the
code as per your requirement.

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



On 10/12/09, haresh Kumar herwani  wrote:
>
> Following code was sent by someone in one of the group emails recently.
>
> I want to send attachment to multiple people, one at a time, using excel
> lists and path info.
>
> please modify the below code for this.
>
> regards
>
> Haresh
>
> Sub SendMail()
> Dim objOut As Outlook.Application
> Dim objMail As Outlook.MailItem
> Dim strTo As String
> Dim strCC As String
> Dim strSubject As String
> Dim strBody As String
>
> Dim firstTo As String, secondTo As String
> firstTo = "johnsm...@usa.com"
> secondTo = "john...@usa.com"
>
> Dim firstCC As String, secondCC As String
> firstCC = "johnad...@usa.com"
> secondCC = "jimsm...@usa.com"
>
> On Error Resume Next
>
> Application.DisplayAlerts = False
>
> Set objOut = New Outlook.Application
> Set objMail = objOut.CreateItem(olMailItem)
> strTo = firstTo & ";" & secondTo
> strCC = firstCC & ";" & secondCC
> strSubject = "Test"
>
> strBody = "Your call"
> strBody = strBody & vbCrLf & "Second line"
> strBody = strBody & vbCrLf & vbCrLf & "Best regards"
>
> With objMail
> .To = strTo
> .CC = strCC
> .Body = strBody
> .Subject = strSubject
> .Send
> End With
>
> Set objOut = Nothing
> Application.DisplayAlerts = True
>
> End Sub
>
>
> --
> Hotmail: Trusted email with powerful SPAM protection. Sign up 
> now.
> >
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ if condition based on two cell value

[mahesh parab]

Dear All
In attach sheet i want to use if condition based on two cell value, how to
write IF formula
using OR, AND.  i will greatly appreciate any help on this.




Thank You

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



data1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: if condition based on two cell value

[mahesh parab]

Hi Ayush

Thank you so much & keep up the great support.


On 10/18/09, Ayush Jain  wrote:
>
>   Hi Mahesh,
>
> The OR,AND formula can be used as :
> OR(Logical test 1, Logical Test 2, ..)
> AND(Test 1, Test 2,.)
>
> =IF(OR(B26= "Add R",B26 = "CC"),"Req",IF(B26 =
> "Entered","WIP",IF(C26="Bounce","Bounce",IF(OR(B26="Cancel",B26="NTU",B26="Decline"),"Refund","PP"
>
> You can use above formula for final status column.
>
> Attached is the solution for your reference. Let us know if you have
> further queries.
>
> Best regards,
> Ayush Jain
> Group Owner
>
>
> --- On *Sun, 18/10/09, mahesh parab * wrote:
>
>
> From: mahesh parab 
> Subject: $$Excel-Macros$$ if condition based on two cell value
> To: excel-macros@googlegroups.com
> Date: Sunday, 18 October, 2009, 3:40 PM
>
>  Dear All
> In attach sheet i want to use if condition based on two cell value, how to
> write IF formula
> using OR, AND.  i will greatly appreciate any help on this.
>
>
>
>
> Thank You
>
>
>
>
>
> --
> Yahoo! India has a new look. Take a sneak 
> peek<http://in.rd.yahoo.com/tagline_metro_2/*http://in.yahoo.com/trynew>
> >
>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ How to add Post form variable in web query

[mahesh parab]

Dear All
In attach sheet through web query i retrive data from web page,when i run
the macro i get only current data
from web page, now i want to retrive historical data.
The form variable name is"TxtDate" in web query.How can i add post form
variable in web query.
or any other way to retrive historical data. Please find below mention link
i think it is similar to this with some extent.

I will greatly appreciate any help on this

http://msdn.microsoft.com/en-us/library/aa140050(office.10).aspx

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Download NAV.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help for if...match formula

[mahesh parab]

Dear All

In attach sheet i want to find matching text from another column, Can anyone
help for
formula.below mention formula is not working.i will appreciate any help on
this

=IF(MATCH("*"&A2&"*",E1:F4,0),OFFSET(E1,1,1),"Not Found")





Thanks,

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Sample data.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help for if...match formula

[mahesh parab]

Thanks Norman

but i want code in Column B

REG CODE CODE S Mahesh L1984 #N/A G Sudhir L1980 #N/A L1888 Manas
L #N/A Rakesh
L1982   L1985 Sohan


On 11/30/09, Norman May  wrote:
>
> Try the following formula in cell C11
>
> =IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),"Not Found",VLOOKUP(A11,E2:F6,2,FALSE))
>
>
>  On Sun, Nov 29, 2009 at 10:15 AM, mahesh parab wrote:
>
>> Dear All
>>
>> In attach sheet i want to find matching text from another column, Can
>> anyone help for
>> formula.below mention formula is not working.i will appreciate any help on
>> this
>>
>> =IF(MATCH("*"&A2&"*",E1:F4,0),OFFSET(E1,1,1),"Not Found")
>>
>>
>>
>>
>>
>> Thanks,
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. Let friends and co-workers know they can
>> subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Find if cell contain partiular word or number

[mahesh parab]

Dear All

i want to find particular word or number in column A,B& C eg.ABC,XYZ,123  i
want to write macro
If column A B C contain ABC,XYZ,123  any one in three of this.then status of
D column should be found if not then not found
How can i use "If InStr " or any other function

   Column A Column B Column C Status ABC  Z 0 0 Found 0 XYZ 0 Found 123 0
ABC Found AA 0 0 Not Found

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Diff excel Sheet based on Name & test

[Mahesh parab]

Hi Maulik

do u want to delete column which contain only "NA" , not "Na"
is both are different or same

On Mon, Feb 21, 2011 at 12:08 PM, maulik desai wrote:

> Hi mahesh,
>
> in a simple manner u have given instruction to macro to del column
> which contains "na" value in any columns right but i want that instead
> of specific value bifercation i want that entire column should be
> their rest columns to be deleted
>
> for eg. If if u select process 5 or emp name e i only want test1,test2
> and test3 columns nad rest 2 columns need to del. And so on...
>
> I just want that macro should give me output based on columns
> specification and not based on specific value
>
> i hope i have given proper explanation
>
> pls revert with solution
>
> On 2/20/11, Mahesh parab  wrote:
> > Hi Maulik
> >
> > find attach, for test columns u r using Pass or NA values if u want to
> > retain specific column use another value or string other then "NA"
> > i didnt get " i want the specific cloumns based on Process name becasue
> > sometime it happens that in required columns "
> > as far as New workboooks in output folder are concern reflecting same
> > columns as mention by u
> >
> > On Sun, Feb 20, 2011 at 12:27 PM, maulik desai
> > wrote:
> >
> >> One more thing i have noticed that macro delete the complete Column
> >> contains "NA" value from the sheet but as i have mentioned on my prev
> mail
> >> that i want the specific cloumns based on Process name becasue sometime
> it
> >> happens that in required columns we have to enter "NA" so in that case
> >> macro
> >> will del that column which is not reqired
> >>
> >> Once again i am provide you the same info for your ref kindly give the
> >> below condition to maco  to be saved in output folder
> >>
> >> Prcoess Name - Test columns wanted in diff sheets are
> >> Process 1- Test1 & 2
> >> Process 2-Test 3,4,5
> >> Process 3-Test 1&3,5
> >> Process 4-Test1 & 2
> >> Process 5 -Test1, 2,3
> >> I just want that above columns(whatever the value in that) to be saved
> >> with
> >> other details except " sheet Name should Be"  column in outout folder .
> >>
> >> Thanks in advance.
> >>
> >> On Sun, Feb 20, 2011 at 12:13 PM, maulik desai
> >> wrote:
> >>
> >>> Hi Mahesh,
> >>>
> >>> Thanks for the lovely Solution but 2 minor modification i wanted from
> you
> >>>
> >>> 1. File should be saved in Excel 2003 format (.xls) ,Currently it is
> >>> saved
> >>> in .xlsx format
> >>> 2. i dont want " sheet Name should Be" Column should be saved on output
> >>> sheets because it is just for your information,kindly removed that
> column
> >>> from each sheet rest is perfect.
> >>>
> >>> Request you to kindly modify this 2 changes and pls send it updated one
> >>>
> >>> Thanks & appricated your time & kindness.
> >>>
> >>>
> >>> On Sat, Feb 19, 2011 at 8:00 PM, Mahesh parab 
> wrote:
> >>>
> >>>> Hi Maulik
> >>>>
> >>>> i have tested pervious files, its working correctly. only i done
> changes
> >>>> to remove NA in existing one.
> >>>> for C-Test as per u its 1&3 it should be 1,3,5 as per data
> >>>> hope its as per u r requirement, i herewith attach revised workbook as
> >>>> well steps in word file since u r getting below error
> >>>>
> >>>>
> >>>> On Fri, Feb 18, 2011 at 1:02 AM, maulik desai
> >>>> wrote:
> >>>>
> >>>>> Thanks mahesh,
> >>>>>
> >>>>> there is some problem with the code
> >>>>>
> >>>>> when i click on Create workbook button it give me  error in code
> >>>>>
> >>>>> ActiveWorkbook.SaveAs (sPath & sFileName)
> >>>>>
> >>>>> also border part also not execute
> >>>>>
> >>>>> request u to kindly check the same
> >>>>>
> >>>>> And my earlier mail have mentioned that each process has is own tests
> >>>>> so
> >>>>> i just want that after extracting data to diff sheets i just want the
> >>>>> test
> >>>>> columns

Re: $$Excel-Macros$$ Need Help

[Mahesh parab]

Hi

find attach, check whether it helps as per my understanding NA count should
be 0

On Tue, Feb 22, 2011 at 8:59 PM, Prathima R  wrote:

>  My colleague has this equation set up to count the number of cells within
> a range that are three standard deviations higher than the mean. But when he
> has N/As in the set, it's returning those in the count as well. Do you have
> any ideas on how to adjust the formula to only count straight numeric
> values?
>
>
> =COUNTIF(AT6:AT52664,">median(AT6:AT52664)+(3*stdevp(AT6:AT52664))")
>
> Please help in this concern
>
> --
>
> --
> 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


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

Re: $$Excel-Macros$$ regd: drop down button

[Mahesh parab]

Hi Thamu

well done !
On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§  wrote:

> HI Naresh,
>
> Have look at this, i did something by using function,
> find the attachment.
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
>
> On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR <
> sajidmansooral...@gmail.com> wrote:
>
>> Why are you using this lengthy formula?
>> =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
>> instead of
>> =INDIRECT($B$15)   (Working Fine as above one)
>>
>>
>> On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote:
>>
>>> Hi Naresh,
>>>
>>> Please check the attached file for required solution.
>>>
>>> I have used Name definition manager, data validation with V-lookup
>>> option to achieve the desired result.
>>>
>>> Thanks & Regards,
>>> DILIPandey
>>>
>>>
>>> On 2/25/11, naresh v  wrote:
>>> > Hi Experts,
>>> >
>>> > I need some help regarding drop downs.
>>> >
>>> >Please find the attached sheet for your reference.
>>> >
>>> >Please help me in this regard.
>>> >
>>> >
>>> >
>>> > Thanks and Regards,
>>> > Naresh V
>>> >
>>> > --
>>> >
>>> --
>>> > 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
>>>
>>> --
>>>
>>> --
>>> 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$$ 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

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