Re: $$Excel-Macros$$ Re: Sumif not working

[Prince]

Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same thing. And 
thanks alot for your kind information :)

Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner wrote:
>
> @Prince,
>
> Why not just added another "m" in your text function 
> *TEXT(C16:C35,"mmm")*which will avoid unnecessary MID Function.  One more 
> thing I don't think 
> you need any case sensitivity function here (Proper in your formula).
>
> (TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
>
> TEXT(C16:C35,"mmm") = This one is text output 
> MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???
>
> Does it make any sense?
>
> On Wed, Dec 26, 2012 at 12:22 PM, Prince 
> > wrote:
>
>> Hi Rajesh,
>>
>> It may help you,.
>>
>> =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>>
>> Regards
>> Prince 
>>
>>
>> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote:
>>>
>>> Hi Experts, 
>>>
>>> In the attachment file the sumif formula is not working I don't know 
>>> why.kindly point the mistakes in it. 
>>>
>>> Regards 
>>>
>>> Rajesh 
>>>
>>  -- 
>> 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-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@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.

Re: $$Excel-Macros$$ Sumif not working

[kasper]

Hi 

Thank you for the formula ,it is working well,

Rajesh

On Wednesday, December 26, 2012 11:24:08 AM UTC+5:30, Ms-Exl-Learner wrote:
>
>  *In C16** cell*
> =IF(ISNUMBER(B16),TEXT(B16,""),"")
> *Drag it down.*
>
> *In D2 cell*
> =SUMIF($C$16:$C$380,$B2,(D$16:D$380))
> *Drag it to right...*
>
> On 26-12-2012 11:24 AM, Rajesh thrissur wrote:
>  
> Hi Experts,
>
> In the attachment file the sumif formula is not working I don't know
> why.kindly point the mistakes in it.
>
> Regards
>
> Rajesh
>
>
>  
>  

-- 
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$$ Re: Sumif not working

[kasper]

Hi Lalit

Thak you for the formula.

Rajesh

On Wednesday, December 26, 2012 11:49:40 AM UTC+5:30, Lalit Mohan Pandey 
wrote:
>
> Hi Rajesh,
>
> Apply below formula instead of yours with Ctrl + Shift + Enter
>
> =SUM((MONTH($C$16:$C$380)=MONTH($B2&1))*(D$16:D$380))
>
> and the mistake is the matching range is in date format and the criteria 
> is in Text format.
>
> Regards,
> Lalit Mohan
> +919711867226
>
>
> On Wednesday, 26 December 2012 11:24:19 UTC+5:30, kasper wrote:
>>
>> Hi Experts, 
>>
>> In the attachment file the sumif formula is not working I don't know 
>> why.kindly point the mistakes in it. 
>>
>> Regards 
>>
>> Rajesh 
>>
>

-- 
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$$ Re: Sumif not working

[kasper]

HI Prince

Thanks for the formula

Rajesh

On Wednesday, December 26, 2012 12:22:05 PM UTC+5:30, Prince wrote:
>
> Hi Rajesh,
>
> It may help you,.
>
> =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>
> Regards
> Prince 
>
> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote:
>>
>> Hi Experts, 
>>
>> In the attachment file the sumif formula is not working I don't know 
>> why.kindly point the mistakes in it. 
>>
>> Regards 
>>
>> Rajesh 
>>
>

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

Re: $$Excel-Macros$$ Re: Sumif not working

[Ms-Exl-Learner]

@Prince,

I am not talking about the ways or methods of getting the result, which 
I never did, since that is the speciality of excel we can get the same 
result in many ways.


But the previous post is not related to the method or ways of pulling 
the data, It's about the *errors and wrong usage***of functions.  
Whenever I see any formula with error I just point out, so that you will 
be aware of the drawbacks which will help you when building formula's in 
future.



On 26-12-2012 1:38 PM, Prince wrote:

Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same thing. 
And thanks alot for your kind information :)


Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner 
wrote:


@Prince,

Why not just added another "m" in your text function
*TEXT(C16:C35,"mmm")* which will avoid unnecessary MID Function. 
One more thing I don't think you need any case sensitivity

function here (Proper in your formula).

(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)

TEXT(C16:C35,"mmm") = This one is text output
MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???

Does it make any sense?

On Wed, Dec 26, 2012 at 12:22 PM, Prince > wrote:

Hi Rajesh,

It may help you,.

=SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
with cse

Regards
Prince


On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper
wrote:

Hi Experts,

In the attachment file the sumif formula is not working I
don't know
why.kindly point the mistakes in it.

Regards

Rajesh

-- 
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-...@googlegroups.com .
To unsubscribe from this group, send email to
excel-macros...@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 unsubs

Re: $$Excel-Macros$$ Re: Sumif not working

