Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

[Rajasekhar Praharaju]

Hi Ashish,

Just go through this link... you have good examples...

http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/

Thanks,
Raj


On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:

> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by checking multiple conditions.
>
> Countif - used to count the range by checking single condiyion.
> Countifs - used to count the range by checking multiple conditions.
> On Jul 29, 2013 8:28 PM, "Ashish Kumar"  wrote:
>
>> Dear seniors,
>>
>> How can we use sum & sumifs , countif & countifs. and what is the
>> diffrence between. pls explain with formula and example. pls help me.
>>
>>
>>
>> thanks
>> Ashish
>>
>> --
>> 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.
>
>
>



-- 
-- 
Thanks & Regards,
*Rajasekhar.P*

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

[Rajasekhar Praharaju]

Rekha,


Just try this code instead of or change it to And

With ThisWorkbook.Worksheets("Bex File")
Set rng = .Range("A1").CurrentRegion
rng.AutoFilter 15, "<>" & "*Chief Technology Office*", xlAnd,
"<>" & "*Desktop Platform*"
rng.AutoFilter Field:=25, Criteria1:="=*AF*"
Sheets("Bex File").Select
 Cells.Select
   Selection.SpecialCells(xlCellTypeVisible).Select
   Selection.Copy


On Sun, Jun 2, 2013 at 2:01 AM, rekha siri  wrote:

> Hi Friends,
>
> i tried piece of code for auto filter criteria , i succeeded  in condition
> for
>
> autofilter for which criteria is equal to...
>
> but does not equal to condition i am not getting proper result.
>
>
> Basically i want to place a condition that 15th column in Bex file sheet
> should be filter with  custom filter does not equal to
>
>  Chief Technology Office  Desktop Platform
> and should equal to AF criteria in 25th column .
>
> below is the code please rectify me...
>
>
> With ThisWorkbook.Worksheets("Bex File")
> Set rng = .Range("A1").CurrentRegion
> rng.AutoFilter 15, "<>" & "*Chief Technology Office*", xlOr,
> "<>" & "*Desktop Platform*"
> rng.AutoFilter Field:=25, Criteria1:="=*AF*"
> Sheets("Bex File").Select
>  Cells.Select
>Selection.SpecialCells(xlCellTypeVisible).Select
>Selection.Copy
>
>
>  --
> 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.
>
>
>



-- 
-- 
Thanks & Regards,
*Rajasekhar.P*

-- 
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$$ Advance filter issue

[Rajasekhar Praharaju]

thanks for your help in advance...


On Sun, Apr 14, 2013 at 3:51 PM, pavithra murthy wrote:

> Hello,
>
> I tried writing a macro code. Will give you the result shortly
>
> Thanks,
> Pavithra
>
> ---
>
>
> On Sun, Apr 14, 2013 at 3:58 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> hi Experts,
>>
>> Need your help , as i could not club both sheets in new workbook.
>>
>> Thanks,
>> Raj
>>
>>
>> On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju <
>> rajasekhar.prahar...@gmail.com> wrote:
>>
>>> Hi friends,
>>>
>>> Please assist with Advance filter issue,
>>>
>>> i have created a macro which will be taking unique cost centers from
>>> LOAD DATA tab and copy the complete rows and paste it individual workbooks
>>> cost center wise.
>>>
>>> but now i have another tab beside LOAD DATA , i.e Detail tab.
>>>
>>> Now can any one help to perform same action like above..
>>>
>>> Copy the A column unique costcenters and copy the details individual
>>> cost center wise.
>>>
>>> Both tabs which is generated from LOAD DATA and Detail Tab should be in
>>> placed in one workbook.
>>>
>>> Thanks i am attaching work book please assist in this concern.
>>>
>>> --
>>> --
>>> Thanks & Regards,
>>> *Rajasekhar.P*
>>>
>>>
>>>  --
>>> 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.
>>>
>>>
>>>
>>
>>
>>
>> --
>> --
>> Thanks & Regards,
>> *Rajasekhar.P*
>>
>>
>>  --
>> 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_o

Re: $$Excel-Macros$$ Advance filter issue

[Rajasekhar Praharaju]

hi Experts,

Need your help , as i could not club both sheets in new workbook.

Thanks,
Raj


On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Hi friends,
>
> Please assist with Advance filter issue,
>
> i have created a macro which will be taking unique cost centers from LOAD
> DATA tab and copy the complete rows and paste it individual workbooks cost
> center wise.
>
> but now i have another tab beside LOAD DATA , i.e Detail tab.
>
> Now can any one help to perform same action like above..
>
> Copy the A column unique costcenters and copy the details individual cost
> center wise.
>
> Both tabs which is generated from LOAD DATA and Detail Tab should be in
> placed in one workbook.
>
> Thanks i am attaching work book please assist in this concern.
>
> --
> --
> Thanks & Regards,
> *Rajasekhar.P*
>
>
>  --
> 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.
>
>
>



-- 
-- 
Thanks & Regards,
*Rajasekhar.P*

-- 
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$$ Happy b'day Noorain Ansari

[Rajasekhar Praharaju]

Happy birthday Noor have a delightful nd colourful moments a head.
On Jan 2, 2013 12:25 AM, "Umesh Soni"  wrote:

> Happy birthday Noorain.. May All u r wishes comes true have a great
> Year Ahead.
>
> Regards,
>
> Umesh Soni
>
> On Tue, Jan 1, 2013 at 7:43 PM,  wrote:
>
>> Happy b'day Noorain Ansari
>>
>>
>> Regards
>> Ashish Koul
>> Sent on my BlackBerry® from Vodafone
>>
>> --
>> 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.

Re: $$Excel-Macros$$ discussexcel formula quiz 1

[Rajasekhar Praharaju]

done


On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA wrote:

> done
>
>
> On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal  wrote:
>
>> Done.
>>
>> On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain wrote:
>>
>>> Dear group,
>>>
>>> I have created a small formula quiz to test your formula knowledge. This
>>> quiz has 10 questions related to excel formulas only.
>>> Formula quiz 
>>>
>>> Based on your participation and engagement, I will try to launch more
>>> such activities in the forum
>>> Click here to participate 
>>>
>>> Only 50 people can participate, so hurry and participate.
>>>
>>> Many Thanks.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>>
>>> --
>>> 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
>> measure.
>>
>> 4) 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
> measure.
>
> 4) 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.
>
>
>



-- 
-- 
Thanks & Regards,
Rajasekhar.P

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

$$Excel-Macros$$ Accoount payable excel templates

[Rajasekhar Praharaju]

Hi friends,

Please share the excel template of accounts payable if any one of u is
having.

basically i am planning to build up a template on accounts payable data in
excel for forecasting and analysis. and need your experts advise.

Please do share if any of you are having such stuff.

Thanks in Advance.

-- 
-- 
Thanks & Regards,
Rajasekhar.P

-- 
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$$ Rajan Verma - Most Helpful Member September 2012

[Rajasekhar Praharaju]

Congrats rajan for your threshold efforts..


On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff  wrote:

> I'm happy to see you recognized and honored for your continued great
> contribution Rajan.
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
> *Sent:* Tuesday, October 02, 2012 8:34 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Rajan Verma - Most Helpful Member September
> 2012
>
> ** **
>
> Dear members,
>
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Sep'12. He has posted 137 posts in last month and helped forum members
> through his excel expertise.
>
> I truly appreciate his knowledge, consistency and commitment to the group.
> 
>
> *
> Rajan, please find enclosed the award certificate in honor of your
> contribution. Congratulations and thanks for your contribution.*
>
>
> Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other
> folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
>
> Ayush Jain
>
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey
> form.
> 
>
> --
> 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.

