$$Excel-Macros$$ automate copy paste

[Sundarvelan N]

Dear Friends,

I have excel book with 70 to 90 sheets, each sheet has formulas.

For consolidation purpose i need to copy paste each sheet as values.

Is there any way to automate this copy paste.

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Countif Criteria range to be Dynamic

[Sundarvelan N]

Thank you very much.

Thanks
N.Sundarvelan
9600160150

On 24 March 2017 at 21:05, Swapnil Palande 
wrote:

> Hi,
>
> There is no need of extra columns you have added in sheet 3 and sheet 1.
> Using "Sumproduct" formula you can get required output. Attached is the
> solution for your reference. I hope this is what your are looking for.
>
> Regards,
> Swapnil Suresh Palande.
>
> On Fri, Mar 24, 2017 at 7:41 PM, Sundarvelan N  wrote:
>
>>
>> Hi,
>>
>> PFA, file for your reference.
>>
>> I have found the way, but please tell me is there any other simple way.
>>
>> Below is the formula used in Sheet3.
>>
>> =COUNTIFS(INDIRECT($N14&":"&$O14),Sheet3!B$1)
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150 <096001%2060150>
>>
>> On 24 March 2017 at 18:40, Swapnil Palande 
>> wrote:
>>
>>> Hi,
>>>
>>> Need more explanation. If you could provide sample file then it is easy
>>> to provide appropriate solution.
>>> Have one query, if there is only one criteria then why are you using
>>> "COUNTIFS" formula, use "COUNTIF" instead.
>>>
>>> Regards,
>>> Swapnil Suresh Palande.
>>>
>>>
>>>
>>> On Fri, Mar 24, 2017 at 6:09 PM, Sundarvelan N 
>>> wrote:
>>>
>>>> Dear Friends,
>>>>
>>>> Please help how to dynamically change the criteria range.
>>>>
>>>> That is
>>>>
>>>> =COUNTIFS(Sheet1!$AA:$AA,Sheet3!B$2)
>>>> =COUNTIFS(Sheet1!$AB:$AB,Sheet3!B$2)
>>>> =COUNTIFS(Sheet1!$AC:$AC,Sheet3!B$2)
>>>>
>>>> Thanks
>>>> N.Sundarvelan
>>>> 9600160150 <096001%2060150>
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails

$$Excel-Macros$$ Countif Criteria range to be Dynamic

[Sundarvelan N]

Dear Friends,

Please help how to dynamically change the criteria range.

That is

=COUNTIFS(Sheet1!$AA:$AA,Sheet3!B$2)
=COUNTIFS(Sheet1!$AB:$AB,Sheet3!B$2)
=COUNTIFS(Sheet1!$AC:$AC,Sheet3!B$2)

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ VBA Help

[Sundarvelan N]

Thank you very much.

I'm learning VBA

Thanks
N.Sundarvelan
9600160150

On 19 August 2016 at 22:34, mrExcel4u  wrote:

> Hi,
> Please use the below mentioned code on Add command Button click
>
> Private Sub CommandButton1_Click()
>
> Dim Rcount As Integer
>
> Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
>
> Rcount = Rcount + 1
>
> Range("b" & Rcount).Value = Me.TextBox1.Value
> ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value
> Range("A" & Rcount).Value = Rcount - 1
>
> End Sub
>
> Thanks
>
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
> On Fri, Aug 19, 2016 at 1:10 PM, Sundarvelan N  wrote:
>
>> Dear Friends,
>>
>> I'm trying to learn VBA,
>>
>> PFA, i'm trying to add data from userform text to excel table.
>>
>> Please help
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ VBA Help

[Sundarvelan N]

Dear Friends,

I'm trying to learn VBA,

PFA, i'm trying to add data from userform text to excel table.

Please help

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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


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

$$Excel-Macros$$ Extract Text that begins with L

[Sundarvelan N]

Dear Experts,

Please help me to extract EMP ID.

I have the below sentence in D2 Cell, and i need to extract the EMP ID
which starts with L

D2 = Cash paid to L986529 - RAMESH KUMAR K towards Accomdation Charges on
09.05.2016 to 11.05.2016 amount:4100-- for Corporate Approved by Mr.Arvind

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

$$Excel-Macros$$ Free Excel Template for Garments/Apparels Inventory Management

[Sundarvelan N]

Dear Friends,

Does any one having "Free Excel Template for Garments/Apparels Inventory
Management"

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ update the current time when the status column updated as Closed.

[Sundarvelan N]

Thanks Abhishek.

Thanks
N.Sundarvelan
9600160150

On Mon, Jun 29, 2015 at 2:23 PM, Abhishek Jain 
wrote:

> Plz see attached
>
> On Mon, Jun 29, 2015 at 2:08 PM, Sundarvelan N  wrote:
>
>> Dear Friends,
>>
>> My attached excel should update the current time when the status column
>> updated as Closed.
>> 11
>> Please Help
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ update the current time when the status column updated as Closed.

[Sundarvelan N]

Dear Friends,

My attached excel should update the current time when the status column
updated as Closed.
11
Please Help

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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


Sample_Daily_Mail_Tracker.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Is there option to remove xml tags in excel

[Sundarvelan N]

Dear Friends,

Is there option to remove xml tags in excel

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

$$Excel-Macros$$ Insert Blank Row After Each Row

[Sundarvelan N]

Dear Friends,

Please help me to insert blank/new row under each row using any macro.

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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


Sample_Data.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Sundarvelan N]

We have option to export from outlook.

But in that export there is no date, if that possible my problem would be
solved.

Thanks
N.Sundarvelan
9600160150

On Wed, May 27, 2015 at 7:01 PM, Mandeep Baluja 
wrote:

> Mail is too huge to reside in a cell.
>
> On Wednesday, May 27, 2015 at 6:58:27 PM UTC+5:30, Sundarvelan wrote:
>>
>> Sorry,
>>
>> Im getting the attached error.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Wed, May 27, 2015 at 6:44 PM, Mandeep Baluja 
>> wrote:
>>
>>> check this out
>>>
>>> Regards,
>>> MandeepBaluja
>>> Learningzmypassion.
>>> https://www.facebook.com/groups/825221420889809/
>>> https://www.linkedin.com/profile/view?id=312532939
>>>
>>>
>>> On Wednesday, May 27, 2015 at 6:11:07 PM UTC+5:30, Sundarvelan wrote:
>>>>
>>>> Sorry, I'm getting error.
>>>>
>>>> I expecting file like the attached.
>>>>
>>>> Could you please include Body of the mail in the attached macro file.
>>>>
>>>> Thanks
>>>> N.Sundarvelan
>>>> 9600160150
>>>>
>>>> On Wed, May 27, 2015 at 5:02 PM, Mandeep Baluja 
>>>> wrote:
>>>>
>>>>> Working find just enable microsoft outlook 14.0 librarary and set the
>>>>> date as per your requirement basically what the code is doing to fetch
>>>>> details of mails of last two days.
>>>>>
>>>>> On Wednesday, May 27, 2015 at 4:53:57 PM UTC+5:30, Sundarvelan wrote:
>>>>>>
>>>>>> I'm using this code in Outlook
>>>>>>
>>>>>> Thanks
>>>>>> N.Sundarvelan
>>>>>> 9600160150
>>>>>>
>>>>>> On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja 
>>>>>> wrote:
>>>>>>
>>>>>>> send me the file with this code then I can understand the problem.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Mandeep Baluja
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote:
>>>>>>>>
>>>>>>>> Dear Mandeep,
>>>>>>>>
>>>>>>>> I'm getting error in the below line.
>>>>>>>>
>>>>>>>> Please help.
>>>>>>>>
>>>>>>>>lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> N.Sundarvelan
>>>>>>>> 9600160150
>>>>>>>>
>>>>>>>> On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Thanks Mandeep!!!
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>> N.Sundarvelan
>>>>>>>>> 9600160150
>>>>>>>>>
>>>>>>>>> On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja <
>>>>>>>>> rocke...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Go to file option Click on open then export it to excel , you can
>>>>>>>>>> export any folder to a excel file.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Mandeep Baluja
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan
>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>> Dear Friends,
>>>>>>>>>>>
>>>>>>>>>>> Is there any possibilities copy, Subject, From Name with email
>>>>>>>>>>> Address, Body of the mail and attachements.
>>>>>>>>>>>
>>>>>>>>>>> with customized From Date - To Date
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>

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