[Prince]

Yes Dear Ms-Exl-Learner,

I also belive in correcting the things so that anything we do should be 
perfect and smooth. It is best form me that guys like you are always there 
who can ping me whenever i do any thing wrong .

Thanks again for correcting me.

:)

Regards
Prince

On Wednesday, December 26, 2012 2:06:31 PM UTC+5:30, Ms-Exl-Learner wrote:
>
>  @Prince,
>
> I am not talking about the ways or methods of getting the result, which I 
> never did, since that is the speciality of excel we can get the same result 
> in many ways.  
>
> But the previous post is not related to the method or ways of pulling the 
> data, It's about the *errors and wrong usage** *of functions.  Whenever I 
> see any formula with error I just point out, so that you will be aware of 
> the drawbacks which will help you when building formula's in future.
>
>
> On 26-12-2012 1:38 PM, Prince wrote:
>  
> Hi Ms-Exl-Learner, 
>
>  Yes dear,  you are right. There are so many ways to do the same thing. 
> And thanks alot for your kind information :)
>
>  Regards
> Prince
>
> On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner 
> wrote: 
>>
>> @Prince,
>>
>> Why not just added another "m" in your text function *TEXT(C16:C35,"mmm")
>> * which will avoid unnecessary MID Function.  One more thing I don't 
>> think you need any case sensitivity function here (Proper in your formula).
>>
>> (TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
>>
>> TEXT(C16:C35,"mmm") = This one is text output 
>> MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???
>>
>> Does it make any sense?
>>
>> On Wed, Dec 26, 2012 at 12:22 PM, Prince  wrote:
>>
>>> Hi Rajesh, 
>>>
>>>  It may help you,.
>>>
>>>  =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>>>
>>>  Regards
>>> Prince  
>>>
>>>
>>> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote: 

 Hi Experts, 

 In the attachment file the sumif formula is not working I don't know 
 why.kindly point the mistakes in it. 

 Regards 

 Rajesh 

>>>   -- 
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@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-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@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 owner

Re: $$Excel-Macros$$ Re: Sumif not working

[Ms-Exl-Learner]

@Prince,

Thanks for the understanding :)


On 26-12-2012 2:27 PM, Prince wrote:

Yes Dear Ms-Exl-Learner,

I also belive in correcting the things so that anything we do should 
be perfect and smooth. It is best form me that guys like you are 
always there who can ping me whenever i do any thing wrong .


Thanks again for correcting me.

:)

Regards
Prince

On Wednesday, December 26, 2012 2:06:31 PM UTC+5:30, Ms-Exl-Learner 
wrote:


@Prince,

I am not talking about the ways or methods of getting the result,
which I never did, since that is the speciality of excel we can
get the same result in many ways.

But the previous post is not related to the method or ways of
pulling the data, It's about the *errors and wrong usage***of
functions.  Whenever I see any formula with error I just point
out, so that you will be aware of the drawbacks which will help
you when building formula's in future.


On 26-12-2012 1:38 PM, Prince wrote:

Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same
thing. And thanks alot for your kind information :)

Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30,
Ms-Exl-Learner wrote:

@Prince,

Why not just added another "m" in your text function
*TEXT(C16:C35,"mmm")* which will avoid unnecessary MID
Function.  One more thing I don't think you need any case
sensitivity function here (Proper in your formula).

(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)

TEXT(C16:C35,"mmm") = This one is text output
MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???

Does it make any sense?

On Wed, Dec 26, 2012 at 12:22 PM, Prince
 wrote:

Hi Rajesh,

It may help you,.

=SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
with cse

Regards
Prince


On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30,
kasper wrote:

Hi Experts,

In the attachment file the sumif formula is not
working I don't know
why.kindly point the mistakes in it.

Regards

Rajesh

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




--
Jo

Fwd: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

[Pravin Gunjal]

Thanks a lot!

-- Forwarded message --
From: Prince 
Date: Sun, Dec 23, 2012 at 11:37 AM
Subject: $$Excel-Macros$$ Re: Combine all sheets in a single sheet
To: excel-macros@googlegroups.com


Hi Pravin,

PFA

Regards
Prince

On Thursday, December 20, 2012 12:39:35 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi Friends,
>
> I have an excel file containing almost 50 sheets in it and would like to
> gather all those data in a single sheet one after one (column headings may
> be different)
>
> Is there any way/VB code which can do it faster.  Thank you,
>
> Regards
> Pravin Gunjal.
>
>  --
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.




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

RE: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

[Amit Desai (MERU)]

Dear Prince,

Please explain how to use this.. also do you have a solution for how to split a 
sheet in different sheets based on a column.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Prince
Sent: 23 December 2012 11:38
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

Hi Pravin,

PFA