Re: $$Excel-Macros$$ Marquee text in Powerpoint

[Rajasekhar Praharaju]

Ashish, any idea in this regards as already you have created in excel.

Thanks for your help in advance!!

On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon  wrote:

> You might do better asking PowerPoint questions on a Powerpoint forum.  As
> its name indicates this forum is about Excel Macros.
>
>
> On 4 August 2012 02:24, rekha siri  wrote:
>
>> Hi Experts,
>>
>> Please assist in this concern i deal with xlius earlier now we are using
>> only power point dashboard presentation.
>>
>> is there any possibility to place the scrolling marquee kind of text as
>> Headings of power point slides.
>>
>> which needs to be scrolling continously.
>>
>>
>> Thanks,
>> Rekha
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Regards
> David Grugeon
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
-- 
Thanks & Regards,
Rajasekhar.P

Subscribe to our group and receive daily updates.
Excel groups

https://sites.google.com/site/excelencyclopedia/how-to-join/assignments

Send your queries and Suggestions @
excel-gro...@googglegroups.com

Excelforum Blogspot

http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US">Subscribe
to excel forum by Email

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

[Rajasekhar Praharaju]

hi experts,

Need your expert advise.

please provide  a vba code which copiesText frame box copied from excel and
then pastes it to ppt slide in bottom.


-- 
-- 
Thanks & Regards,
Rajasekhar.P

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Need if formula

[Rajasekhar Praharaju]

i just used this formula however how can i add iserror formula to this..



On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> thanks one and all for your help..
>
>
> On Wed, Mar 7, 2012 at 7:14 PM, dguillett1  wrote:
>
>>   You didn’t show us your situation but, depending on your need you
>> could use LOOKUP, vLookup
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Ashish Bhalara 
>> *Sent:* Tuesday, March 06, 2012 10:14 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Need if formula
>>
>> Dear expert,
>>
>> If function used maximum 7 time in an function, if the requirement of
>> condition if is more than 7, what is the function used or which type of
>> condition are need to fulfill 10 different condition?
>>
>> Thanks & regards
>>
>> Ashish Bhalara
>>
>> On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta <
>> sharadgupta_2...@rediffmail.com> wrote:
>>
>>>
>>>
>>> On Tue, 06 Mar 2012 14:42:54 +0530 wrote
>>>
>>> >hi Experts,
>>> please provide if condition formula for attached sheet.
>>> Thanks,Rekah
>>>
>>>
>>>
>>> --
>>> >
>>> FORUM RULES (986+ members already BANNED for violation)
>>> >
>>>
>>> >
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> >
>>>
>>> >
>>> 2) Don't post a question in the thread of another member.
>>> >
>>>
>>> >
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> >
>>>
>>> >
>>> 4) Acknowledge the responses you receive, good or bad.
>>> >
>>>
>>> >
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>> >
>>>
>>> >
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> >
>>>
>>> >
>>>
>>> --
>>> >
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> >
>>>
>>>
>>> Sharad Gupta
>>> 9799795367
>>>
>>> <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?>
>>>   Follow
>>> *Rediff Deal ho 
>>> jaye!<http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___&cmp=signature&lnk=rediffmailsignature&newservice=deals>
>>> * to get exciting offers in your city everyday.
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in 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.
>>
>

Re: $$Excel-Macros$$ Need if formula

[Rajasekhar Praharaju]

thanks one and all for your help..

On Wed, Mar 7, 2012 at 7:14 PM, dguillett1  wrote:

>   You didn’t show us your situation but, depending on your need you could
> use LOOKUP, vLookup
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ashish Bhalara 
> *Sent:* Tuesday, March 06, 2012 10:14 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need if formula
>
> Dear expert,
>
> If function used maximum 7 time in an function, if the requirement of
> condition if is more than 7, what is the function used or which type of
> condition are need to fulfill 10 different condition?
>
> Thanks & regards
>
> Ashish Bhalara
>
> On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta <
> sharadgupta_2...@rediffmail.com> wrote:
>
>>
>>
>> On Tue, 06 Mar 2012 14:42:54 +0530 wrote
>>
>> >hi Experts,
>> please provide if condition formula for attached sheet.
>> Thanks,Rekah
>>
>>
>>
>> --
>> >
>> FORUM RULES (986+ members already BANNED for violation)
>> >
>>
>> >
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> >
>>
>> >
>> 2) Don't post a question in the thread of another member.
>> >
>>
>> >
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> >
>>
>> >
>> 4) Acknowledge the responses you receive, good or bad.
>> >
>>
>> >
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>> >
>>
>> >
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> >
>>
>> >
>>
>> --
>> >
>> To post to this group, send email to excel-macros@googlegroups.com
>> >
>>
>>
>> Sharad Gupta
>> 9799795367
>>
>> 
>>   Follow
>> *Rediff Deal ho 
>> jaye!
>> * to get exciting offers in your city everyday.
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in 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

Re: $$Excel-Macros$$ Need help

[Rajasekhar Praharaju]

thanks alot Paul its working.

On Fri, Oct 14, 2011 at 9:09 PM, Paul Schreiner wrote:

> do you HAVE a sheet called "FolderList" ??
>
> If not, replace "FolderList" with the name of the sheet that you want to
> use to display the sizes!
>
>
> *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:* Rajasekhar Praharaju 
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, October 14, 2011 11:31:34 AM
>
> *Subject:* Re: $$Excel-Macros$$ Need help
>
> hi Paul,
>
> i am getting bug here,
>
>  ub List_Folder_Size()
> Dim fso, fldr, sfldr, FolderName
> Dim Sht, R
> FolderName = "D:\C-backup"
> Sht = "FolderList"
>
> Set fso = CreateObject("Scripting.FileSystemObject")
>
> Sheets(Sht).Range("A2:Z65000").ClearContents
>
>
> this yellow highlighted one i am getting bug.
>
> Please can you help me in this concern.
>
> Thanks,
> Raj
> On Fri, Oct 14, 2011 at 8:51 PM, Paul Schreiner wrote:
>
>>   This should do it.
>>
>> Sub List_Folder_Size()
>> Dim fso, fldr, sfldr, FolderName
>> Dim Sht, R
>> FolderName = "C:\temp\"
>> Sht = "FolderList"
>>
>> Set fso = CreateObject("Scripting.FileSystemObject")
>>
>> Sheets(Sht).Range("A2:Z65000").ClearContents
>> R = 1
>> If (fso.folderexists(FolderName)) Then
>> Set fldr = fso.getfolder(FolderName)
>> For Each sfldr In fldr.subfolders
>> R = R + 1
>> Sheets(Sht).Cells(R, "A").Value = sfldr.Name
>> Sheets(Sht).Cells(R, "B").Value = sfldr.Size
>> Next
>> End If
>> MsgBox "Done"
>> End Sub
>>
>>
>>
>> *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:* Rajasekhar Praharaju 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Fri, October 14, 2011 11:18:13 AM
>> *Subject:* Re: $$Excel-Macros$$ Need help
>>
>> Hi Paul,
>>
>> Thanks for your quick reply, Only the first sub folder names and their
>> respective sizes.
>>
>> Thanks,
>> Raj
>>
>> On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner 
>> wrote:
>>
>>>   are you wanting all sub-folders within the folder?
>>> or do you want to progress down through all the nested sub-folders?
>>>
>>>
>>> *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:* Rajasekhar Praharaju 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Fri, October 14, 2011 11:11:22 AM
>>> *Subject:* $$Excel-Macros$$ Need help
>>>
>>> Good evening experts,
>>>
>>> Please assist me in this concern i am  looking for a excel macro which
>>> can give details of  folders and their respective size.
>>>
>>> for example  i have Main folder with name Excel with in the folder i have
>>> many other sub folders, so i am looking for a macro which can list the sub
>>> folders names and their respective sizes.
>>>
>>> Thanks for your help in advance.
>>>
>>> --
>>> --
>>> Thanks & Regards,
>>> Rajasekhar.P
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://tw