[Sundarvelan N]

Sorry, I'm getting error.

I expecting file like the attached.

Could you please include Body of the mail in the attached macro file.

Thanks
N.Sundarvelan
9600160150

On Wed, May 27, 2015 at 5:02 PM, Mandeep Baluja 
wrote:

> Working find just enable microsoft outlook 14.0 librarary and set the date
> as per your requirement basically what the code is doing to fetch details
> of mails of last two days.
>
> On Wednesday, May 27, 2015 at 4:53:57 PM UTC+5:30, Sundarvelan wrote:
>>
>> I'm using this code in Outlook
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja 
>> wrote:
>>
>>> send me the file with this code then I can understand the problem.
>>>
>>> Regards,
>>> Mandeep Baluja
>>>
>>>
>>>
>>>
>>> On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote:
>>>>
>>>> Dear Mandeep,
>>>>
>>>> I'm getting error in the below line.
>>>>
>>>> Please help.
>>>>
>>>>lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
>>>>
>>>> Thanks
>>>> N.Sundarvelan
>>>> 9600160150
>>>>
>>>> On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N 
>>>> wrote:
>>>>
>>>>> Thanks Mandeep!!!
>>>>>
>>>>> Thanks
>>>>> N.Sundarvelan
>>>>> 9600160150
>>>>>
>>>>> On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja 
>>>>> wrote:
>>>>>
>>>>>> Go to file option Click on open then export it to excel , you can
>>>>>> export any folder to a excel file.
>>>>>>
>>>>>> Regards,
>>>>>> Mandeep Baluja
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote:
>>>>>>>
>>>>>>> Dear Friends,
>>>>>>>
>>>>>>> Is there any possibilities copy, Subject, From Name with email
>>>>>>> Address, Body of the mail and attachements.
>>>>>>>
>>>>>>> with customized From Date - To Date
>>>>>>>
>>>>>>>
>>>>>>> Thanks
>>>>>>> N.Sundarvelan
>>>>>>> 9600160150
>>>>>>>
>>>>>>  --
>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to excel-macros...@googlegroups.com.
>>>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>>
>>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebo

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

[Sundarvelan N]

I'm using this code in Outlook

Thanks
N.Sundarvelan
9600160150

On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja 
wrote:

> send me the file with this code then I can understand the problem.
>
> Regards,
> Mandeep Baluja
>
>
>
>
> On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote:
>>
>> Dear Mandeep,
>>
>> I'm getting error in the below line.
>>
>> Please help.
>>
>>lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N  wrote:
>>
>>> Thanks Mandeep!!!
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja 
>>> wrote:
>>>
>>>> Go to file option Click on open then export it to excel , you can
>>>> export any folder to a excel file.
>>>>
>>>> Regards,
>>>> Mandeep Baluja
>>>>
>>>>
>>>>
>>>>
>>>> On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote:
>>>>>
>>>>> Dear Friends,
>>>>>
>>>>> Is there any possibilities copy, Subject, From Name with email
>>>>> Address, Body of the mail and attachements.
>>>>>
>>>>> with customized From Date - To Date
>>>>>
>>>>>
>>>>> Thanks
>>>>> N.Sundarvelan
>>>>> 9600160150
>>>>>
>>>>  --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros...@googlegroups.com.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

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

[Sundarvelan N]

But I want Macro Excel File that will auto update all mail details in excel
periodically.

Please help!!!

Thanks
N.Sundarvelan
9600160150

On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N  wrote:

> Thanks Mandeep!!!
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja 
> wrote:
>
>> Go to file option Click on open then export it to excel , you can export
>> any folder to a excel file.
>>
>> Regards,
>> Mandeep Baluja
>>
>>
>>
>>
>> On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote:
>>>
>>> Dear Friends,
>>>
>>> Is there any possibilities copy, Subject, From Name with email Address,
>>> Body of the mail and attachements.
>>>
>>> with customized From Date - To Date
>>>
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

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

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

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

[Sundarvelan N]

Thanks Mandeep!!!

Thanks
N.Sundarvelan
9600160150

On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja 
wrote:

> Go to file option Click on open then export it to excel , you can export
> any folder to a excel file.
>
> Regards,
> Mandeep Baluja
>
>
>
>
> On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote:
>>
>> Dear Friends,
>>
>> Is there any possibilities copy, Subject, From Name with email Address,
>> Body of the mail and attachements.
>>
>> with customized From Date - To Date
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Outlook Mail Details to Excel

[Sundarvelan N]

Dear Friends,

Is there any possibilities copy, Subject, From Name with email Address,
Body of the mail and attachements.

with customized From Date - To Date


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Repeat/Continue Action till error/not found

[Sundarvelan N]

Hi Mandeep,

I want to unmerge the rows nos 1,15,25,31,43,113,126,193,200

This may increase or decrease in my upcoming month excel hence i want to
continue merge all the header rows as much as the headers.



Thanks
N.Sundarvelan
9600160150

On Wed, May 6, 2015 at 12:06 PM, Mandeep Baluja 
wrote:

> which cells you want to unmerge ???  Please clear that on which column you
> need to check your physician Text. ??? Elaborate your query please as my
> macro works for column 1
>
> On Wednesday, May 6, 2015 at 11:44:50 AM UTC+5:30, Sundarvelan wrote:
>>
>> Please find the attached file for your reference.
>>
>> When i apply your macro it doesn't work.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Wed, May 6, 2015 at 10:02 AM, Mandeep Baluja 
>> wrote:
>>
>>> what is the error you are getting give me the snapshot.
>>>
>>> On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sundarvelan wrote:

 Thanks Mandeep,

 But the given solution is not working.

 Thanks
 N.Sundarvelan
 9600160150

 On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja 
 wrote:

> Sub Search()
>>
>> Dim FirstAddress As String
>>
>> With ActiveSheet.Range("A:A")
>> Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
>> LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows,
>> SearchDirection:=xlNext)
>>
>> If Not Rng Is Nothing Then
>> FirstAddress = Rng.Address
>> Do
>> Rng.Offset(0, 1) = "X"
>> Rng.EntireRow.UnMerge
>> Set Rng = .FindNext(Rng)
>> Loop While Not Rng Is Nothing And Rng.Address <> FirstAddress
>> End If
>>
>> End With
>> '
>> End Sub
>>
>
> Check this Out.
>
> Regards,
> Mandeep Baluja
> Email :-mandeep...@snapdeal.com
> mandeep...@gmail.com
> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
> https://www.facebook.com/groups/825221420889809/
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@googlegroups.com.
> To post to this group, send email to excel-...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, 

Re: $$Excel-Macros$$ Re: Repeat/Continue Action till error/not found

[Sundarvelan N]

Please find the attached file for your reference.

When i apply your macro it doesn't work.

Thanks
N.Sundarvelan
9600160150

On Wed, May 6, 2015 at 10:02 AM, Mandeep Baluja 
wrote:

> what is the error you are getting give me the snapshot.
>
> On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sundarvelan wrote:
>>
>> Thanks Mandeep,
>>
>> But the given solution is not working.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja 
>> wrote:
>>
>>> Sub Search()

 Dim FirstAddress As String

 With ActiveSheet.Range("A:A")
 Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
 LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows,
 SearchDirection:=xlNext)

 If Not Rng Is Nothing Then
 FirstAddress = Rng.Address
 Do
 Rng.Offset(0, 1) = "X"
 Rng.EntireRow.UnMerge
 Set Rng = .FindNext(Rng)
 Loop While Not Rng Is Nothing And Rng.Address <> FirstAddress
 End If

 End With
 '
 End Sub

>>>
>>> Check this Out.
>>>
>>> Regards,
>>> Mandeep Baluja
>>> Email :-mandeep...@snapdeal.com
>>> mandeep...@gmail.com
>>> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
>>> https://www.facebook.com/groups/825221420889809/
>>>
>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

Re: $$Excel-Macros$$ Re: Repeat/Continue Action till error/not found

[Sundarvelan N]

Thanks Mandeep,

But the given solution is not working.