Regards
Prince

On Thursday, December 20, 2012 12:39:35 PM UTC+5:30, Pravin Gunjal wrote:
Hi Friends,

I have an excel file containing almost 50 sheets in it and would like to gather 
all those data in a single sheet one after one (column headings may be 
different)

Is there any way/VB code which can do it faster.  Thank you,

Regards
Pravin Gunjal.

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

Re: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

[Prince]

Most welcome :)

Regards
Prince

On Wednesday, December 26, 2012 3:31:44 PM UTC+5:30, Pravin Gunjal wrote:
>
> Thanks a lot!
>
> -- Forwarded message --
> From: Prince >
> Date: Sun, Dec 23, 2012 at 11:37 AM
> Subject: $$Excel-Macros$$ Re: Combine all sheets in a single sheet
> To: excel-...@googlegroups.com 
>
>
> Hi Pravin,
>
> PFA
>
> Regards
> Prince
>
> On Thursday, December 20, 2012 12:39:35 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Hi Friends,
>>
>> I have an excel file containing almost 50 sheets in it and would like to 
>> gather all those data in a single sheet one after one (column headings may 
>> be different)
>>
>> Is there any way/VB code which can do it faster.  Thank you,
>>
>> Regards
>> Pravin Gunjal.
>>
>>  -- 
> 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-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@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.

Re: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

[Prince]

Hi Amit,

you can add as many as sheet you required. and run this tool it will create 
a sheet name "combineddata"  and paste the data from all sheet into 
"combineddata" sheet.

For your second Question: yes i have the solutionof splitting the data of 
sheet into multiple sheet based on the columns.

Regards
Prince


On Wednesday, December 26, 2012 3:37:11 PM UTC+5:30, Amit Desai (MERU) 
wrote:
>
>  Dear Prince,
>
> Please explain how to use this.. also do you have a solution for how to 
> split a sheet in different sheets based on a column.
>
> Best Regards,
>
> Amit
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Prince
> *Sent:* 23 December 2012 11:38
> *To:* excel-...@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Re: Combine all sheets in a single sheet
>  
>  
>
> Hi Pravin,
>  
>  
>  
> PFA
>  
>  
>  
> Regards
>  
> Prince
>
> On Thursday, December 20, 2012 12:39:35 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi Friends,
>  
>  
>   
> I have an excel file containing almost 50 sheets in it and would like to 
> gather all those data in a single sheet one after one (column headings may 
> be different)
>  
>  
>  
> Is there any way/VB code which can do it faster.  Thank you,
>  
>  
>  
> Regards
>  
> Pravin Gunjal.
>  
>  
>   
> -- 
> 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...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macro...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>  
>  
>  
> --
> Disclaimer: This message and its attachments contain confidential 
> information and may also contain legally privileged information. This 
> message is intended solely for the named addressee. If you are not the 
> addressee indicated in this message (or authorized to receive for 
> addressee), you may not copy or deliver any part of this message or its 
> attachments to anyone or use any part of this message or its attachments. 
> Rather, you should permanently delete this message and its attachments (and 
> all copies) from your system and kindly notify the sender by reply e-mail. 
> Any content of this message and its attachments that does not relate to the 
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have 
> been sent or endorsed by any of them. Email communications are not private 
> and no warranty is made that e-mail communications are timely, secure or 
> free from computer virus or other defect.
>  

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

Re: $$Excel-Macros$$ Re: Merry Christmas & Happy New Year *

[respuzy]

FORUM RULES

2) Don't post a question in the thread of another member
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: rohit tharwani 
Sender: excel-macros@googlegroups.com
Date: Wed, 26 Dec 2012 15:52:18 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Merry Christmas & Happy New Year *

This message is eligible for Automatic Cleanup! (tharwani.ro...@gmail.com) 
Add cleanup rule: 
https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DUZ3PFWTLuUjmJQWr7tJnyYq953SCC%252B1qkPScBs75cj9EnR6hmoOF6Aj%252Fy8xCgCPYxd2IuJoWO6Ys6tFEU1HdMNv%252Ba93tsEP1OCp%252BwNQMYPHuCVf%252B4lFX00yu9CBxs%252Fa1gmiQNrjbA17knzH45vPCzw%253D%253D%26key%3D0xqOBXB3cE14jtAmSjo9apUIFIEK02X37RSTW1Vgizs%253D&tc=13210565079_1043226684
More info: 
http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13210565079_1043226684

-- 
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$$ Need sumif formula with 2 conditions

[Rajesh thrissur]

Hi experts,

Please check the attached file.In it the first table contains daily
purchase data, I want to get a summery report of the same in the second
table format, How can use a formula with two criteria .


Regards

Rajesh

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




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