Re: $$Excel-Macros$$ Need help

[Rajasekhar Praharaju]

hi Paul,

i am getting bug here,

ub List_Folder_Size()
Dim fso, fldr, sfldr, FolderName
Dim Sht, R
FolderName = "D:\C-backup"
Sht = "FolderList"

Set fso = CreateObject("Scripting.FileSystemObject")

Sheets(Sht).Range("A2:Z65000").ClearContents


this yellow highlighted one i am getting bug.

Please can you help me in this concern.

Thanks,
Raj
On Fri, Oct 14, 2011 at 8:51 PM, Paul Schreiner wrote:

> This should do it.
>
> Sub List_Folder_Size()
> Dim fso, fldr, sfldr, FolderName
> Dim Sht, R
> FolderName = "C:\temp\"
> Sht = "FolderList"
>
> Set fso = CreateObject("Scripting.FileSystemObject")
>
> Sheets(Sht).Range("A2:Z65000").ClearContents
> R = 1
> If (fso.folderexists(FolderName)) Then
> Set fldr = fso.getfolder(FolderName)
> For Each sfldr In fldr.subfolders
> R = R + 1
> Sheets(Sht).Cells(R, "A").Value = sfldr.Name
> Sheets(Sht).Cells(R, "B").Value = sfldr.Size
> Next
> End If
> MsgBox "Done"
> End Sub
>
>
>
> *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:* Rajasekhar Praharaju 
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, October 14, 2011 11:18:13 AM
> *Subject:* Re: $$Excel-Macros$$ Need help
>
> Hi Paul,
>
> Thanks for your quick reply, Only the first sub folder names and their
> respective sizes.
>
> Thanks,
> Raj
>
> On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner wrote:
>
>>   are you wanting all sub-folders within the folder?
>> or do you want to progress down through all the nested sub-folders?
>>
>>
>> *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:* Rajasekhar Praharaju 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Fri, October 14, 2011 11:11:22 AM
>> *Subject:* $$Excel-Macros$$ Need help
>>
>> Good evening experts,
>>
>> Please assist me in this concern i am  looking for a excel macro which can
>> give details of  folders and their respective size.
>>
>> for example  i have Main folder with name Excel with in the folder i have
>> many other sub folders, so i am looking for a macro which can list the sub
>> folders names and their respective sizes.
>>
>> Thanks for your help in advance.
>>
>> --
>> --
>> Thanks & Regards,
>> Rajasekhar.P
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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
>>
>> <><><

$$Excel-Macros$$ Need help

[Rajasekhar Praharaju]

Good evening experts,

Please assist me in this concern i am  looking for a excel macro which can
give details of  folders and their respective size.

for example  i have Main folder with name Excel with in the folder i have
many other sub folders, so i am looking for a macro which can list the sub
folders names and their respective sizes.

Thanks for your help in advance.

-- 
-- 
Thanks & Regards,
Rajasekhar.P

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

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

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

[Rajasekhar Praharaju]

Thanks for sharing this mahesh and rajan

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

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



-- 
-- 
Thanks & Regards,
Rajasekhar.P

Subscribe to our group and receive daily updates.
Excel groups

https://sites.google.com/site/excelencyclopedia/how-to-join/assignments

Send your queries and Suggestions @
excel-gro...@googglegroups.com

Excelforum Blogspot

http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US">Subscribe
to excel forum by Email

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

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

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

[Rajasekhar Praharaju]

Thanks a ton to one all really helped me alot in this concern.

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

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

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

[Rajasekhar Praharaju]

hi,

I will be preparing the leaveplanner tracker report frequently .

i will colour the specific day when i am absent on particular day.finallyon
the  end of the month

i will count the different colours and place the number.

Please provide the formula or vba macro to perform this activity.

thanks,
Raj

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


Leave planner & tracker1.xlsx
Description: Binary data

Re: $$Excel-Macros$$ Nos. of Sundays between two days

[Rajasekhar Praharaju]

thanks alot its awesome

On Wed, Feb 16, 2011 at 8:48 PM, ashish koul  wrote:

> j1 start date
> j2 end date
>
> monday =I
> F(TEXT(J1,"")<>"Monday",NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1)
>
> saturday =  INT(((J2-J1)-NETWORKDAYS(J1,J2))/2)
>
>   On Wed, Feb 16, 2011 at 7:10 PM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> hi ashish,
>>
>> Can you please help to find out how many mondays and saturdays are
>> present for the same above query.
>> 01/16/2011 to 02/16/20111
>>
>>
>> Thanks,
>> Raj
>>
>>
>>
>> On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan 
>> wrote:
>>
>>>  Thank you very much for the prompt reply Sir.
>>>
>>>
>>>
>>> - Original Message -
>>>
>>> *From:* ashish koul 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Monday, February 14, 2011 8:17 PM
>>> *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days
>>>
>>> start date in a1
>>>
>>> and end date in a2
>>>
>>> no of sundays  =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
>>>
>>> On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan 
>>> wrote:
>>>
>>>>  Dear Sir,
>>>>
>>>> Formula required for nos. of sundays between two days.
>>>> e.g. if an employee has joined on 18/7/2010, how many sundays between
>>>> 18/7/2010 and 31/01/2011.
>>>>
>>>> Thanks & Regards.
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.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.
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.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
>>>
>>>

Re: $$Excel-Macros$$ Nos. of Sundays between two days

[Rajasekhar Praharaju]

hi ashish,

Can you please help to find out how many mondays and saturdays are
present for the same above query.
01/16/2011 to 02/16/20111


Thanks,
Raj



On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan wrote:

>  Thank you very much for the prompt reply Sir.
>
>
>
> - Original Message -
>
> *From:* ashish koul 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, February 14, 2011 8:17 PM
> *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days
>
> start date in a1
>
> and end date in a2
>
> no of sundays  =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
>
> On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote:
>
>>  Dear Sir,
>>
>> Formula required for nos. of sundays between two days.
>> e.g. if an employee has joined on 18/7/2010, how many sundays between
>> 18/7/2010 and 31/01/2011.
>>
>> Thanks & Regards.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> **
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

[Rajasekhar Praharaju]

hi please use this simple procedure


Excel Text to Column Command
The Text to Column command allows you to break text in one column into
several columns. For example, if you have LastName, FirstName in a column,
you can break the text into two columns—one containing LastName and the
other containing FirstName.

1. Insert as many columns to the left of the column to be split as needed.
2. Select the cells to be separated.
3. Pull down the Data menu and choose Text to Columns
4. Choose Delimited and click on Next
5. Choose the Delimiter that is used in the column, such as comma and click
on Next
6. To set the column data format, click on the column and then click on the
format desired under column data format (this is optional).  Repeat this for
each column and click on Finish.