Thanks
N.Sundarvelan
9600160150

On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja 
wrote:

> Sub Search()
>>
>> Dim FirstAddress As String
>>
>> With ActiveSheet.Range("A:A")
>> Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
>> LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows,
>> SearchDirection:=xlNext)
>>
>> If Not Rng Is Nothing Then
>> FirstAddress = Rng.Address
>> Do
>> Rng.Offset(0, 1) = "X"
>> Rng.EntireRow.UnMerge
>> Set Rng = .FindNext(Rng)
>> Loop While Not Rng Is Nothing And Rng.Address <> FirstAddress
>> End If
>>
>> End With
>> '
>> End Sub
>>
>
> Check this Out.
>
> Regards,
> Mandeep Baluja
> Email :-mandeep.bal...@snapdeal.com
> mandeep.bal...@gmail.com
> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
> https://www.facebook.com/groups/825221420889809/
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Repeat/Continue Action till error/not found

[Sundarvelan N]

Dear Friends,

Please help me to repeat/Continue the below action till it reach error OR
not found .

Cells.Find(What:="physician", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.EntireRow.Select
Selection.UnMerge


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

[Sundarvelan N]

Friends.

I tried all your suggestions i did not got the answer

Thanks
N.Sundarvelan
9600160150

On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna 
wrote:

> Hi,
>
> Assuming yours values are in range A1:A10, you need to enter the following
> as an Array Formula
>
> =MAX(--RIGHT(A1:A10,8))
>
> To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter
> after entering the formula in the Cell.
>
> On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap 
> wrote:
>
>> Hi Frd,
>>
>> =max(substitute(cellvalue ya cell reference,"IT","",1))
>>
>> Try kro bhai
>> On Oct 9, 2014 6:25 PM, "Sundarvelan N"  wrote:
>>
>>> Dear Friends,
>>>
>>> Please help me in finding the maximum value in a non numeric column,
>>> example below
>>>
>>> Answer needed is IT20140010
>>>
>>>
>>>  IT20140001  IT20140002  IT20140003  IT20140004  IT20140005  IT20140006
>>> IT20140007  IT20140008  IT20140009  IT20140010
>>>
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Sincere Regards
> CA Kanwaljit Singh Dhunna
> +91-987 6739 911
> +91-950 1031 007
> P*Please don't print this e-mail unless you really need to.*
> *IF U LOSE, DON'T LOSE THE LESSON.*
>
> --
> 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 no

$$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN

[Sundarvelan N]

Dear Friends,

Please help me in finding the maximum value in a non numeric column,
example below

Answer needed is IT20140010


 IT20140001  IT20140002  IT20140003  IT20140004  IT20140005  IT20140006
IT20140007  IT20140008  IT20140009  IT20140010


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ calculate previous month dates using the given date

[Sundarvelan N]

I need,

 2 Jan to 1 Feb


Thanks
N.Sundarvelan
9600160150


On Tue, Feb 11, 2014 at 2:44 PM, DILIPandey  wrote:

> Hi Kathirvelan,
>
> You need dates between 2Jan to 1 Feb
> or, 2 Jan to 3 Feb ?
>
>
>
> On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N wrote:
>
>> Dear Friends,
>>
>> I need to calculate previous month dates using the given date
>>
>> Given Date : 03-Feb-2014
>>
>> From Date Should Be : 02-Jan-2014
>>
>> To Date : 01-Feb-2014
>>
>> Thanks,
>> Kathirvelan
>>
>> --
>> 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.
>>
>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, 
> mvp
>MBA,BCA,B.Com(Hons)
> UAE +971 528225509 India +91 9810929744
> dilipan...@gmail.com, dilipan...@yahoo.com
>
> Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey
>
> --
> 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.

$$Excel-Macros$$ Training Sylabus

[Sundarvelan N]

Dear Friends,

Please share any training material with sylabus (Basic, Intermediate &
Advanced) to train new students.
 Thanks
N.Sundarvelan
9600160150

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

$$Excel-Macros$$ suddenly my excel language changed from english to urdu

[Sundarvelan N]

Dear Friends,

Suddenly my excel language (font) changed from english to urdu. What is the
short cut please.
 Thanks
N.Sundarvelan
9600160150

-- 
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$$ CAPTURE ATTENDENCE FROM MULTIPLE SHEET

[Sundarvelan N]

Dear Friends,

Thanks all for your support it helped me great.

Thanks,
Sundarvelan. N

Thanks
N.Sundarvelan
9600160150


On Tue, Jun 18, 2013 at 1:32 PM, P.VIJAYKUMAR  wrote:

> Respected Preethiji,
>
> Where and how did u learn these advanced excel formulas and also VBA.How
> to get to Intermediate or to expert level like you in Excel and VBA.Is it
> through regular practice or should be take coaching or classes for that.
>
> Regards,
> P.VIJAY KUMAR
>
> --
> 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.

$$Excel-Macros$$ CAPTURE ATTENDENCE FROM MULTIPLE SHEET

[Sundarvelan N]

Dear Friends,

Please help me capturing the attendance from multiple sheet.
Thanks
N.Sundarvelan
9600160150

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




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

$$Excel-Macros$$ Amount in words

[Sundarvelan N]

Dear Friends,

Please help me to convert amount in words

1500 = thousand five hundred
 Thanks
N.Sundarvelan
9600160150

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ VLOOKUP_HELP

[Sundarvelan N]

Thankyou so much Friends.

Simply your great people.
 Thanks
N.Sundarvelan
9600160150


On Thu, Mar 28, 2013 at 11:32 AM, NOORAIN ANSARI
wrote:

> Dear Sundar,
>
>
> Please see attachment , Hope it will help to you.
>
>
>  On Thu, Mar 28, 2013 at 11:18 AM, Sundarvelan N wrote:
>
>> Dear Friends,
>>
>> Please help me to get the next vlookup value.
>>  Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> 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?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/>
> http:// 
> <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ IGNORE_BLANK_CELLS_AND_COMBINE_WITH_UNIQUE

[Sundarvelan N]

Dear Freinds,

Please help me to combine ignoring the blank cells

 Thanks
N.Sundarvelan
9600160150

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




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

Re: $$Excel-Macros$$ Previous sheet name using formula

[Sundarvelan N]

Thanks Paul and My Dear Friends.

My question was to get sheet name which is left of my current sheet by
formula.


Any how i found solution completed my project by other way.
 Thanks
N.Sundarvelan
9600160150


On Wed, Mar 27, 2013 at 9:49 PM, Sam Mathai Chacko wrote:

>   You could also use the MID function instead of REPLACE
>
> example
>
> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,31)
>
> Note that the second formula in my previous post requires enabling your
> macro settings. So I am not sure how much that is helpful in the end
> (assuming the reason you wanted to do it using formula was to avoid having
> to do anything to do with macro in the first place)
>
> Regards,
> Sam
>
>
> On Wed, Mar 27, 2013 at 9:44 PM, Sam Mathai Chacko wrote:
>
>> I would agree with Paul. The best thing to do is to write a function
>> like this
>>
>> Function PREVSHEETNAME() As String
>>
>> On Error Resume Next
>> PREVSHEETNAME = 
>> ActiveSheet.Previous.Name<http://activesheet.previous.name/>
>> Application.Volatile
>>
>> End Function
>>
>> On the contrary, if you are still intent on doing this with formula, you
>> could try a rather unconventional method using XLM formulas
>>
>> Create two named ranges as below
>>
>> SheetName =REPLACE(CELL("filename"),1,FIND("]",CELL("filename")),"")
>>
>> SheetNames = REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
>>
>> And in your sheet (starting from the second sheet of course), use the
>> formula =INDEX(SheetNames,MATCH(SheetName,SheetNames,0)-1)
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Wed, Mar 27, 2013 at 7:01 PM, Paul Schreiner 
>> wrote:
>>
>>>   How do you define "Previous Sheet Name"?
>>> Do you mean the name of the sheet before it was changed to the current
>>> name?
>>> or do you mean the name of the sheet immediately to the left of the
>>> selected sheet?
>>>
>>> Also, you said "using formula", does that mean you wish for an excel
>>> function that will show (in a cell) whatever it is you refer to as
>>> "Previous Sheet Name"?
>>>
>>> If you're wanting the name of the sheet immediately to the left,
>>> I doubt very much that we can do it using "standard" Excel functions.
>>> We can create a function that looks in the Sheets() array for the
>>> current sheet name,
>>> then determines the name of the sheet with the "previous" array index...
>>>
>>>
>>>
>>> *Paul*
>>>
>>> -
>>> *“Do all the good you can,
>>> By all the means you can,
>>> In all the ways you can,
>>> In all the places you can,
>>> At all the times you can,
>>> To all the people you can,
>>> As long as ever you can.” - John Wesley
>>> *-
>>>
>>>
>>>  --
>>> *From:* Sundarvelan N 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Wed, March 27, 2013 9:12:14 AM
>>> *Subject:* $$Excel-Macros$$ Previous sheet name using formula
>>>
>>> Dear Friends,
>>>
>>> Please help me to get the previous sheet name using formula
>>>  Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> 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 Goo