$$Excel-Macros$$ 2013 Excel Developer conference London January 2013

[yogananda muthaiah]

Dear Guys,


Any thoughts suggestions or observations can comment on below web link

Site :
http://smurfonspreadsheets.wordpress.com/2012/11/12/2013-excel-developer-conference-london-january-2013/#comments



Regards
Yogananda Muthaiah
Ph : 973 123 7267

-- 
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$$ Re: Need sumif formula with 2 conditions

[Prince]

Hi Rajesh,

There is no data in the sheet.
:(

regards
Prince

On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wrote:
>
> Hi experts,
>
> Please check the attached file.In it the first table contains daily 
> purchase data, I want to get a summery report of the same in the second 
> table format, How can use a formula with two criteria .
>
>
> Regards
>
> Rajesh
>

-- 
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$$ Re: Mail merge and E mail : Reminder email to customers using VBA

[bpascal123]

Hi,

Happy new year and all... About your query it seems you have 2 queries, one 
related to mail merge (paper) and one to email. I have been working on 
these for my own needs, with more or less access to the content...

For mail merge using email, it seems there are many resources available 
online to automate emails from Excel to Outlook with customs email 
addresses, subject, body and so on

For mail merge using paper (for faxing or post mailing), most available 
infos is about Word and its mail merge tool. For that, at this time, I have 
just managed to make the data "fit" the mail merge tools, like

 *Customer#*
 
*Customer_name*
 
*invoiceNum_1*
 
*invoiceDate_1*
 
*invoiceDueDate_1*
 
*InvoiceDueAmt_1*
 
*invoiceNum_2*
 
*invoiceDate_2*
 
*invoiceDueDate_2*
 
*InvoiceDueAmt_2*
 
*…*
 
*invoiceItem_8*
 
*address*
 
*email*
 
*Total Dues*
  
12345
 
The fancy paint shop
 
AX4562
 
2012-01-10
 
30/11/2012
 
11289.6
 
AX4653
 
2012-02-10
 
30/11/2012
 
45678.45
 
 
 
 
 
PO Box 322,Madras
 
fancy_pa...@hotmail.com
 
68203.83
 

For one customer, using Word Mail Merge, the data for one customer must be 
like above... Your data is also a bit difficult to deal with, to implement 
it there might be changes in the account info sheet as invoice AX4653 comes 
with multiple invoice date, due date and amount due. Maybe it's a typo 
because for one invoice, there should only be be one invoice date... unless 
you have specific requirements...

Once your data is laid like that you can start the mail merge from Word. 
The header fields as shown above should help Word match its mail merge 
fields as there may be some confusion using an incremental number 
invoiceNum_1, invoiceDate_2... in relation to the column position of each 
field...

My issue using mail merge comes when invoice information are displayed in a 
table or in a tabular way following your letter layout. There Word mail 
merge decides of the number of rows in the table from the customer that has 
the maximum number of due invoices. Everyone else will have a table size of 
this customer. I'm not an expert of Mail Merge but maybe there is an option 
somewhere that makes Word adjusts the number of rows in the mail merge tool 
accordingly to the number of real invoices for one customer, in your data, 
it seem there is the same number of invoice for each customer ... if one 
day a customer has ten invoices, there will be 10 rows on every table... At 
this stage, I have deleted manually all empty rows while checking every 
letters... If the number of letters is significative, this might be 
difficult...

Is anyone aware of something to do to "fix" this? I would think of a macro 
that would loop through every table and delete empty rows once the mail 
merge is complete. Else, coding with vba the Word mail merge instead of 
doing it manually from the tool bar might allow more flexibility... Can 
someone advise?

Using Word mail merge is the fastest possible option. Else copy paste 
tables from Excel would require a significative amount of time and cpu 
activity. But it's then easy to copy only the needed number of rows. One 
last thing is that tables are of Excel range objects... instead of html or 
xml (loss of word document style). Excel range object in Word also make 
files heavier.

If you could follow me until here, I can help you to the point where I am 
now... presenting the data for Word mail merge tool.

Using emails, things are a little different since most actions can be 
automated from within Excel to Outlook or most email clients. For this, I'm 
also facing an issue... is it possible to code an email html table from 
Excel using vba rather than pasting an Excel object range? I spent some 
time looking for anything related to this on web sites without any success. 
It seems this is possible doing so from Excel to Word as there is a 
specific table object/method available from referencing Word object 
collections in Excel. Is there anything similar with email, Outlook?

Thanks
Pascal



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

$$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

[bpascal123]

Hi,

Happy new year and all... About your query it seems you have 2 queries, one 
related to mail merge (paper) and one to email. I have been working on 
these for my own needs, with more or less access to the content...

For mail merge using email, it seems there are many resources available 
online to automate emails from Excel to Outlook with customs email 
addresses, subject, body and so on

For mail merge using paper (for faxing or post mailing), most available 
infos is about Word and its mail merge tool. For that, at this time, I have 
just managed to make the data "fit" the mail merge tools, like

*Customer#*

*Customer_name*

*invoiceNum_1*

*invoiceDate_1*

*invoiceDueDate_1*

*InvoiceDueAmt_1*

*invoiceNum_2*

*invoiceDate_2*

*invoiceDueDate_2*

*InvoiceDueAmt_2*

*…*

*invoiceItem_8*

*address*

*email*

*Total Dues*

12345

The fancy paint shop

AX4562

2012-01-10

30/11/2012

11289.6

AX4653

2012-02-10

30/11/2012

45678.45

 

 

PO Box 322,Madras

fancy_pa...@hotmail.com

68203.83


For one customer, using Word Mail Merge, the data for one customer must be 
like above... Your data is also a bit difficult to deal with, to implement 
it there might be changes in the account info sheet as invoice AX4653 comes 
with multiple invoice date, due date and amount due. Maybe it's a typo 
because for one invoice, there should only be be one invoice date... unless 
you have specific requirements...

Once your data is laid like that you can start the mail merge from Word. 
The header fields as shown above should help Word match its mail merge 
fields as there may be some confusion using an incremental number 
invoiceNum_1, invoiceDate_2... in relation to the column position of each 
field...

My issue using mail merge comes when invoice information are displayed in a 
table or in a tabular way following your letter layout. There Word mail 
merge decides of the number of rows in the table from the customer that has 
the maximum number of due invoices. Everyone else will have a table size of 
this customer. I'm not an expert of Mail Merge but maybe there is an option 
somewhere that makes Word adjusts the number of rows in the mail merge tool 
accordingly to the number of real invoices for one customer, in your data, 
it seem there is the same number of invoice for each customer ... if one 
day a customer has ten invoices, there will be 10 rows on every table... At 
this stage, I have deleted manually all empty rows while checking every 
letters... If the number of letters is significative, this might be 
difficult...

Is anyone aware of something to do to "fix" this? I would think of a macro 
that would loop through every table and delete empty rows once the mail 
merge is complete. Else, coding with vba the Word mail merge instead of 
doing it manually from the tool bar might allow more flexibility... Can 
someone advise?

Using Word mail merge is the fastest possible option. Else copy paste 
tables from Excel would require a significative amount of time and cpu 
activity. But it's then easy to copy only the needed number of rows. One 
last thing is that tables are of Excel range objects... instead of html or 
xml (loss of word document style). Excel range object in Word also make 
files heavier.

If you could follow me until here, I can help you to the point where I am 
now... presenting the data for Word mail merge tool.

Using emails, things are a little different since most actions can be 
automated from within Excel to Outlook or most email clients. For this, I'm 
also facing an issue... is it possible to code an email html table from 
Excel using vba rather than pasting an Excel object range? I spent some 
time looking for anything related to this on web sites without any success. 
It seems this is possible doing so from Excel to Word as there is a 
specific table object/method available from referencing Word object 
collections in Excel. Is there anything similar with email, Outlook?

Thanks
Pascal

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

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

[bpascal123]

change the yellow line to

Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")*

or add a reference to Microsoft Outlook 9.0 Object Library from Tools - 
Reference

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

Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *

[Lalit Mohan Pandey]

@ amar

Nice work with more features. Thanks for sharing this to us.

Regards,
Lalit Mohan
+919711867226

On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi Guys
>
> check out this  you may get some more ideas to think in different
>
> On Sat, Dec 22, 2012 at 4:38 PM, amar takale 
> > wrote:
>
>> ok,that fine no problem.
>>
>>
>> On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey 
>> 
>> > wrote:
>>
>>> Hi Amar, 
>>>
>>> I created this file just for the way hilary wants. Now the 
>>> specifications are changing and for that matter it is not that much dynamic.
>>>
>>> Regards,
>>> Lalit Mohan 
>>>
>>>
>>> On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote:
>>>
 Dear Lalit,

 but anyone can see Authorized user name.if anyone got it at least one 
 authorized user name he can see also other user name.I want to hide Other 
 user name or hide user Sheet if possible.

 Regards
 Amar

  On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey <
 mohan.p...@gmail.com> wrote:

> Hi Pravin, 
>
> You can also change the user access. Just login with Lalit Mohan and 
> add user in Authorized_User sheet.
> Hope it will helps you.
>
> Regards,
> Lalit Mohan 
>
>
> On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote:
>
>> Hi Lalit, 
>>
>> Can we give different passwords to access this file to authorised 
>> users..
>>
>> Regards
>> Pravin Gunjal.
>>
>>  -- Forwarded message --
>> From: Lalit Mohan Pandey 
>> Date: Fri, Dec 21, 2012 at 7:26 PM
>> Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users 
>> * * *
>>  To: excel-...@googlegroups.com
>> Cc: res...@gmail.com
>>
>>
>>
>> Hi Hilary,
>>
>> Please find the revised version of the file.
>> User name is the same as before.
>> Let me know if it meets your expectation.
>>
>> Regards,
>> Lalit Mohan
>>
>> On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: 
>>>
>>> Hi Lalit
>>>
>>> If I don't want only the name of the user to appear once the file 
>>> opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the 
>>> user 
>>> name and time appears on the file name. The time Ȋ̝̊̅§ cool but then 
>>> every 
>>> person can see the user name and could log in with that user name so I 
>>> wish 
>>> only the name shd not appear as part of the file name. Thanks 
>>> Sent from my BlackBerry® smartphone from Airtel Ghana
>>> --
>>> *From: *Lalit Mohan Pandey  
>>> *Sender: *excel-...@googlegroups.com 
>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST)
>>> *To: *
>>> *ReplyTo: *excel-...@googlegroups.com 
>>> *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised 
>>> users * * *
>>>
>>> [image: Boxbe]  This message is 
>>> eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup 
>>> rule|
>>>  More 
>>> info
>>>  
>>>
>> -- 
>> Join official Facebook page of this forum @ https://www.facebook.com/
>> **discu**ssexcel 
>>  
>> 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-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.**com. 
>>
>> Visit this group at http://groups.google.com/**group**
>> /excel-macros?hl=en
>> .
>>  
>>  
>>
>

Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *

[Lalit Mohan Pandey]

Hi amar

Nice work . Thanks for sharing.

Regards,
Lalit Mohan
+919711867226

On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi Guys
>
> check out this  you may get some more ideas to think in different
>
> On Sat, Dec 22, 2012 at 4:38 PM, amar takale 
> > wrote:
>
>> ok,that fine no problem.
>>
>>
>> On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey 
>> 
>> > wrote:
>>
>>> Hi Amar, 
>>>
>>> I created this file just for the way hilary wants. Now the 
>>> specifications are changing and for that matter it is not that much dynamic.
>>>
>>> Regards,
>>> Lalit Mohan 
>>>
>>>
>>> On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote:
>>>
 Dear Lalit,

 but anyone can see Authorized user name.if anyone got it at least one 
 authorized user name he can see also other user name.I want to hide Other 
 user name or hide user Sheet if possible.

 Regards
 Amar

  On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey <
 mohan.p...@gmail.com> wrote:

> Hi Pravin, 
>
> You can also change the user access. Just login with Lalit Mohan and 
> add user in Authorized_User sheet.
> Hope it will helps you.
>
> Regards,
> Lalit Mohan 
>
>
> On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote:
>
>> Hi Lalit, 
>>
>> Can we give different passwords to access this file to authorised 
>> users..
>>
>> Regards
>> Pravin Gunjal.
>>
>>  -- Forwarded message --
>> From: Lalit Mohan Pandey 
>> Date: Fri, Dec 21, 2012 at 7:26 PM
>> Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users 
>> * * *
>>  To: excel-...@googlegroups.com
>> Cc: res...@gmail.com
>>
>>
>>
>> Hi Hilary,
>>
>> Please find the revised version of the file.
>> User name is the same as before.
>> Let me know if it meets your expectation.
>>
>> Regards,
>> Lalit Mohan
>>
>> On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: 
>>>
>>> Hi Lalit
>>>
>>> If I don't want only the name of the user to appear once the file 
>>> opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the 
>>> user 
>>> name and time appears on the file name. The time Ȋ̝̊̅§ cool but then 
>>> every 
>>> person can see the user name and could log in with that user name so I 
>>> wish 
>>> only the name shd not appear as part of the file name. Thanks 
>>> Sent from my BlackBerry® smartphone from Airtel Ghana
>>> --
>>> *From: *Lalit Mohan Pandey  
>>> *Sender: *excel-...@googlegroups.com 
>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST)
>>> *To: *
>>> *ReplyTo: *excel-...@googlegroups.com 
>>> *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised 
>>> users * * *
>>>
>>> [image: Boxbe]  This message is 
>>> eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup 
>>> rule|
>>>  More 
>>> info
>>>  
>>>
>> -- 
>> Join official Facebook page of this forum @ https://www.facebook.com/
>> **discu**ssexcel 
>>  
>> 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-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.**com. 
>>
>> Visit this group at http://groups.google.com/**group**
>> /excel-macros?hl=en
>> .
>>  
>>  
>>
>>   -- 
> Join official 