Excel Transpose Command
Use the transpose feature to switch data from vertical to horizontal.

1. Select the cells to switch
2. Click on the Copy tool
3. Click where you want the data to be transposed to
4. Pull down the Edit menu and choose Paste Special
5. Click on Transpose and click on OK


Thanks,
Raj


On Tue, Feb 15, 2011 at 1:37 AM, Hems  wrote:

> Hi Guys,
>
> Pls check attached excel sheet.
>
> I have data in across 2 columns which i want move in one row through macro,
> is it possible?
>
> actually the data is extracted from access database so if its poss through
> macro then i can process in access rather trolling it through excel.
>
> appreciate your efforts and thanks in advance.
>
> --
> Kind Regards,
> Hems
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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$$ Fwd: Need to Check

[Rajasekhar Praharaju]

hi ,

Please help in this concern can any one help in this concern i require this
computation using excel macro
below is the link which is coded in HTML. Which is working fine but i cant
use this link in my organisation so kindly can anyone help to build the
excel macro for this concern.

Thanks,
Raj


 http://billingcombins.appspot.com/

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

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

$$Excel-Macros$$ "ashish koul" ,

[Rajasekhar Praharaju]

Hi,



I have an excel sheet and I want to filter for BLANKS in multiple columns
and provide comment of the other column. Can some one help me writing a
macro/add-on? expand »



Here each time the columns will not be the same, so it would be good if the
macro asks for the range and perform the activity. And second criteria are
next column if I specify the path is should populate with the value as "No"
for the entire BLANKS and "Yes" for the non blanks one.

Example file attached for reference, where in my range will be from open
price i.e from column AG to AZ and in next column i.e BA I should have
comment as "No" for BLANKS and "Yes" for NON BLANKS.







Thanks and have a nice weekend...!!!


Regards,
Raj

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

[Rajasekhar Praharaju]

Hi Friends,

I just wanted to share this differences between Excel 2003 and 2007.




Number of Rows and Columns

One of the main developments in Excel 2007 is that it allows more columns
and rows. For many users this may not be an issue - after all, the 65,536
rows and 256 columns provided by Excel 2003 allows you to handle a large
amount of data. However, it isn't so unusual for users to want to handle
HUGE amounts of data! Therefore Excel 2007's ability to handle 1,048,576
rows and 16,384 columns of data is a great advantage for some users.

Conditional Formatting

Another major improvement in Excel 2007 is Conditional formatting. I have
frequently been asked, by colleagues using Excel 2003, about applying more
than 3 conditional formats. Up until recently, I have always had to explain
that this is a limitation of Excel 2003, but now, in Excel 2007, a user can
specify as many conditions as they like, each with a different format.
[image: Data Bars Color Scales & Icon Sets Examples in Excel 2007]

Conditional formatting in Excel 2007 can even be made to work for cells that
satisfy more than one condition. For example, if you specify cells having
values ≤ 10 to have bold text and cells having values ≥ 10 to have red text,
you will find that text in cells containing values exactly equal to 10 will
be formatted as bold AND red.

Also, Excel 2007 offers additional types of conditional formatting. If your
bosses (like mine) like to see figures illustrated with pretty charts and
lots of colour, they will love the spreadsheets you produce with Excel's new
Data Bars, Color Scales & Icon Sets! These features apply colour or symbols
to a range of cells, depending upon each cell's value in relation to the
rest of the cells in the selected range. As an example, the image on the
right shows conditional formatting Data Bars, Color Scales & Icon Sets,
applied to 3 columns, each containing the numbers 1 - 10.

As a final bonus, Excel 2007 also now enables conditional formatting to be
used with pivot tables.

At first, the interface to Excel 2007 conditional formatting can appear to
be a bit complicated, but the time spent familiarising yourself with this
functionality is well worth the investment!

Filtering and Sorting by Colour

In Excel 2003, Filtering and Sorting could be performed by cell values only.
However, in Excel 2007, you can now filter and sort by colour. This can be
either the font colour or the cell background colour.

Function Nesting Limitations

In my opinion, one of the most useful improvements in Excel 2007 is the
level of nesting that can be performed. Excel 2003 only allows 7 levels of
nesting of functions, while Excel 2007 allows up to 64. Surely, even the
most dedicated Excel user cannot possibly need more nesting levels than
that!

Resizeable Formula Bar
[image: Extended Formula Bar in Excel 2007]

In Excel 2003, if a cell contained a long formula or text string, when the
cell was selected, the view of the formula bar would block some of your
spreadsheet. This was slightly inconvenient. However, Microsoft have
addressed this problem in Excel 2007, by introducing a resizeable formula
bar, which extends in line with your cell contents. This is shown in the
image above.

New Functions

Excel 2007 contains a number of new built-in functions to help you to make
your spreadsheet slicker and more efficient. These include the IFERROR
Function, the SUMIFS function, and the new statistical AVERAGEIF,
AVERAGEIFS, and COUNTIFS functions.

Increased Memory and Faster Calculations

My work has frequently been slowed down, when applying functions to large
datasets in Excel 2003. I have often pasted a formula down every row of a
spreadsheet, and then had to sit back and wait for Excel to calculate the
formula results. However, this has improved in in Excel 2007, as memory
management has been increased from 1 gigabyte to 2 gigabytes and complex
calculations are now faster.

Charting

There have been some issues with the updating of charts in Excel 2007, which
is slower than in Excel 2003. Also, the recording of macros involving charts
sometimes doesn't work! For me personally, this isn't a great issue.
However, if you frequently perform chart updates, or like to record macros
involving charts, you should test drive Excel 2007 before committing to it.
A free trial can be downloaded from the Microsoft Office Online website *(opens
in a new window)*.

New User Interface

The main user interface has been restructured in Excel 2007, into what
Microsoft describe as a "results-oriented" interface. However, if you have
been using Excel 2003 for several years, and know exactly where to find the
tools functionality that you regularly use, there will almost certainly be a
certain amount of frustration to begin with. My advice is ... Persevere! ...
it really is worth the effort! Like anything, once you get used to it,
negotiating the new user interface will become second nature to you!


Thanks,
Raj

-- 
---

Re: $$Excel-Macros$$ Fwd: need help

[Rajasekhar Praharaju]

Please find the attached sheet i could able to build formula for single line
item

But i want if the criteria is having mulitple line items the results should
display as

Date description, Date description, Date description.

Please help me in this concern,

Thanks,
Raj

On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

>
>
> Hi ,
>
> Please help me in this concern,
>
>  In this sheet i am trying to place vlookup for multiple fields yaar
>
> it should through the description and date in AG column basing on list of
> activities.
> but i should get this in horizontal basis..
>
> can anyone  plz help me in this concern.
>
> for example
> if one activity is performed twice which is shown on top left hand corner.
>
> IRS Publications  activity has two line items then it should come as
> against the J102 which is IRS Publications it should through up the
> description and date in this manner
>
>pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011
>
>  --
> -Thanks,
> Raj
>

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


query with formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Fwd: $$Excel-Macros$$ Fwd: need help

[Rajasekhar Praharaju]

Hi ,

Please help me in this concern,

 In this sheet i am trying to place vlookup for multiple fields yaar

it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..

can anyone  plz help me in this concern.

for example
if one activity is performed twice which is shown on top left hand corner.

IRS Publications  activity has two line items then it should come as against
the J102 which is IRS Publications it should through up the description and
date in this manner

   pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011

 --
-Thanks,
Raj

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


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

$$Excel-Macros$$ Fwd: need help