$$Excel-Macros$$ Previous sheet name using formula

[Sundarvelan N]

Dear Friends,

Please help me to get the previous sheet name using formula
 Thanks
N.Sundarvelan
9600160150

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ use cell address in offset

[Sundarvelan N]

Dear Friends,

Please help me in using the cell address in offset.

=IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET(
'TNCMCHIS_CALC-2'!$A6,('TNCMCHIS_CALC-2'!$R6),0,1,1),"CONTINUE")


I want to use the below output in the above highlighted place.

=ADDRESS(MATCH(VLOOKUP(IF('TNCMCHIS_CALC-2'!$R7=1,'TNCMCHIS_CALC-2'!$A7,IF('TNCMCHIS_CALC-2'!$R7>1,'TNCMCHIS_CALC-2'!$A7,"NEXT1")),'TNCMCHIS_CALC-2'!$A:$A,1,0),'TNCMCHIS_CALC-2'!$A:$A,0),1,1)
 Thanks
N.Sundarvelan
9600160150

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ count no of students for each month

[Sundarvelan N]

Thaks for your reply

But i need 6 for July

Unique value.
Thanks
N.Sundarvelan
9600160150



On Fri, Dec 7, 2012 at 5:48 PM, Born to Win  wrote:

> PFA
>
>
> Thanks,
>
>
>
>
>
> On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N  wrote:
>
>> Dear Gurus,
>>
>> Please help me to count no of students for each month
>>
>> For example :
>>
>> july 6 students
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ count no of students for each month

[Sundarvelan N]

Dear Gurus,

Please help me to count no of students for each month

For example :

july 6 students
Thanks
N.Sundarvelan
9600160150

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




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

$$Excel-Macros$$ Is their any certification for Excel expertise like MCP, MCSE

[Sundarvelan N]

Dear Gurus,

Please help me how to/where to apply for excel expert certification.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

[Sundarvelan N]

Dear Gurus,

I have a file which has the values like 6 - 11

7 - 20

2 - 27

which is automatically changing to date format but it should display the
same 6 - 11

7 - 20

2 - 27

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

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

[Sundarvelan N]

Dear Gurus,

Thanks for all your replies it worked. Thanks lot.
Thanks
N.Sundarvelan
9600160150



On Tue, Oct 30, 2012 at 4:41 PM, Rohan Young  wrote:

> hi,
>
> try this
>
> Regds
>
>
> On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics) <
> prasad.kam...@imrbint.com> wrote:
>
>>  Hi Sundarvelan,
>>
>>
>> PFA…done with conditional formatting.
>>
>> ** **
>>
>> Regards,
>>
>> Prasad K
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Sundarvelan N
>> *Sent:* Tuesday, October 30, 2012 3:55 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ If greater then the cell color should be red
>> else green
>>
>> ** **
>>
>> Dear Gurus,
>>
>>  
>>
>> Please help me on the attached excel query.
>>
>>  
>>
>> If greater than EOT then the cell color should be red elase green
>>
>>
>>  
>>
>> Thanks
>>
>> N.Sundarvelan 
>>
>> 9600160150
>>
>> ** **
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>  
>>
>> http://www.imrbint.com/disclaimer.html
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> me

$$Excel-Macros$$ Count the no of Red colored cells and green colored cells

[Sundarvelan N]

Dear Gurus,

Please help me to Count the no of Red colored cells and green colored cells.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

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

[Sundarvelan N]

Dear Gurus,

Please help me on the attached excel query.

If greater than EOT then the cell color should be red elase green


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

$$Excel-Macros$$ By Default Highlight the row based on the location of the cursor like the attached excel

[Sundarvelan N]

Dear Gurus,

Please help me to highlight the row based on the location of the cursor.
This should be applied default to all the excel file im opening.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




ROW_HIGHLIGHT_MACRO_V1.xlsm
Description: Binary data

$$Excel-Macros$$ help:increase the sheet number in a formula

[Sundarvelan N]

Hi Gurus,

Please help me in this formula

increase the sheet number in formula

=IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),"TRUE",0)="TRUE",TRIM(RIGHT(*
Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(":",SUBSTITUTE(*Sheet1*!$B1," ",":",LEN(*
Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1," ","")),0)

I would like to increase the *Sheet1 to sheet2, sheet3 *down the rows.


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

[Sundarvelan N]

Please find the attached file for your reference

Opne the file enable the macro and press ctrl+m

and click any where in the excel you will find my requirement.

I need this task should be completed by mouse/keyboard move.
Thanks
N.Sundarvelan
9600160150



On Wed, Oct 17, 2012 at 5:26 PM, Paul Schreiner wrote:

>  You explanation is somewhat vague..
> By breaking it down into individual definitions:
>
> "Repeating the macro" implies that you have a macro in mind.. good start.
>
> "cursor" is a general term referred to the "type-in bar", usually a
> vertical bar (|) or underscore (_).
>
> "cursor move" would then be movement of that "type-in bar".
> However, that would be a problem.
> By strict definition, the "type-in bar" doesn't appear unless you are
> editing the contents of a cell.  Either by double-clicking and entering the
> cell, or clicking inside the content box near the address bar.
> Then, the implication is that if you use the left-arrow and move one
> character to the left, the macro would run.. if you insert a character, the
> macro would run.
> This isn't possible...
>
> Technically, when you select a cell, there is no "cursor" because you have
> not begun to edit the contents.
>
> However, if instead of "cursor move" you mean when a cell is SELECTED.
> Then there are possibilities.
>
> You can create a Worksheet_SelectionChange event macro
> that would execute each time a cell is selected
> (unless you select the cell which is currently selected
>  in which case the selected cell hasn't changed)
>
> in the Event macro, you would then call your previously defined macro.
>
> let me know if you need help creating a selectionChange event macro.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Sundarvelan N 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, October 17, 2012 2:10:40 AM
> *Subject:* $$Excel-Macros$$ Macro Help: Repeat the macro for each cursor
> move
>
> Dear Gurus,
>
> Please help me in repeating the macro for each cursor move.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received t

$$Excel-Macros$$ Macro Help: Repeat the macro for each cursor move

[Sundarvelan N]

Dear Gurus,

Please help me in repeating the macro for each cursor move.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

[Sundarvelan N]

Thanks prince141987 & Karan1237

Thanks
N.Sundarvelan
9600160150



On Mon, Sep 17, 2012 at 3:00 PM, Karan Singh  wrote:

> Dear Sundar,
>
> Please use below formula :
>
>
> =LEFT(A1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},A1&"0123456789"))-1)
>
> Rgds
> Karan Singh
>
>
>
>
> On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N  wrote:
>
>> Hi Friednds,
>>
>> Please help me to extract only text from alphanumeric word for example
>>
>> NT2 = *NT*
>> SUB123= *SUB*
>> WELC90= *WELC*
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ EXTRACT ONLY TEXT

[Sundarvelan N]

Hi Friednds,

Please help me to extract only text from alphanumeric word for example

NT2 = *NT*
SUB123= *SUB*
WELC90= *WELC*
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Calculate Starting Date Based on Week Number in a year

[Sundarvelan N]

Hi Friends,

Help me in find the Starting Date Based on Week Number in a year.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ find the latest date

[Sundarvelan N]

Dear Friends,

Please help me to find the latest date of a student.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




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

$$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

[Sundarvelan N]

Dear Friends,