$$Excel-Macros$$ Re: Combine all sheets in a single sheet

[Anand Kumar]

Dear Prince,

Could you please share code for splitting data into multiple sheets based 
on column.

Regards,
Anand Kumar

On Thursday, 20 December 2012 12:39:35 UTC+5:30, Pravin Gunjal wrote:
>
> Hi Friends,
>
> I have an excel file containing almost 50 sheets in it and would like to 
> gather all those data in a single sheet one after one (column headings may 
> be different)
>
> Is there any way/VB code which can do it faster.  Thank you,
>
> Regards
> Pravin Gunjal.
>
>

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

Re: $$Excel-Macros$$ Combine all sheets in a single sheet

[Anand Kumar]

Dear Noorain,

In your code the statement Exit Sub comes right before End Sub. It is also 
not based on any condition being tested and no Error Handling is there so 
Go To is also not being used.
Could you please explain how this code is working?

Warm Regards,
Anand Kumar

On Thursday, 20 December 2012 12:45:09 UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Pravin,
>
> Pls try, hope it will help to you.
>
> Sub collatedata()
> Dim i As Integer
> Dim j As Integer
> Dim rng As Range
> Dim sh As Worksheet
> Set sh = Sheets.Add
> sh.Move after:=Sheets(Sheets.Count)
> sh.Name = "Mastersheet"
> Sheets(1).Range("A1:C1").Copy sh.Cells(1, 1)
> i = 1
> Do While i <= Sheets.Count - 1
> j = sh.Cells(Rows.Count, "A").End(xlUp).Row + 1
> Sheets(i).Range("a2:c" & Sheets(i).Cells(Rows.Count, 
> 3).End(xlUp).Row).Copy sh.Cells(j, 1)
> i = i + 1
> Loop
> Exit Sub
> End Sub
>
>
> On Thu, Dec 20, 2012 at 12:39 PM, Pravin Gunjal 
> > wrote:
>
>> Hi Friends,
>>
>> I have an excel file containing almost 50 sheets in it and would like to 
>> gather all those data in a single sheet one after one (column headings may 
>> be different)
>>
>> Is there any way/VB code which can do it faster.  Thank you,
>>
>> Regards
>> Pravin Gunjal.
>>
>>  -- 
>> 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-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>  
>>  
>>
>
>
>
> -- 
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>  
>
>

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

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