[Rajasekhar Praharaju]

Hi ,

 In this sheet i am trying to place vlookup for multiple fields yaar

it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..

can anyone  plz help me in this concern.

for example
if one activity is performed twice which is shown on top left hand corner.

IRS Publications  activity has two line items then it should come as against
the J102 which is IRS Publications it should through up the description and
date in this manner

   pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011

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


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

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

[Rajasekhar Praharaju]

Congratts dilip

On Tue, Jan 4, 2011 at 12:34 AM, Vinod N  wrote:

> Congratulations!! Dilipji...
>
>
> On Mon, Jan 3, 2011 at 3:31 PM, Ayush  wrote:
>
>> Dear Group,
>>
>> I am very very very very happy to share a good news with you. One of our
>> dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on
>> 1st January for his exceptional Excel skills and voluntary contribution.
>> He is well deserving for the award and I am very happy about his
>> recognition.
>>
>> Dear Dilip, Many Many congratulations, Keep it up.
>> I am very proud of you to be part of this group. I wish your long
>> association with this group.
>>
>> Best Regards,
>> Ayush Jain
>> Microsoft MVP-2010
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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 and Regards
>
> Vinod Narayanan
> http://cavinod.blogspot.com/
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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

Re: $$Excel-Macros$$ Top poster of the Month- Dec'10 : Ashish Koul

[Rajasekhar Praharaju]

Congratulations Ashish, we wish you flamboyant future.

On Sat, Jan 1, 2011 at 4:40 PM, ashish koul  wrote:

> welcome ayush,  happy new year to you and everyone in the group...
>
>
>
>
> On Sat, Jan 1, 2011 at 1:37 PM, Ayush  wrote:
>
>> Dear Group,
>>
>> I am very happy to announce that Ashish Koul is the top poster for
>> the month of Dec'10. He has topped with 37 posts this month.
>>
>> Ashish, Congratulations and Many Many Thanks for your great contribution.
>>
>> I really appreciate your willingness to help others and your excellent
>> knowledge of excel. Keep it up.
>> Thanks a tonne on behalf of whole group.
>>
>> Keep posting !
>>
>> Best regards,
>> Ayush Jain
>> Microsoft MVP
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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
>>
>
>
>
> --
> *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/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

Re: $$Excel-Macros$$ How to extract characters from right

[Rajasekhar Praharaju]

hi Kalyan,

Use substitute function.

Please find the attached solution hope it helps you.

Thanks,
Raj

On Fri, Nov 26, 2010 at 10:55 AM, Kal xcel  wrote:

> Dear Experts,
>
> I am facing a problem to extract characters from right of string.
>
> Please help.
>
> Thanks in advance.
>
> Kalyan
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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