Help me to find the circle and area. Please find the attached file for your
reference.
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




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

Re: $$Excel-Macros$$ Ratio Calculation

[Sundarvelan N]

Dear All,

I used the below formula.

 *MALE* *FEMALE* *RATIO*  967 696
=$D4/(GCD($D4,$E4))&":"&$E4/(GCD($D4,$E4))

But i got this answer is this the correct answer

967:696

Thanks
N.Sundarvelan
9600160150



On Sun, Sep 2, 2012 at 3:35 PM, ashish koul  wrote:

> http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
> http://www.dailydoseofexcel.com/archives/2004/04/29/formatting-ratios/
>
>
> On Sun, Sep 2, 2012 at 3:33 PM, Sundarvelan N  wrote:
>
>> Dear Friends,
>>
>> Help me in calculating the ratio.
>>
>>  *MALE* *FEMALE* *RATIO*  967 696   1376 990   1602 1239   1545 1155
>>   1377 1057   1220 914   1003 708
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
>  *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Ratio Calculation

[Sundarvelan N]

Dear Friends,

Help me in calculating the ratio.

 *MALE* *FEMALE* *RATIO*  967 6961376 9901602 12391545 1155
   1377 10571220 9141003 708


Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ is that is sunday

[Sundarvelan N]

Please find the attached file for your reference.


Thanks
N.Sundarvelan
9600160150



On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar wrote:

> Hi Sundarvelan,
>
> Tri it..
>
> =Text(a1,"ddd")
>
> Regard
> Manoj
>
>
> On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote:
>
>>
>> Hi Sundarvelan,
>>
>> Please share a sample worksheet.
>>
>> Regards,
>> Kuldeep Singh
>>
>>
>> On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote:
>>
>>> Dear friends,
>>>
>>> I need to find is the date in the cell is sunday
>>>
>>>8/3/2012 10:30  8/3/2012 11:47  8/3/2012 10:26  8/3/2012 10:03  8/3/2012
>>> 11:09  8/3/2012 10:55 8/4/2012 10:57  8/3/2012 16:17  8/3/2012 14:21  
>>> 8/3/2012
>>> 11:29  8/3/2012 11:28  8/3/2012 11:53  8/3/2012 14:33
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>   --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential 

$$Excel-Macros$$ is that is sunday

[Sundarvelan N]

Dear friends,

I need to find is the date in the cell is sunday

8/3/2012 10:30 8/3/2012 11:47  8/3/2012 10:26  8/3/2012 10:03  8/3/2012
11:09  8/3/2012 10:55 8/4/2012 10:57  8/3/2012 16:17  8/3/2012
14:21  8/3/2012
11:29  8/3/2012 11:28  8/3/2012 11:53  8/3/2012 14:33
Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

[Sundarvelan N]

Dear Friends,

Please help me, after i updated the cell C17 the cursor should go to the
update button so that i dont use mouse to update please please help me
Thanks
N.Sundarvelan
9600160150



On Mon, Aug 13, 2012 at 3:46 PM, Sundarvelan N  wrote:

> Hello Friends,
>
> Some how i finished my project. Last one help to finish my project.
>
> My task is after i passedcorssed the cell C17 the cursor should go to
> update button, please help me as soon as possible.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon wrote:
>
>> This looks like school homework to me.  If we do your homework for you,
>> you learn nothing.  Use the resource materials you have no doubt been
>> given, read the book.  Try to do it yourself - even if you can only do part
>> of it.  Than come back to the group to help you with any specific aspect
>> that is causing you problems.
>>
>>
>> On 11 August 2012 20:10, Sundarvelan N  wrote:
>>
>>> Brothers please help me
>>>
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>>
>>>
>>> -- Forwarded message --
>>> From: Sundarvelan N 
>>> Date: Wed, Aug 8, 2012 at 2:32 PM
>>> Subject: Data Entry - Need insert rows when i press enter button
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Hello Friends,
>>>
>>> I need to complete a projec. The requirement as follows
>>>
>>>
>>>1. When i press ENTER button in the INPUT sheet the data should add
>>>in the DATA sheet
>>>2. The cursor should automatically go to the next tex box when i hit
>>>enter button
>>>
>>> I would be thankfull if it is done as soon as possible.
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Regards
>> David Grugeon
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> &qu

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

[Sundarvelan N]

Hello Friends,

Some how i finished my project. Last one help to finish my project.

My task is after i passedcorssed the cell C17 the cursor should go to
update button, please help me as soon as possible.
Thanks
N.Sundarvelan
9600160150



On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon  wrote:

> This looks like school homework to me.  If we do your homework for you,
> you learn nothing.  Use the resource materials you have no doubt been
> given, read the book.  Try to do it yourself - even if you can only do part
> of it.  Than come back to the group to help you with any specific aspect
> that is causing you problems.
>
>
> On 11 August 2012 20:10, Sundarvelan N  wrote:
>
>> Brothers please help me
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>>
>> -- Forwarded message --
>> From: Sundarvelan N 
>> Date: Wed, Aug 8, 2012 at 2:32 PM
>> Subject: Data Entry - Need insert rows when i press enter button
>> To: excel-macros@googlegroups.com
>>
>>
>> Hello Friends,
>>
>> I need to complete a projec. The requirement as follows
>>
>>
>>1. When i press ENTER button in the INPUT sheet the data should add
>>in the DATA sheet
>>2. The cursor should automatically go to the next tex box when i hit
>>enter button
>>
>> I would be thankfull if it is done as soon as possible.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Regards
> David Grugeon
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

[Sundarvelan N]

Brothers please help me


Thanks
N.Sundarvelan
9600160150



-- Forwarded message --
From: Sundarvelan N 
Date: Wed, Aug 8, 2012 at 2:32 PM
Subject: Data Entry - Need insert rows when i press enter button
To: excel-macros@googlegroups.com


Hello Friends,

I need to complete a projec. The requirement as follows


   1. When i press ENTER button in the INPUT sheet the data should add in
   the DATA sheet
   2. The cursor should automatically go to the next tex box when i hit
   enter button

I would be thankfull if it is done as soon as possible.

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




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

Re: $$Excel-Macros$$ how to calculate greathan 5:00 P.M

[Sundarvelan N]

Thanks Ashish and Noorain for the prompt help


Thanks
N.Sundarvelan
9600160150



On Fri, Aug 10, 2012 at 2:44 PM, NOORAIN ANSARI wrote:

> Dear Sundar,
>
> Please use it
>
> =IF(TIME(HOUR(B163),MINUTE(B163),SECOND(B163))>=TIMEVALUE("5:00
> PM"),"Greater that 5:00 P.M","")
>
>
>
>
>
> On Fri, Aug 10, 2012 at 2:34 PM, Sundarvelan N  wrote:
>
>> Please find the attached file
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>>
>> On Fri, Aug 10, 2012 at 2:26 PM, ashish koul wrote:
>>
>>> share the sample file
>>>
>>>
>>> On Fri, Aug 10, 2012 at 2:25 PM, Sundarvelan N wrote:
>>>
>>>> Dear Excel Gurus,
>>>>
>>>> Please help me in calculating greater than 5:00 P.M
>>>>
>>>> the input will be in this format -  6/1/2012  10:06:20 AM
>>>>
>>>> Thanks
>>>> N.Sundarvelan
>>>> 9600160150
>>>>
>>>> --
>>>> Join official facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> 6) Jobs posting is not allowed.
>>>>
>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>>
>>>
>>>  *Visit*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/*
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES 

$$Excel-Macros$$ how to calculate greathan 5:00 P.M

[Sundarvelan N]

Dear Excel Gurus,

Please help me in calculating greater than 5:00 P.M

the input will be in this format -  6/1/2012  10:06:20 AM

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Data Entry - Need insert rows when i press enter button

[Sundarvelan N]

Hello Friends,

I need to complete a projec. The requirement as follows


   1. When i press ENTER button in the INPUT sheet the data should add in
   the DATA sheet
   2. The cursor should automatically go to the next tex box when i hit
   enter button

I would be thankfull if it is done as soon as possible.

Thanks
N.Sundarvelan
9600160150

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




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

$$Excel-Macros$$ Forcasting for acquring New Project

[Sundarvelan N]

Hi Friends,

Can any body share me forecasing templates in excel file.
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in 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$$ Time Calculation in TAT Report : If greater than 5 hours

[Sundarvelan N]

Hi Friends,

Please help me in calculating the TAT

If my registration is 9 A.M

and the despatch time is 10 A.M - Met the TAT
IF the despatch time is 3 P.M - Not Me the TAT
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in 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$$ count the name in a column

[Sundarvelan N]

Hi Friends,

Could you please help in counting the name in a column.
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in 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

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

$$Excel-Macros$$ Shortcut for time in OPENOFFICE [ like Excel Ctrl+Shift+: ]

[Sundarvelan N]

Hi Experts,
Could you please tell me what is shortcut key like excel Ctrl+Shift+:in
OPENOFFICE.
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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

Fwd: $$Excel-Macros$$ Sumproduct accross multiple sheets

[Sundarvelan N]

Friends help me on this help.
Thanks
N.Sundarvelan
9600160150



-- Forwarded message --
From: Sundarvelan N 
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com


Hi Friends,

Help me in achieving this task.

sumproduct across multiple sheets


Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

NOTE : Don't ever post personal or confidential data in 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


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

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

[Sundarvelan N]

Thank you so much
Thanks
N.Sundarvelan
9600160150



On Wed, Feb 29, 2012 at 8:05 PM, dguillett1  wrote:

>   Or this which copies template to the end.
>
> Private Sub Workbook_Open()
> Dim mydate As String
> mydate = Format(Date, "dd-mm-")
> With Sheets(Sheets.Count)
> If .Name <> mydate Then
> Sheets("Template").Copy after:=Sheets(.Index)
> ActiveSheet.Name = mydate
> End If
> End With
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Paul Schreiner 
> *Sent:* Wednesday, February 29, 2012 6:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays
> date
>
>   First:
> save your file as .xlsb or .xlsm...
> Then create a Workbook Open event macro in the Thisworkbook module:
>
>
> Private Sub Workbook_Open()
> Dim Sht
> Err.Clear
> On Error Resume Next
> Sht = Format(Now(), "dd-mmm-yy")
> Sheets(Sht).Select
> If (Err) Then
> Sheets("TEMPLATE").Copy Before:=Sheets(1)
> ActiveSheet.Name = Sht
> End If
> End Sub
>
> The macro turns off the Error handler so that selecting a sheet
> that doesn't exist will not halt the program.
>
> This macro then creates a sheet name in the format of "dd-mmm-yy"
> it then tries to select the sheet with this name.
> If the sheet doesn't exist, the error code will be set.
> If an error occurred, then the Template is copied (to the first sheet of
> the workbook)
> and renamed to the date string.
>
> If an error did NOT occur, then of course, the daily sheet will be active.
>
> hope this helps.
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Sundarvelan N 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, February 29, 2012 6:26:38 AM
> *Subject:* $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date
>
> Hi Friends,
>
> I need a help in my project. I have excel file in which template sheet is
> constant. When i open that file in the morning it should copy the template
> sheet and rename the sheet with todays date. In the same day i will be
> closing and opening that file many times but it should not insert every
> time i open in a same day.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in 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

Re: $$Excel-Macros$$ Re: calculate from multiple sheets & calculate from multiple sheets with conditions

[Sundarvelan N]

Thank you verymuch my dear friends
Thanks
N.Sundarvelan
9600160150



On Thu, Mar 1, 2012 at 4:49 AM, Haseeb Avarakkan  wrote:

> Hello Sundarvelan,
>
> Assume your sheet name always be in dd-mmm-yy format, if so see the
> attached.
>
> In Summary B1 & B2, enter the Start & End Date, So this will calculate
> results between these sheets.
>
> ___
> HTH, Haseeb
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Sumproduct accross multiple sheets

[Sundarvelan N]

Hi Friends,

Help me in achieving this task.

sumproduct across multiple sheets


Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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


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

Re: $$Excel-Macros$$ calculate from multiple sheets & calculate from multiple sheets with conditions

[Sundarvelan N]

Hello Friends,

Can i achive this using formula.
Thanks
N.Sundarvelan
9600160150



On Wed, Feb 29, 2012 at 6:47 PM, Shaik Waheed  wrote:

> How abt getting the same with the multiples sheet pivot. Here is what i
> had tried, u can select required fields from value filter.
>
>
> On Wed, Feb 29, 2012 at 6:27 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Sundar,
>>
>> Please see attached sheet, you can use..
>>
>> Sub Count_VBA()
>> On Error Resume Next
>> c = 1
>> For Each Sh In ActiveWorkbook.Sheets
>> If Sh.Name <> Sheets("Summary") Then
>> Sheets("Summary").Cells(2, "B").Value = Sheets("Summary").Cells(2,
>> "B").Value + Application.WorksheetFunction.CountA(Sh.Range("C:C"))
>> Sheets("Summary").Cells(3, "B").Value = Sheets("Summary").Cells(3,
>> "B").Value + Application.WorksheetFunction.CountIf(Sh.Range("C:C"),
>> "Driver") + Application.WorksheetFunction.CountIf(Sh.Range("C:C"),
>> "Sweeper")
>> End If
>> c = c + 1
>> Next
>> Sheet9.Cells(2, "B").Value = Sheet9.Cells(2, "B").Value - c
>> On Error GoTo 0
>> End Sub
>>
>>
>>   On Wed, Feb 29, 2012 at 5:15 PM, Sundarvelan N wrote:
>>
>>> Hi Freinds,
>>>
>>> help me to achieve this task.
>>>
>>> COUNT OF TOTAL EMPLOYEES 168 COUNT OF DRIVER AND  SWEEPER 56
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post persona

$$Excel-Macros$$ calculate from multiple sheets & calculate from multiple sheets with conditions

[Sundarvelan N]

Hi Freinds,

help me to achieve this task.

  COUNT OF TOTAL EMPLOYEES 168  COUNT OF DRIVER AND  SWEEPER 56

Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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


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

$$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

[Sundarvelan N]

Hi Friends,

I need a help in my project. I have excel file in which template sheet is
constant. When i open that file in the morning it should copy the template
sheet and rename the sheet with todays date. In the same day i will be
closing and opening that file many times but it should not insert every
time i open in a same day.
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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


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

Re: $$Excel-Macros$$ Could you please explain why are we using -- in this formula

[Sundarvelan N]

Thank you very much my dear friends, for yours quick reply.

Thanks
N.Sundarvelan
9600160150



On Wed, Jan 4, 2012 at 12:12 PM, NOORAIN ANSARI wrote:

> Dear Sundarvelan,
>
> The -- is used as an unary operator to convert a boolean value ie,
> TRUE/FALSE in to 1/0.
>
> So to negate this, we use unary operator -- with TRUE or FALSE to give 1
> or 0
>
> We can also use ++ ,0+1,*1
>
> In fact you can also use a multiplier or a divisor of 1
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
> On Wed, Jan 4, 2012 at 11:31 AM, Sundarvelan N  wrote:
>
>> Hi Friends,
>>
>> Could you please explain why are we using -- in this formula.
>>
>> =IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(--
>> TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)),"",OFFSET($A$1,MATCH(0,MMULT(
>> --
>> TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1))
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Could you please explain why are we using -- in this formula

[Sundarvelan N]

Hi Friends,

Could you please explain why are we using -- in this formula.

=IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)),"",OFFSET($A$1,MATCH(0,MMULT(
--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1))

Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Convert text to date using formula...

[Sundarvelan N]

Hi,

Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150



On Fri, Nov 25, 2011 at 11:18 AM,  wrote:

> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Concatenation / Consolidate Based on Condition

[Sundarvelan N]

Asish Thankyou so much!

Very Very Thanks
Thanks
N.Sundarvelan
9600160150



On Tue, Nov 1, 2011 at 12:37 PM, ashish koul  wrote:

> check if it helps
>
>
> On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N  wrote:
>
>> Hi Frineds,
>>
>> Please find the attached file for your reference. I need to concatinate /
>> Consolidate based on condition.
>>
>> FORMULA or by MACRO
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>  --
>> FORUM RULES (925+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Concatenation / Consolidate Based on Condition

[Sundarvelan N]

Hi Frineds,

Please find the attached file for your reference. I need to concatinate /
Consolidate based on condition.

FORMULA or by MACRO
Thanks
N.Sundarvelan
9600160150

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

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

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

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

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

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

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

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


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

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

[Sundarvelan N]

Please refere the attached file.


Thanks
N.Sundarvelan
9600160150



On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar wrote:

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

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

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


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

Re: $$Excel-Macros$$ Please help

[Sundarvelan N]

>
> Hi Team,
>
> Still i'm notable to find the solution for this task. Please find the
> attachments.
>


> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Thu, Aug 11, 2011 at 3:18 AM, dguillett1  wrote:
>
>>
>> Or with col 8 formatted as desired place this in the SHEET module
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If Target.Row < 2 Or Target.Column <> 7 Then Exit Sub
>> If UCase(Target) = "DONE" Then Target.Offset(, 1) = Date
>> End Sub
>> -Original Message- From: XLS S
>> Sent: Wednesday, August 10, 2011 1:19 PM
>>
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Please help
>>
>>
>> Hey Sundaryelan,
>>
>> Please find the attachment
>>
>> .
>>
>> On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> Please refer the attached image. Please help on this scenatio.
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>> --
>>> --**--**
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/**exceldailytip <http://twitter.com/exceldailytip>
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/**
>>> groups?gid=1871310 <http://www.linkedin.com/groups?gid=1871310>
>>> 3. Excel tutorials at 
>>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>>> 4. Learn VBA Macros at 
>>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>>> 5. Excel Tips and Tricks at 
>>> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com/>
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><>**<><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/**discussexcel<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 <http://twitter.com/exceldailytip>
>> 2. Join our LinkedIN group @ 
>> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
>> 3. Excel tutorials at 
>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>> 4. Learn VBA Macros at 
>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>> 5. Excel Tips and Tricks at 
>> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com/>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><>**<><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/**discussexcel<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 <http://twitter.com/exceldailytip>
>> 2. Join our LinkedIN group @ 
>> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
>> 3. Excel tutorials at 
>> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com/>
>> 4. Learn VBA Macros at 
>> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com/>
>> 5. Excel Tips and Tricks at 
>> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com/>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><>**<><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/**discussexcel<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-1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Uniques Values

[Sundarvelan N]

Hi Friends,

I applied this formula it doesn't work for me.

Thanks
N.Sundarvelan
9600160150



On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hi Sundarvelan,
>
> Since you are dealing with valid numbers use SMALL function.
>
> in G3 enter,
>
> =MIN(B:D)
>
> G4, copy down.
>
> =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"")
>
> HTH
> Haseeb
>
> For free help visit;
> http://www.excelfox.com/forum/
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post 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$$ Uniques Values

[Sundarvelan N]

Hi Friends,

It doesn't work for me. I Need to get the unique values consolidating the
two columns. Please help me.

Thanks
N.Sundarvelan
9600160150



On Thu, Aug 18, 2011 at 12:04 AM, XLS S  wrote:

> that's Great Haseeb.
>
> thnx
>
> On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
>  wrote:
> > Hi Sundarvelan,
> >
> > Since you are dealing with valid numbers use SMALL function.
> >
> > in G3 enter,
> >
> > =MIN(B:D)
> >
> > G4, copy down.
> >
> > =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"")
> >
> > HTH
> > Haseeb
> >
> > For free help visit;
> > http://www.excelfox.com/forum/
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

$$Excel-Macros$$ Uniques Values

[Sundarvelan N]

Hi Freinds,

Please help me to get the uniques values.
Thanks
N.Sundarvelan
9600160150

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

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


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

$$Excel-Macros$$ Urgent Help Graph

[Sundarvelan N]

Hi Friends,

I need one help.

I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150

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

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

$$Excel-Macros$$ How to reduce the file size

[Sundarvelan N]

How to reduce the file size

-- 
Thanks
N.Sundarvelan
9600160150

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

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

$$Excel-Macros$$ Excel Interview Question - Help

[Sundarvelan N]

Hello Friends,

Tomorrow i'm going to attend the Excel handling job intervew. I have been
informed  that this is going to happen over phone interview also it will be
a technical round.

Friends could any body shoot the questions which can shoot me tomorrow.

Thanks in Advance!!!

-- 
Thanks
N.Sundarvelan
9600160150

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

[Sundarvelan N]

Check if mine is ok for you

Thanks,
Sundarvelan,
9600160150

On Mon, Feb 14, 2011 at 8:08 PM, ashish koul  wrote:

> see if it helps
>
>
> On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi  wrote:
>
>> attached herewith rashi querry sheet. Please provide me formula and help.
>>
>> --
>> 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
>



-- 
Thanks
N.Sundarvelan
9600160150

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

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


Xl002.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Unique numbers using Macro OR Foumula

[Sundarvelan N]

Thanks Ashish but blank cell is coming in the middle of the column.

On Tue, Jan 11, 2011 at 10:57 AM, ashish koul  wrote:

> check the attachment see if it helps
>
>
> On Tue, Jan 11, 2011 at 12:19 AM, Sundarvelan N wrote:
>
>> Hello Friends,
>>
>> Can anybody help me to achieve my task.
>>
>> In the attached file i need to get the unique numbers using formula or
>> MACRO.
>>
>> When numbers entered in the left table i need to get the unique numbers in
>> the unique column. Please help me friends
>>
>> --
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
>


-- 
Thanks
N.Sundarvelan
9600160150

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post 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-macros : Get Agents Name under Team Leader

[Sundarvelan N]

Hi Rohan,

Thanks for your reply, but i dont want to edit my original excel file. I
need to get the agents name under corresponding TL names like wise TL names
under manager name.

Thanks,
Sundarvelan
9600160150

On Fri, Dec 24, 2010 at 3:43 PM, Rohan Young  wrote:

> Hi,
>
> Please find the solved attached file as required by you
>
> for any clarification feel free to contact
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Thu, Dec 23, 2010 at 3:42 PM, Sundarvelan N  wrote:
>
>> Hi Group,
>>
>> I need macro int this scenario.
>>
>> Please help in this scenario. I need to get Agents names under respective
>> Teamleaders name. likewise i need to team leaders name under each respective
>> Managers name.
>>
>> --
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To 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
>



-- 
Thanks
N.Sundarvelan
9600160150

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To 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 protect a cell based value in other cell

[Sundarvelan N]

I need to protect cell # B1 and cel # C1

if we enter NO in  cell # A1

please help me

-- 
Thanks
N.Sundarvelan
9600160150

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

[Sundarvelan N]

Hi Firiends,

I need to reduce the Excel File size, my file went beyond 30 MB. Please help
me.

-- 
Thanks
N.Sundarvelan
9600160150

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

[Sundarvelan N]

Hi Abhishek,

Please help to proceed with ur idea.

Thanks,
Sundarvelan

On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain wrote:

> Dear Sundar,
>
> There are two things -
>
> First -
>
> If you want to put all unique values (the existing ones and the newly
> added) in those 3 columns and are ready to hit Update button every time then
> add the following two lines in the beginning of your code -
>
> *Range("N5:P65000").Select
> Selection.ClearContents
> *
> This will clear the existing records in those 3 columns and allow your code
> to put new unique values. Remember - *You have to press the Update button
> each time* you wish to reflect the most updated data.
>
>
> Second -
>
> If you want to put existing unique values in those 3 columns only once and
> then get the new ones updated automatically, i.e., *without pressing the
> Update button* then, this is something entirely different. You can do this
> too but you have to use an add-in for that. If this is what you want, let me
> know, I'll guide you through the process.
>
>
>
> Cheers!
>
> AJ
>
>
> On 8/6/10, Sundarvelan N  wrote:
>>
>> Hello Friends,
>>
>>
>> Please help me to finish my assignment.
>>
>>
>> I have attached a excel file, in that i need unique team leaders name from
>> E column and updated in the N column, Like wise Managers,  Departments.
>>
>>
>> I Need VBA Code that automatically updates if any new entries in the E
>> column it must update in the N column.
>>
>>
>> I have already done / tried one work it runs OK for first time. If i click
>> for second time it gives error message. It is a mix of recorded code plus
>> manual changes.
>>
>>
>> Please help me
>>
>> Thanks,
>> N.Sundarvelan
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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
>>
>>
>


-- 
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel Macro Help : Ambiguous name detected :

[Sundarvelan N]

Hi Friends,

Please help me to solve the below issue.

While i try to use the below code it says "Ambiguous name detected :W028M"

Private Sub CommandButton1_Click()
Dim fn As String
fn = Trim(TextBox1.Text)
If fn = "W001M" Then
Call W001M
TextBox1.Text = ""
ElseIf fn = "W002BW" Then
Call W002BW
TextBox1.Text = ""
ElseIf fn = "W003BW" Then
Call W003BW
TextBox1.Text = ""
ElseIf fn = "W004W" Then
Call W004W
TextBox1.Text = ""
ElseIf fn = "W005M" Then
Call W005M
TextBox1.Text = ""
ElseIf fn = "W006BW" Then
Call W006BW
TextBox1.Text = ""
ElseIf fn = "W007BW" Then
Call W007BW
TextBox1.Text = ""
ElseIf fn = "W008BW" Then
Call W008BW
TextBox1.Text = ""
ElseIf fn = "W009W" Then
Call W009W
TextBox1.Text = ""
ElseIf fn = "W010W" Then
Call W010W
TextBox1.Text = ""
ElseIf fn = "W011W" Then
Call W011W
TextBox1.Text = ""
ElseIf fn = "W012W" Then
Call W012W
TextBox1.Text = ""
ElseIf fn = "W013M" Then
Call W013M
TextBox1.Text = ""
ElseIf fn = "W014BW" Then
Call W014BW
TextBox1.Text = ""
ElseIf fn = "W015M" Then
Call W015M
TextBox1.Text = ""
ElseIf fn = "W016W" Then
Call W016W
TextBox1.Text = ""
ElseIf fn = "W017W" Then
Call W017W
TextBox1.Text = ""
ElseIf fn = "W018W" Then
Call W018W
TextBox1.Text = ""
ElseIf fn = "W019W" Then
Call W019W
TextBox1.Text = ""
ElseIf fn = "W020W" Then
Call W020W
TextBox1.Text = ""
ElseIf fn = "W021W" Then
Call W021W
TextBox1.Text = ""
ElseIf fn = "W023M" Then
Call W023M
TextBox1.Text = ""
ElseIf fn = "W024M" Then
Call W024M
TextBox1.Text = ""
ElseIf fn = "W025M" Then
Call W025M
TextBox1.Text = ""
ElseIf fn = "W026M" Then
Call W026M
TextBox1.Text = ""
ElseIf fn = "W027M" Then
Call W027M
TextBox1.Text = ""
ElseIf fn = "W028M" Then
Call W028M
TextBox1.Text = ""
ElseIf fn = "W029M" Then
Call W029M
TextBox1.Text = ""
ElseIf fn = "W030M" Then
Call W030M
TextBox1.Text = ""
ElseIf fn = "W032W" Then
Call W032W
TextBox1.Text = ""
ElseIf fn = "W033W" Then
Call W033W
TextBox1.Text = ""
ElseIf fn = "W034W" Then
Call W034W
TextBox1.Text = ""
ElseIf fn = "W035W" Then
Call W035W
TextBox1.Text = ""
ElseIf fn = "W036W" Then
Call W036W
TextBox1.Text = ""
ElseIf fn = "W037D" Then
Call W037D
TextBox1.Text = ""
ElseIf fn = "W038W" Then
Call W038W
TextBox1.Text = ""
ElseIf fn = "W039D" Then
Call W039D
TextBox1.Text = ""
ElseIf fn = "W040W" Then
Call W040W
TextBox1.Text = ""
ElseIf fn = "W041W" Then
Call W041W
TextBox1.Text = ""
ElseIf fn = "W042W" Then
Call W042W
TextBox1.Text = ""
ElseIf fn = "W043W" Then
Call W043W
TextBox1.Text = ""
ElseIf fn = "" Then
MsgBox "Please Enter The Report Number", vbOKOnly
Else
MsgBox "Please Enter The Correct Report Number", vbOKOnly
TextBox1.Text = ""
End If
End Sub


 Please help me

Thanks,
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel macro Help : Date of Previous day

[Sundarvelan N]

Hi Friends,

Please give the VBA code to find the date of previous day (yesterday).

Thanks,
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel help : Remove Page Breaks Using VBA code

[Sundarvelan N]

Hi Siti,

Thanks for your reply,

But the below said is not working

Below is the recorded code for removing pagebreaks

ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1

is any other code to remove page breaks

*I need to set the Page break to end of the used last column.*
**
*Please help me*

Thanks,
Sundarvelan

On Thu, May 13, 2010 at 6:56 AM, siti Vi  wrote:

> I think, removing VPageBreaks and HPageBreaks can be done
> by setting  FitToPage /Wide/Tall properties to : 1
>
> Sub ClearPgBreasks()
>   With ActiveSheet.PageSetup
>  .Zoom = False
>  .FitToPagesWide = 1
>  .FitToPagesTall = 1
>   End With
> End Sub
>
>
> On May 12, 8:33 pm, Sundarvelan N  wrote:
> > Hello Friends,
> > Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.
> > Thanks,
> > N.Sundarvelan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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
>



-- 
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel help : Remove Page Breaks Using VBA code

[Sundarvelan N]

Hello Friends,

Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.

Thanks,
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ VBA DATE

[Sundarvelan N]

Hello Friends,

I need to do this using VBA Coding. Please help me

Thanks,
Sundarvelan

On Sun, May 9, 2010 at 8:38 PM, deepak kumar wrote:

> Hi Sundar,
>
> You can do it with conditional formatting, I've attached a work to show you
> how to do it, you just need to check the formula in conditional formatting
> option.
>
> Thanks
>
> On Fri, May 7, 2010 at 5:02 AM, Sundarvelan N  wrote:
>
>> Hi Friends,
>>
>> Can any one help me to solve the below condition
>>
>> *"HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW"
>> *
>>
>> Thanks,
>> N.Sundarvelan
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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
>



-- 
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ VBA DATE

[Sundarvelan N]

Hi Friends,

Can any one help me to solve the below condition

*"HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW"*

Thanks,
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ VBA code to delete all dates before last week

[Sundarvelan N]

Hi Siti,

Thank you very much

Thanks,
Sundarvelan

On Fri, May 7, 2010 at 1:44 PM, siti Vi  wrote:

> Assuming that :
> * YOUR LIST OF DATE are in a Range
> * "to delete" means to clear the content of a cell containing Date
> data
>
> Sub DoSomething()
>   Dim MyRange as Range, Xel As Range
>   Dim LastWeekWednesday As Date
>
>  '--Please edit the code for your Range
>   Set MyRange = Sheets("Bla").Range("A2:A65533")
>   LastWeekWednesday = Date - Weekday(Date) - 3
>
>   For Each Xel In MyRange
>  If Xel.Value < LastWeekWednesday Then Xel.ClearContents
>   Next
>
> End Sub
>
>
>
> On May 6, 8:08 pm, Sundarvelan N  wrote:
> > Hi Friends,
> > Please help me to delete the date which are older than last week
> wednesday.
> > Also i need a code to remove page breaks except the below recoded code
> > ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
> > Thanks
> > N.Sundarvelan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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
>



-- 
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ VBA code to delete all dates before last week

[Sundarvelan N]

Hi Friends,

Please help me to delete the date which are older than last week wednesday.
Also i need a code to remove page breaks except the below recoded code

ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1



Thanks
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel Macro help : How to remove Page Break

[Sundarvelan N]

Hi friends,

Please help.

How to automatically set the range to clear the pagebreaks in different
data.

Thanks,
Sundarvelan

On Wed, May 5, 2010 at 5:42 AM, siti Vi  wrote:

> try:
>
> Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone
>
>
> --
>  On May 4, 6:09 pm, Sundarvelan N  wrote:
> > Hi Friends,
> > Please help me to solve the final step of my project.
> > I need to remove the page break lines to the end of the column upto which
> > the data is available.
> > Thanks,
> > N.Sundarvelan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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
>



-- 
N.Sundarvelan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.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$$ Excel Macro help : How to remove Page Break

[Sundarvelan N]

Hi Friends,

Please help me to solve the final step of my project.

I need to remove the page break lines to the end of the column upto which
the data is available.

Thanks,
N.Sundarvelan

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