[अनिल नारायण गवली]

Dear Rajesh ,

Pl attach the right workbook .  Your attached workboon contains no data.

Regards,
Gawli Anil

On Wed, Dec 26, 2012 at 9:17 PM, Prince  wrote:

> Hi Rajesh,
>
> There is no data in the sheet.
> :(
>
> regards
> Prince
>
> On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wrote:
>>
>> Hi experts,
>>
>> Please check the attached file.In it the first table contains daily
>> purchase data, I want to get a summery report of the same in the second
>> table format, How can use a formula with two criteria .
>>
>>
>> Regards
>>
>> Rajesh
>>
>  --
> 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.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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$$ Re: Combine all sheets in a single sheet

[Prince]

Hi Rajesh,

share ur requirement with me or any sample file.

Regards
Prince




On Thursday, December 27, 2012 9:18:38 AM UTC+5:30, Anand Kumar wrote:
>
> Dear Prince,
>
> Could you please share code for splitting data into multiple sheets based 
> on column.
>
> Regards,
> Anand Kumar
>
> On Thursday, 20 December 2012 12:39:35 UTC+5:30, Pravin Gunjal wrote:
>>
>> Hi Friends,
>>
>> I have an excel file containing almost 50 sheets in it and would like to 
>> gather all those data in a single sheet one after one (column headings may 
>> be different)
>>
>> Is there any way/VB code which can do it faster.  Thank you,
>>
>> Regards
>> Pravin Gunjal.
>>
>>

-- 
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$$ Re: If Statement help!

[Prince]

Hi SK,


Apply This. In Commission Cell 

if (volume<99,0, if( 
or(volume>=100,volume<=500),1,if(or(valume>500,Volume<=1000),1.5,"Out
 
Of Range")))

Regards
Prince
On Thursday, December 27, 2012 11:31:50 AM UTC+5:30, SK wrote:
>
>   Dear team,
>  
> I need help to build a if statement for the scenario being
>  
> if the volume is below 999,999 then the commision is zero
> if the volume is 1,00, to 5,00, then the commission is 1%
> if the vloume is between 5 ,00, to 10,00, then the comission is 
> 1.5%
>  
> Thanks for all the help in advance
>  
> Sri 
>  
>  
>  
>  
>  
>  
>   
> 
>   
>
>  
>  

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

Re: $$Excel-Macros$$ Combine all sheets in a single sheet

[NOORAIN ANSARI]

Correct Anand,

By mistake, i have left Exit sub in Code.

You can abbreviate code by using For Next loop

Sub collatedata()
Dim i%, j%
Dim rng As Range
Dim sh As Worksheet
Set sh = Sheets.Add
sh.Move after:=Sheets(Sheets.Count)
sh.Name = "Mastersheet"
Sheets(1).Range("A1:C1").Copy sh.Cells(1, 1)
For i = 1 To Sheets.Count
j = sh.Cells(Rows.Count, "A").End(xlUp).Row + 1
Sheets(i).Range("a2:c" & Sheets(i).Cells(Rows.Count, 3).End(xlUp).Row).Copy
sh.Cells(j, 1)
Next i
End Sub



On Thu, Dec 27, 2012 at 9:24 AM, Anand Kumar  wrote:

> Dear Noorain,
>
> In your code the statement Exit Sub comes right before End Sub. It is also
> not based on any condition being tested and no Error Handling is there so
> Go To is also not being used.
> Could you please explain how this code is working?
>
> Warm Regards,
> Anand Kumar
>
>
> On Thursday, 20 December 2012 12:45:09 UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Pravin,
>>
>> Pls try, hope it will help to you.
>>
>> Sub collatedata()
>> Dim i As Integer
>> Dim j As Integer
>> Dim rng As Range
>> Dim sh As Worksheet
>> Set sh = Sheets.Add
>> sh.Move after:=Sheets(Sheets.Count)
>> sh.Name = "Mastersheet"
>> Sheets(1).Range("A1:C1").Copy sh.Cells(1, 1)
>> i = 1
>> Do While i <= Sheets.Count - 1
>> j = sh.Cells(Rows.Count, "A").End(xlUp).Row + 1
>> Sheets(i).Range("a2:c" & Sheets(i).Cells(Rows.Count,
>> 3).End(xlUp).Row).Copy sh.Cells(j, 1)
>> i = i + 1
>> Loop
>> Exit Sub
>> End Sub
>>
>>
>> On Thu, Dec 20, 2012 at 12:39 PM, Pravin Gunjal  wrote:
>>
>>> Hi Friends,
>>>
>>> I have an excel file containing almost 50 sheets in it and would like
>>> to gather all those data in a single sheet one after one (column headings
>>> may be different)
>>>
>>> Is there any way/VB code which can do it faster.  Thank you,
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>>  --
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros?hl=en
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>  --
> 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.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

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

Re: $$Excel-Macros$$ Fwd: Sales File

[अनिल नारायण गवली]

use =Today() on that cell which u want to change automatically.


Regards,
Gawli Anil

On Thu, Dec 27, 2012 at 11:58 AM, rohit tharwani
wrote:

> Hie Experts  ,
> PFA of Daily Consumer daily sales & i need  urgent help from your side
> ..in report sheet i have put formulas & in PTD 15feb 2012 in this i need to
> everytime change date so the amounts changes automaticaly is there any way
> so without changing date i can get the answer aur any suitable thing which
> i can do & YTD 2012 ...kindly check revert me back ..
>
>  --
> 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.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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$$ Re: Sales File

[Prince]

Hi Rohit,

I hope this may help you, Otherwise let me know.

=TEXT(NOW(),"dd-mmm-")

Regards
Prince


On Thursday, December 27, 2012 11:58:21 AM UTC+5:30, tharwani.rohit wrote:
>
> Hie Experts  ,
> PFA of Daily Consumer daily sales & i need  urgent help from your side 
> ..in report sheet i have put formulas & in PTD 15feb 2012 in this i need to 
> everytime change date so the amounts changes automaticaly is there any way 
> so without changing date i can get the answer aur any suitable thing which 
> i can do & YTD 2012 ...kindly check revert me back ..
>  
>

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

Re: $$Excel-Macros$$ Re: Sales File

[rohit tharwani]

Hi Prince ,



On Thu, Dec 27, 2012 at 10:55 AM, Prince  wrote:

> Hi Rohit,
>
> Pls Check my file as i have put sumif formula in ptd & ytd & suggest me
> wht should be possible for me .
>


> I hope this may help you, Otherwise let me know.
>
> =TEXT(NOW(),"dd-mmm-")
>
> Regards
> Prince
>
>
> On Thursday, December 27, 2012 11:58:21 AM UTC+5:30, tharwani.rohit wrote:
>>
>> Hie Experts  ,
>> PFA of Daily Consumer daily sales & i need  urgent help from your side
>> ..in report sheet i have put formulas & in PTD 15feb 2012 in this i need to
>> everytime change date so the amounts changes automaticaly is there any way
>> so without changing date i can get the answer aur any suitable thing which
>> i can do & YTD 2012 ...kindly check revert me back ..
>>
>>  --
> 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.