How to extract characters from right(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup

[Rajasekhar Praharaju]

Hi Muralidhar,

did u check the attached pivot solution
let me know if it is not apt then i will do v-lookup fucntion as u sent.

Thanks,
Raj

On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e wrote:

> Dear all,
>
> This is urgent to me, plz suggest solution as early as possible.
>
> Warm Regards,
>
> Muralidhar E.
>
> -- Forwarded message --
> From: muralidhar e 
> Date: Thu, Nov 11, 2010 at 11:02 AM
> Subject: $$Excel-Macros$$ Vlookup
> To: excel-macros@googlegroups.com
>
>
>  Dear all group members,
>
> I want to get the L T no, by using vlookup formula, by repeated batches.
> file was attached plz suggest me how to do this by using lookup formula for
> repeated.Iam using MS-Office 2007.
>
> Warm Regards,
>
> Muralidhar E.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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
>

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

[Rajasekhar Praharaju]

hello rakesh,

Only for this attached sheet do you have  query or Prior chain mails as
well,  then i think u can just use this formula for the attached sheet
replacing date

=A2+30

By adding 30days u are getting the answer...Please let me know if this
resolves your query or not.

Thanks,
Raj

On Thu, Nov 11, 2010 at 10:48 AM, Rakesh Sharma wrote:

> Dear All,
>
>
> Can i replace the date as per my requirement. if yes plz suggest me how it
> possible.
>
>
> Thanks in advance plz do the needful ASAP.
>
> --
> Regards
> Rakesh Sharma
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.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


Copy of help req.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Vlookup

[Rajasekhar Praharaju]

Hello Muralidhar,

Instead of Vlookup you can use Pivot table it depicts good results.

Please find Attached is the solved sheet..

Let me know if you are looking for the same or anything else.

Thanks,
Raj

On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote:

> Dear all group members,
>
> I want to get the L T no, by using vlookup formula, by repeated batches.
> file was attached plz suggest me how to do this by using lookup formula for
> repeated.Iam using MS-Office 2007.
>
> Warm Regards,
>
> Muralidhar E.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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


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

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

[Rajasekhar Praharaju]

hi,


Check this website hope you will find the resolution

http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html

Thanks,
Raj

On Tue, Nov 9, 2010 at 11:19 PM, janet dickson wrote:

> Hello Excel Gurus,
>
>
> I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
> amount in different months into different cells. See attached fine for
> details.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Conditional Formatting

[Rajasekhar Praharaju]

Conditional Formatting



You can use something called Conditional Formatting in your spreadsheets.
Conditional Formatting allows you to change the appearance of a cell,
depending on certain conditions. What we'll do is to colour the Overall
Averages on our Student Exam spreadsheet, depending on the grade. Here's the
spreadsheet we'll be working on.

[image: The Student Grades Spreadsheet]

   - Open up your Student Exam spreadsheet (You did complete it, didn't
   you?)
   - Highlight the cells with Overall Grades, which should be cells B11 to
   I11

The Overall Averages range from 44 to 85. We'll colour each grade, depending
on a scale. A different colour will apply to the following grades:

   - 50 and below
   - 51 to 60
   - 61 to 70
   - 71 to 80
   - 81 and above

So five different bands, and a colour for each. To set the Conditional
Formatting in Excel 2007, do the following:

   - With your Overall Averages highlighted, click on the Home menu at the
   top of Excel
   - Locate the *Styles* panel, and the *Conditional Formatting* item:

[image: The Styles Panel in Excel 2007]

The Conditional Formatting menu gives you various options. The easiest one
is the Colour Scales option. Select one of these and Excel will colour the
cell backgrounds for you:

[image: Color Scales in Excel 2007]

That's not quite what we're looking for, though. We'd like to choose our own
values. So click on *More Rules*, from the *Colour Scales* submenu. You'll
see the following rather complex dialogue box:

[image: New Formatting Rule dialogue box]

The one we want is the second option, *Format only cells that contain*. This
will allow us to set up our values. When you click this option, the dialogue
box changes to this:

The part we're interested in is the bottom part, under the heading *Edit the
Rule Description*. It says *Cell Value* and *Between*, in the drop down
boxes. These are the ones we want. We only need to type a value for the two
boxes that are currently blank in the image above. We can then click the *
Format* button to choose a colour.

So type 0 in the first box and 50 in the second one:

Then click the *Format* button. You'll get another dialogue box popping up.
This is just the Format Cells one though. You've met this before. Click on
the Fill tab and choose a colour. Click OK and you should see something like
this under Edit the Rule Description:

The Preview is showing the colour we picked. So we've said, "*If* the Cell
Value is between 0 and 50 *then* colour the cell Red".

Click OK on this dialogue box to get back to Excel. You should find that one
of the cells has turned red. To format the rest of the cells, click on
Conditional Formatting on the Styles panel again. From the menu, click
on *Manage
Rules*:

You'll get yet another complex dialogue box popping up! This one:

Our first rule is already there - Cell Value Between. The only thing we're
doing here is adding New Rules, similar to the one we've just set up. Click
the *New Rule* button then. You'll see the exact same dialogue boxes you
used to set up the first rule. Set a new colour for the next scores - 51 to
60. Choose a colour, and keep clicking OK until you get back to the Rules
Manager dialogue box. It should now look something like this one:

We now have to colours in our range. Do the rest of the scores, choosing a
colour for each. The scores are these, remember:

   - 50 and below
   - 51 to 60
   - 61 to 70
   - 71 to 80
   - 81 and above

When you've done them all, your dialogue box should have five colours:

The colours above are entirely arbitrary, and you don't have to select the
same ones we did. The point is to have a different colour for each range of
scores. But click OK when you're done. Your Overall Averages will then look
something like this:

Formatting your spreadsheet in this way allows you to see at a glance
relevant information. In the spreadsheet above, it's obvious who's failing -
just look for the red cells!

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

[rajasekhar praharaju]

Thanks dilip .

On Wed, Oct 13, 2010 at 5:51 PM, Dilip Pandey  wrote:

> Hi Rajasekhar,
>
> I believe you are using Excel 2007, this is what I have figured out after
> seeing your example of Pivots.
> I would suggest you to record macro with all the steps which you are doing
> manually and then try editing those codes as per your automation needs.
>
> Alternatively, if you break down your manual steps in smaller steps, then I
> can give a try on this.  See doing it all from scratch is slightly time
> consuming and now-a-days I am little occupied and unable to devote that much
> time. :(
>
> Best Regards,
> DILIPandey
>
>
>
> On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>>   -- Forwarded message --
>> From: rajasekhar praharaju 
>> Date: Tue, Oct 12, 2010 at 5:49 PM
>> Subject: Re: $$Excel-Macros$$ Please help
>> To: Dilip Pandey , excel-macros@googlegroups.com
>>
>>
>> hi Dilip,
>>
>> firstly i will be copying the pivot table from task distribution sheet.
>>
>>
>>Row Labels Sum of # of no hits  DEEPTI 45  LAKSHMI 35  NIKHIL 46 PUSHPA
>> 15  RAVI 7  SAI 35  VENKAT 46  ARVIND 21 Grand Total 250
>>
>>
>> this part from task distribution sheet and click on extension bar (+) to
>> get the individual line items for all.
>>
>> then place the name which is listed on the top of the batch against their
>> respective lineitems .
>>
>> like this .
>>
>>
>> Row Labels Sum of # of no hits  DEEPTI 45 3 1 4 2 6 1 8 1 9 1 11 1 12
>> 1 15 2 292 1 300 2 301 1 302 2 304 2 305 1 418 10 561 2 562 1 573 3 574 5
>> 735 1 742 4  LAKSHMI 35 288 6 394 5 420 2 422 6 429 1 564 2 565 7 569 1
>> 737 5  NIKHIL 46 289 3 293 6 306 1 396 6 397 3 424 4 425 4 427 3 566 4
>> 571 4 576 4 739 4  PUSHPA 15 287 10 295 5  RAVI 7 285 4 286 3  SAI 35 296
>> 4 297 3 298 1 398 6 399 3 423 5 568 1 572 5 578 5 740 2  VENKAT 46 284 13
>> 290 2 308 2 309 2 311 1 416 4 421 5 563 8 570 3 736 6  ARVIND 21 16 3 283
>> 3 299 2 307 1 395 3 419 1 428 5 430 1 741 2  Grand Total 250
>> here the first column is Batch # and second column is their number of
>> hits.
>>
>> Please find the word file  attached i will assign names as follows.
>>
>> After this ill do v-lookup in  the sheet where the data is pasted .
>>
>>
>> comparing the task distribution sheet orginal  with Task distribution
>> sheet.
>>
>> 1) ill take batch number  from task distribution orginal sheet which is in
>> column c  as  Lookup value.
>> and table array as the data pasted in new sheet earlier.(pivot table
>> data which is pasted using paste special and then assigned names to it)
>> and Purpose of this vlook is to know get the pending batches billers
>> names.
>>
>> those batches which are left in task distribution sheet that batches as
>> well as their names should appear.
>>
>> Please advise is it possible. it could be very much helpful.
>>
>> Thanks,
>> Raj
>>
>>
>>
>>
>> On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey wrote:
>>
>>> Dear Rakasekhar.
>>>
>>> I am not able to understand your problem actually... :(
>>> How you are assigning the names against tasks ?
>>>
>>> I believe creating a pivot table and then using "Show Pages" option
>>> you can assign the tasks to different individuals.
>>>
>>> Please explain further if you need some other solution.
>>>
>>> Best Regards,
>>> DILIPandey
>>>
>>>
>>>
>>> On 10/9/10, rajasekhar praharaju  wrote:
>>> > could you please assist me in this concern .please
>>> >
>>> > actually if any batch is pending  using vlookup i used to find their
>>> > respective names
>>> > how is this possible through sumif please suggest .
>>> >
>>> > On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS 
>>> wrote:
>>> >
>>> >> Dear Rajasekhar
>>> >>
>>> >>
>>> >> Please use u Sumif Formulas.
>>> >>
>>> >> Regards
>>> >>
>>> >> Sumit Vyas
>>> >>
>>> >>
>>> >>
>>> >> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
>>

Re: $$Excel-Macros$$ Please help

[rajasekhar praharaju]

hi Dilip,

firstly i will be copying the pivot table from task distribution sheet.


  Row Labels Sum of # of no hits  DEEPTI 45  LAKSHMI 35  NIKHIL 46  PUSHPA
15  RAVI 7  SAI 35  VENKAT 46  ARVIND 21  Grand Total 250


this part from task distribution sheet and click on extension bar (+) to get
the individual line items for all.

then place the name which is listed on the top of the batch against their
respective lineitems .

like this .


  Row Labels Sum of # of no hits  DEEPTI 45  3 1  4 2  6 1  8 1  9 1  11 1
12 1  15 2  292 1  300 2  301 1  302 2  304 2  305 1  418 10  561 2  562 1
573 3  574 5  735 1  742 4  LAKSHMI 35  288 6  394 5  420 2  422 6  429 1
564 2  565 7  569 1  737 5  NIKHIL 46  289 3  293 6  306 1  396 6  397 3
424 4  425 4  427 3  566 4  571 4  576 4  739 4  PUSHPA 15  287 10  295 5
RAVI 7  285 4  286 3  SAI 35  296 4  297 3  298 1  398 6  399 3  423 5  568
1  572 5  578 5  740 2  VENKAT 46  284 13  290 2  308 2  309 2  311 1  416 4
421 5  563 8  570 3  736 6  ARVIND 21  16 3  283 3  299 2  307 1  395 3  419
1  428 5  430 1  741 2  Grand Total 250
here the first column is Batch # and second column is their number of hits.

After this ill do vlookup in  the sheet where the data is pasted .

comparing the task distribution sheet orginal  with Task distribution sheet.

1) ill take batch number  from task distribution orginal sheet which is in
column c  as  Lookup value.
and table array as the data pasted in new sheet earlier.(pivot table
data which is pasted using paste special and then assigned names to it)
and Purpose of this vlook is to know get the pending batches billers names.

those batches which are left in task distribution sheet that batches as well
as their names should appear.

Please advise is it possible. it could be very much helpful.

Thanks,
Raj




On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey  wrote:

> Dear Rakasekhar.
>
> I am not able to understand your problem actually... :(
> How you are assigning the names against tasks ?
>
> I believe creating a pivot table and then using "Show Pages" option
> you can assign the tasks to different individuals.
>
> Please explain further if you need some other solution.
>
> Best Regards,
> DILIPandey
>
>
>
> On 10/9/10, rajasekhar praharaju  wrote:
> > could you please assist me in this concern .please
> >
> > actually if any batch is pending  using vlookup i used to find their
> > respective names
> > how is this possible through sumif please suggest .
> >
> > On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS  wrote:
> >
> >> Dear Rajasekhar
> >>
> >>
> >> Please use u Sumif Formulas.
> >>
> >> Regards
> >>
> >> Sumit Vyas
> >>
> >>
> >>
> >> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
> >> rajasekhar.prahar...@gmail.com> wrote:
> >>
> >>>
> >>>
> >>>   hi Excel Guru,
> >>>
> >>>
> >>> Please assist me in this concern .
> >>>
> >>>
> >>> Attached are two sheets Task distribution orginal and other sheet with
> >>> task distribution
> >>>
> >>>
> >>> My daily activity is to do vlookup and firstly i will copy the pivot
> >>> table
> >>> from task distribution sheet orginal and paste special in one new excel
> >>> sheet then  compare it with another sheet which is task distribution
> >>> sheet.
> >>>
> >>>
> >>> 1) Prepare vlookup to find the batches which are pending .
> >>>
> >>>
> >>> once i perform vlookup it will display the names against the batches.
> >>> which are pending .
> >>>
> >>>
> >>> Please advise is this possible through vba.
> >>>
> >>>
> >>> Thanks for your help in advance.,
> >>>
> >>> Raj
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>  --
> >>>
> >>>
> --
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>&

Re: $$Excel-Macros$$ Please help

[rajasekhar praharaju]

could you please assist me in this concern .please

actually if any batch is pending  using vlookup i used to find their
respective names
how is this possible through sumif please suggest .

On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS  wrote:

> Dear Rajasekhar
>
>
> Please use u Sumif Formulas.
>
> Regards
>
> Sumit Vyas
>
>
>
> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>>   hi Excel Guru,
>>
>>
>> Please assist me in this concern .
>>
>>
>> Attached are two sheets Task distribution orginal and other sheet with
>> task distribution
>>
>>
>> My daily activity is to do vlookup and firstly i will copy the pivot table
>> from task distribution sheet orginal and paste special in one new excel
>> sheet then  compare it with another sheet which is task distribution sheet.
>>
>>
>> 1) Prepare vlookup to find the batches which are pending .
>>
>>
>> once i perform vlookup it will display the names against the batches.
>> which are pending .
>>
>>
>> Please advise is this possible through vba.
>>
>>
>> Thanks for your help in advance.,
>>
>> Raj
>>
>>
>>
>>
>>
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.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
>

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

[rajasekhar praharaju]

hello friend,

Go to top left hand corner of excel click on office button--> excel
options---> then select the add ins by double clicking on it.

then click on manage option ---> go

Thanks,
Raj



On Thu, Oct 7, 2010 at 10:55 PM, SAJID MEMON  wrote:

>  Hi Experts,
>
>  I want to know Add-in in excel. How this option is working or how can i
> know about this option much more.
>
> Give me any idea or tips.
>
> awaiting your replay
>
> Regards
> sajid memon
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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

Re: $$Excel-Macros$$ Hi Experts, Urgent

[rajasekhar praharaju]

hi Pankaj,

Can you please tell what formula you are looking for.

Could you please express your query in brief.


Thanks,
Raj

On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar wrote:

>  Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I
> have sorting Name list A-Z in different different coloums ,,, with the help
> of formulas ,,,attached excelsheet
>
> Ex.
> Aaman  Banaran   Canmanra  Damanran
> AryanBhuvanCamelDavid
>  *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
> *   rajputpankaj1...@rediffmail.com*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[rajasekhar praharaju]

hearty congratulations ayush, you really deserve it

Infact you are good encyclopedia for us.

Have a flamboyant future and delightful moments for ur future endeavors.

Regards,
Raj

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Need Help

[rajasekhar praharaju]

Hi friends,

Dear Adorable group... please share if any one of us are having excel
addin's . Moreover i am having query regarding the excel addin's.

Can any one suggest how to create the excel addins  i just tried creating
this addins . but could not use properly.

Thanks for your help in advance.

Regards,
Raj

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

[rajasekhar praharaju]

Hi Santosh,

Send Your sample excel work book attachment for review.

i can help you in this concern, i recently got good solution in regards to
this concern.

my id is rajasekhar.prahar...@gmail.com

copy even the group as well.

Thanks & Regards,
Raj


On Sun, Sep 12, 2010 at 6:50 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hello All,
>
> I have a folder in which every person maintains his data in the same format
> and at the end of the day the data needs to be collected into a new file or
> an existing file.
>
> This collection is done in a manual way can any one help me in collating
> the data from all the files via vba.
>
> The sheet name is Loop and the data is from coloum A to K , rows vary as
> per data.
>
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ help needed

[rajasekhar praharaju]

Hi Santosh,

Send Your sample excel work book attachment for review.

i can help you in this concern, i recently got good solution in regards to
this concern.

my id is rajasekhar.prahar...@gmail.com

copy even the group as well.

Thanks & Regards,
Raj

On Sun, Sep 12, 2010 at 6:50 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hello All,
>
> I have a folder in which every person maintains his data in the same format
> and at the end of the day the data needs to be collected into a new file or
> an existing file.
>
> This collection is done in a manual way can any one help me in collating
> the data from all the files via vba.
>
> The sheet name is Loop and the data is from coloum A to K , rows vary as
> per data.
>
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ I have a problem for following worksheet

[rajasekhar praharaju]

hello,

Pankaj attached is the solution for your query, the formula u depicted or
used in that cell
is accurate where as all you need to do is to give a space as shown below

9:00  AM   Give space like this for both intime and out time then as per
attached sheet u will have error free result.

Incase of any queries, let me know.

Thanks,
Raj



On Mon, Aug 30, 2010 at 7:03 AM, Pankaj Kumar wrote:

> Dear all,
>
>
> When i use the forumulla it shows value pls find attached sheep
> --
>  *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
> *   rajputpankaj1...@rediffmail.com*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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


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

$$Excel-Macros$$ Re: pivot data

[rajasekhar praharaju]

Hi Ashish,

firstly  i would like to thank for your prompt reply and assistance.

it is very delightful to have such adorable group with such a good guides
and query resolvers
Thanks for all your help once again.


Friends we should thank one and all who created this Groups which is really
a good learning campaign to one and all. let us continue to bridge excel
queries and learnings which helps us in  enriching  our potentials
simultaneously in turn help others.

Regards,
Raj


On Mon, Aug 30, 2010 at 6:06 AM, ashish koul  wrote:

>
>
> On Mon, Aug 30, 2010 at 6:17 PM, rajasekhar praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>

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

[rajasekhar praharaju]

hello friends,

In my opinion " Excel is In built end-user automated application which saves
lot of valuable time by proper utilization of  excel addin's and
formulas...

Regards,
Raj

On Fri, Aug 27, 2010 at 11:49 PM, Ayush  wrote:

> Its a very handy tool for any data analysis and reporting. - Ayush
> Jain
>
> ---
>
> Guyzzz, Let me know why you like excel so muchThe best response
> will be published on the home page with thanks. Please continue in
> this thread only just below my line I want to see the active
> participation...
>
> Thank u so much.
>
> -Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Need Help

[rajasekhar praharaju]

Hi All,

Please assist in this concern i wanted to prepare excel macro where in i can
consolidate different excel workbooks  data into
one excel workbook. so please send me if it is possible through vba macros.if
any one of the group is having the script or macro
for performing this activity please send to this mail id.

rajasekhar.prahar...@gmail.com


Regards,
Raj
--

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

[rajasekhar praharaju]

Hi All,

Please assist in this concern i wanted to prepare excel macro where in i can
consolidate different excel workbooks  data into
one excel workbook. so please send me if it is possible through vba
macros.if any one of the group is having the script or macro
for performing this activity please send to this mail id.

rajasekhar.prahar...@gmail.com


Regards,
Raj

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

[rajasekhar praharaju]

Hi Pooja,

Just click on excel options.

dialog box with different options are displayed then click on trust center.

and enable option is seen just click on trust and save it and close the work
book .

then u can use the macro enabled workbook.

Regards,
Raj

On Fri, Jul 30, 2010 at 12:25 PM, Pooja S  wrote:

>
> hi
>
> there is a problem in opening an excel file with macros...wht should be
> done to open the excel file with macros?
> pls rply soon..it is urgent
> --
> Pooja
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Need advise

[rajasekhar praharaju]

Hi All,

Myself rajasekher just require your valuable suggestion in this concern,

please advise the excel formular where in  i can use and the words for the
value specified in excel. for example if the value in excel is 80
(numerical) ...

i need this 80(numerical) towords as eighty,


i mean to convert from figures to words please advise the formula as soon as
possible .

Thanks for help in advance.


Regards,
Rajasekhar
9966353510

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

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

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

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

[rajasekhar praharaju]

hi friends,

i do have certain vba books will send you shortly.


Regards,
Raj

On Fri, Mar 26, 2010 at 2:37 PM, rajasekhar praharaju <
rajasekhar.prahar...@gmail.com> wrote:

>
>
> On Fri, Mar 26, 2010 at 1:26 PM,  wrote:
>
>> Hi
>> I have this book but will have to find the cd.
>>
>> I will try and send it this weekend
>>
>> Thanks
>>
>> Amitabh
>> --
>>
>> -Original Message-
>> From: anandydr 
>> Date: Thu, 25 Mar 2010 21:19:13
>> To: MS EXCEL AND VBA MACROS
>> Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by
>> John
>>Walkenbach.
>>
>> I've got a few ebooks on VBA with MS Excel though not the specific
>> book you mention. If you can use ebooks I can mail them to you.
>>
>> Anand
>>
>> On Mar 24, 12:59 pm, rf1234 rf1234  wrote:
>> > Dear Nani
>> > Check This Link Outhttp://
>> www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
>> >
>> > this link provide the basic vba concept with code.
>> > For the book you mension,i have to look it out.
>> >
>> > Hope it Will Help
>> > Happy To Help
>> > :)
>> > Shyam
>> >
>> > On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram <06n...@gmail.com> wrote:
>> > > Hi Excel Lovers.
>> >
>> > > Could any one have this book "Excel 2007 Power Programming with VBA"
>> by John
>> > > Walkenbach.
>> > > If not this book, can any one provide me material to learn basic VBA
>> on
>> > > Excel.
>> >
>> > > Thanks,
>> >
>> > > Naniram
>> >
>> > > --
>> > >
>> --
>> > > Some important links for excel users:
>> > > 1. Follow us on TWITTER for tips tricks and links :
>> > >http://twitter.com/exceldailytip
>> > > 2. Join our Facebook Group @
>> > >http://www.facebook.com/group.php?gid=287779555678
>> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > HELP US GROW !!
>> >
>> > > We reach over 6,800 subscribers worldwide and receive many nice notes
>> about
>> > > the learning and support from the group.Let friends and co-workers
>> know they
>> > > can subscribe to group at
>> > >http://groups.google.com/group/excel-macros/subscribe
>> >
>> > > To unsubscribe from this group, send email to
>> > > excel-macros+unsubscribegooglegroups.com or reply to this email with
>> the
>> > > words "REMOVE ME" as the subject.
>> >
>> > --
>> >
>> > Thanks Regards
>> > Shyam
>> > Software Engineer
>> >
>> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>> > When one door of happiness closes, another opens;
>> >  but often we look so long at the closed door that we do not see the
>> >  one which has been opened for u

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

[rajasekhar praharaju]

On Fri, Mar 26, 2010 at 1:26 PM,  wrote:

> Hi
> I have this book but will have to find the cd.
>
> I will try and send it this weekend
>
> Thanks
>
> Amitabh
> --
>
> -Original Message-
> From: anandydr 
> Date: Thu, 25 Mar 2010 21:19:13
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by
> John
>Walkenbach.
>
> I've got a few ebooks on VBA with MS Excel though not the specific
> book you mention. If you can use ebooks I can mail them to you.
>
> Anand
>
> On Mar 24, 12:59 pm, rf1234 rf1234  wrote:
> > Dear Nani
> > Check This Link Outhttp://
> www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
> >
> > this link provide the basic vba concept with code.
> > For the book you mension,i have to look it out.
> >
> > Hope it Will Help
> > Happy To Help
> > :)
> > Shyam
> >
> > On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram <06n...@gmail.com> wrote:
> > > Hi Excel Lovers.
> >
> > > Could any one have this book "Excel 2007 Power Programming with VBA" by
> John
> > > Walkenbach.
> > > If not this book, can any one provide me material to learn basic VBA on
> > > Excel.
> >
> > > Thanks,
> >
> > > Naniram
> >
> > > --
> > >
> --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe
> >
> > > To unsubscribe from this group, send email to
> > > excel-macros+unsubscribegooglegroups.com or reply to this email with
> the
> > > words "REMOVE ME" as the subject.
> >
> > --
> >
> > Thanks Regards
> > Shyam
> > Software Engineer
> >
> ''
> > When one door of happiness closes, another opens;
> >  but often we look so long at the closed door that we do not see the
> >  one which has been opened for us.
> > - Helen Keller
> >
> ''
> > Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> > aber oft schauen wir so lange auf die geschlossene Tür,
> >  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> >
> ''
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><>

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

[rajasekhar praharaju]

hi all please advise the how to find the row or coloum coloured cell . using
excell formula

i need to find the cell which is in colour.
cell colour should be known .


please help me out in this concern

Thanks in advance.
Raj
9966353510


On 6/26/09, Saravanan Anna  wrote:
>
> Try =proper() command
>
> Regards
>
> Saravanan A R
>
>
>  On Wed, Jun 24, 2009 at 1:40 PM, Subu  wrote:
>
>>
>> Dear List members and XL Gurus
>>
>> I have an XL sheet with a column that looks something like
>>
>> Name_One
>> nAme_two
>> NAME_THREE
>> name_four
>> name_fIVe
>> name   SIX
>> name sevEN
>>
>> ...and so on
>>
>>
>> I wish to get them all with the first Character in upper case and the
>> rest all in lower case
>>
>> I.e. something like
>>
>> Name_one
>> Name_two
>> Name_three
>> Name_four
>> Name_five
>> Name   six
>> Name seven
>>
>>
>> Thanks in advance
>> Best regards
>>
>> Subu
>> >>
>>

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

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