Re: $$Excel-Macros$$ hi

[Grkrishna Naidu]

hi

On Sun, Jun 26, 2016 at 10:37 AM, Grkrishna Naidu 
wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ hi all

[Ashish Kumar]

Hi Sunil,

PFA.!!


Regards
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/d/optout.


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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[kapil Gupta]

Is there any opening in MIS executive profile?.  Actually i also looking 
the job in same field.


Regards,
Kapil Gupta

On Tuesday, August 2, 2011 7:13:55 AM UTC+5:30, krishna mummina wrote:

 Sam

 Are you asking me or to whom you are referring to call you? Here is my 
 number : 09866902757

 On Tue, Aug 2, 2011 at 5:25 AM, Sam K sour...@gmail.com javascript:wrote:

 give me call at 12 tomorrow; or leave sms 028482

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 loveme...@gmail.comjavascript:
  wrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My 
 daily work includes working with excel, Creating General Reports, Pdf to 
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like, 
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS 
 Executive. I just want to know the exact qualification needed for the job. 
 I mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know 
 from you people,


 Thanking you and Waiting for your reply   - Krrish 

 -- 

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

 To post to this group, send email to excel-...@googlegroups.comjavascript:
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 -- 

 *
 *~~ With Best Regards ~~ *
 *~(Sourav.Kamra)~ *
 

  -- 

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

 To post to this group, send email to excel-...@googlegroups.comjavascript:
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[Surya Narayanan PV]

Hi sir I am currently working as Junior Software engineer/MIS for the past 
2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also 
generate reports as per the requirement, so do have an average knowledge in 
Excel. But I have to set my future career in MIS dept. so I would like your 
help in tuning up myself. Kindly advice me about what all things I should 
learn.

 

https://www.facebook.com/surya.narayanan.96387?ref=br_rsfref=browse_search

Regards,

Surya

On Monday, August 1, 2011 11:18:42 AM UTC+5:30, Venkat CV wrote:


 Welcome Krish

 On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina 
 loveme...@gmail.comjavascript:
  wrote:

 vijaykumar and venkat

 thank you very much for your valuable input.


 On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR 
 vijay...@gmail.comjavascript:
  wrote:

 Dear Krishna,


 The profile of MIS Executive changes with the type organisation.If it is 
 a small organisation MIS Executive role would be to prepare normal reports 
  like the work you do.If it is a big and reputed organisation your role in 
 addition to normal report preparation would be to do fianacial modelling or 
 creating financial model which would help the management in its decision 
 making process. For more information for using excel in financial modelling 
 u can refer to the website   www.exinfm.com.



 Regards,
 Vijaykumar
  

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 loveme...@gmail.comjavascript:
  wrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My 
 daily work includes working with excel, Creating General Reports, Pdf to 
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like, 
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS 
 Executive. I just want to know the exact qualification needed for the job. 
 I mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know 
 from you people,


 Thanking you and Waiting for your reply   - Krrish 

 -- 

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

 To post to this group, send email to 
 excel-...@googlegroups.comjavascript:
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 -- 









 P.VIJAY KUMAR
  
 -- 

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

 To post to this group, send email to excel-...@googlegroups.comjavascript:
  
 
 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-...@googlegroups.comjavascript:
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 -- 
 *Best Regards,*
 *Venkat*
 *Chennai*

  
  



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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[Surya Narayanan PV]

My Mail Id : surya.i...@gmail.com

On Thursday, May 8, 2014 1:49:39 AM UTC+5:30, Surya Narayanan PV wrote:

 Hi sir I am currently working as Junior Software engineer/MIS for the past 
 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also 
 generate reports as per the requirement, so do have an average knowledge in 
 Excel. But I have to set my future career in MIS dept. so I would like your 
 help in tuning up myself. Kindly advice me about what all things I should 
 learn.

  

 https://www.facebook.com/surya.narayanan.96387?ref=br_rsfref=browse_search

 Regards,

 Surya

 On Monday, August 1, 2011 11:18:42 AM UTC+5:30, Venkat CV wrote:


 Welcome Krish

 On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina loveme...@gmail.comwrote:

 vijaykumar and venkat

 thank you very much for your valuable input.


 On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay...@gmail.comwrote:

 Dear Krishna,


 The profile of MIS Executive changes with the type organisation.If it 
 is a small organisation MIS Executive role would be to prepare normal 
 reports  like the work you do.If it is a big and reputed organisation your 
 role in addition to normal report preparation would be to do fianacial 
 modelling or creating financial model which would help the management in 
 its decision making process. For more information for using excel in 
 financial modelling u can refer to the website   www.exinfm.com.



 Regards,
 Vijaykumar
  

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 loveme...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. 
 My daily work includes working with excel, Creating General Reports, Pdf 
 to 
 Excel Conversion, Data Mining and Analyzing data by using Data Tools 
 like, 
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS 
 Executive. I just want to know the exact qualification needed for the 
 job. 
 I mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know 
 from you people,


 Thanking you and Waiting for your reply   - Krrish 

 -- 

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

 To post to this group, send email to excel-...@googlegroups.com
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 -- 









 P.VIJAY KUMAR
  
 -- 

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

 To post to this group, send email to excel-...@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-...@googlegroups.com
  
 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 -- 
 *Best Regards,*
 *Venkat*
 *Chennai*

  
  



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

Re: $$Excel-Macros$$ hi

[pankaj MBA]

HELLO SATENDER,

WELCOME TO THIS GROUP AND SHARE YOUR QUERY

On Fri, Feb 14, 2014 at 9:03 AM, Satender Rawat satenderraw...@gmail.comwrote:


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




-- 
 Pankaj kumar choudhary
 B.sc.,B.COM,CIC,IIFT
 MBA FINANCE,
 MS FINANCE(PURSUING)
 9560340373

-- 
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$$ hi all***need code to attacha file in outlook and send it to respective email id***

[ashish koul]

try the attachment .. see if it helps



On Fri, Mar 29, 2013 at 10:37 PM, maksood alam 786maks...@gmail.com wrote:

 Hi all

 please send me the code to attach a file in outlook and send it to
 respective email address.


 Thanks
 Maksood alam

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






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on 
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/


P Before printing, think about the environment.

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




send Emails.xlsm
Description: Binary data

Re: $$Excel-Macros$$ hi there

[xlstime]

Hi Nik

first of all please use proper subject line and which type database format
you want i..e... Finance or customer record database type

please specify


.

Enjoy
Team XLS



On Thu, Mar 7, 2013 at 10:26 PM, nm nms8...@gmail.com wrote:

 Sir,

 i m into real estate business and want to create a data base.

 1) want to have a data base for my business with all the detail and where
 i can also add some field as per my requirement.

 2) further i want to use the said data base for my website too, i m
 planing to have my website ( if any one can recommend or help for the
 website shall also be appreciated)

 3) anyone having the ready format of the data base.


 thanks

 Nik.


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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ hi there

[nm]

sir,

pl accept my apology i m begineer in the group, and not familier with excel
progarmming too.

i need customer recoed database.

Thanks

NIK.


On Thu, Mar 7, 2013 at 11:10 PM, xlstime xlst...@gmail.com wrote:

 Hi Nik

 first of all please use proper subject line and which type database format
 you want i..e... Finance or customer record database type

 please specify


 .

 Enjoy
 Team XLS



 On Thu, Mar 7, 2013 at 10:26 PM, nm nms8...@gmail.com wrote:

 Sir,

 i m into real estate business and want to create a data base.

 1) want to have a data base for my business with all the detail and where
 i can also add some field as per my requirement.

 2) further i want to use the said data base for my website too, i m
 planing to have my website ( if any one can recommend or help for the
 website shall also be appreciated)

 3) anyone having the ready format of the data base.


 thanks

 Nik.


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

 FORUM RULES

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

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




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

 FORUM RULES

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

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




-- 
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$$ hi friends i want courier management data format in excel

[xlstime]

please share required field


.

Enjoy
Team XLS



On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.com wrote:

 hi friends i want courier management data format in excel


 regards
 kannan

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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

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

pls share the data

On Wed, Mar 6, 2013 at 2:45 PM, xlstime xlst...@gmail.com wrote:

 please share required field


 .

 Enjoy
 Team XLS



 On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.comwrote:

 hi friends i want courier management data format in excel


 regards
 kannan

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






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

-- 
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$$ hi friends i want courier management data format in excel

[Kuldeep Singh]

Hi Kannan,

PFA..

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Wed, Mar 6, 2013 at 2:49 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote:

 pls share the data


 On Wed, Mar 6, 2013 at 2:45 PM, xlstime xlst...@gmail.com wrote:

 please share required field


 .

 Enjoy
 Team XLS



 On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.comwrote:

 hi friends i want courier management data format in excel


 regards
 kannan

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






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

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

 FORUM RULES

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

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


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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the 

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

[Kuldeep Singh]

Hi Gawli Anil,

Please check all mails. It's Kannan (kannan.ex...@gmail.com) Query. I have
no query. I am happy to help.

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Wed, Mar 6, 2013 at 3:01 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote:

 Dear Kuldeep,

 Pl provide proper query. What do you want??

 Warm Regards,
 Gawli Anil

 On Wed, Mar 6, 2013 at 2:54 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 Hi Kannan,

 PFA..

 Regards,
 Kuldeep Singh
 Info Edge India Limited (naukri.com)
 Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
 naukrikuld...@gmail.com || www.naukri.com
 *Please* *Consider the environment. Please don't print this e-mail
 unless you really need to.*

 On Wed, Mar 6, 2013 at 2:49 PM, अनिल नारायण गवली gawlianil8...@gmail.com
  wrote:

 pls share the data


 On Wed, Mar 6, 2013 at 2:45 PM, xlstime xlst...@gmail.com wrote:

 please share required field


 .

 Enjoy
 Team XLS



 On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.comwrote:

 hi friends i want courier management data format in excel


 regards
 kannan

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






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

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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[sundarmohan V S]

Hi Sir,

Myself sundar from chennai, First i would appreciate on your brief 
explanation for MIS role, it is very clear to understand.
 i have been working as HR for past 3 Years, but my role as HR is not 
satisfying me. I was looking for a change where i don't interact with 
people much, and so i came across MIS Executive Job profile. 
I just need you to advice me whether this MIS Role will suit me. Pl advice

I did my BSc in Biotech and then i did my MBA and got into HR (Being a HR i 
play a role of Joker between Orga.. and Emp.. I lack my real skill to prove 
myself)
I m pretty good in excel and i have little analytical skill too (I believe)
So i need you to advice me please

Regards
Sundar

On Tuesday, July 26, 2011 4:28:15 PM UTC+5:30, Anand Kumar wrote:

 Hi, 

 In case of MIS Executives the kind of the data sets is very rigid. The 
 data is always in the same format. Mostly the amount of data would 
 also be the same every day/week. The frequency of reports would be 
 also same for them, i.e. the MIS is generated on a weekly, daily or 15 
 days or quarterly basis. The data is extracted from a source which is 
 set by a business analyst beforehand and should not or is not 
 manipulated without prior permission. Considering all this we can 
 conclude: 

 1. MIS Executive is Good at Excel functions like Lookup, Vlookup and 
 Hlookup 
 2. He/She has some knowledge of pivot tables and data extraction. 
 3. He/She can work comfortably on data sets of around 20,000 rows and 
 200 colums (approx) 
 4. He/She should have some knowledge of text manipulation functions 
 (Concatenate, len, find, left, right etc). 
 5. He/She should be comfortable using combination of functions e.g. 
 extract first name from email id in cell A1 when A1 contains 
 anan...@gmail.com javascript: 
 6. He/She should be able to use logical functions 
 7. Should be able to use error handling functions available in MS 
 Excel. 
 8. Last but not the least WILLINGNESS TO LEARN. 

 Warm regards, 
 Anand Kumar.

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

[NOORAIN ANSARI]

Dear Rajat,

You have been added successfully in excel-macros group,
Please check and confirm.



-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com

On Thu, Dec 27, 2012 at 9:57 PM, rajat arora
rajatarora_air...@yahoo.co.inwrote:

 rajat198...@yahoo.com



http://www.excelvbaclinic.blogspot.com

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Hi

[NOORAIN ANSARI]

Mihael, Please post ur excel macro query

On Thu, Jun 14, 2012 at 8:39 AM, Michael Brumby mikebru...@yahoo.comwrote:


 this is crazy you should check the out
 http://www.business15canews.net/work/?read=5074813

 --
 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,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Rajan_Verma]

Yes, you can give comma separated email list.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 31 May 2012 10:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear Rajan,

  thats a very great vb code that you have shared to us, Thank you ver much.
can you please tell me, if i want to send more then 1 person, what i need to
do. 

i have to insert comma after every mail ID ?


 

Thanks  Regards,
Deba Ranjan P

 





On Wed, May 30, 2012 at 9:13 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:

Hi Deba,

 

See the attached Unprotected Version

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 30 May 2012 9:56


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Sir, i dont have any tool for breaking password. If you have any set up you
can let me know, or else, Please share the file without password. thank you
Rajan Sir.


 

Thanks  Regards,
Deba Ranjan P

 

 

On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:

 

Sorry I forget that  password L if you have any tool to break the password
will be good for you J

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 29 May 2012 10:11


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear Rajan,

   The file that you have shared is quite awesome. Can you please share us
the coding too as you have protect the code with password. i Think it will
be a great contribution form you side to the fellow members in this forum.
Great job. thanks for sharing such experience.

 

Thanks  Regards,
Deba Ranjan P

 

 

On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:

Just give the front end.
how you want to attached the file.. where you will put the Email ID and so
on

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of t vinay
Sent: 28 May 2012 7:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Hi Rajan,

 

this is excellent, can you help with the code that you have used. as my
requirement is on the same line.

On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

Try My Excel Outlook J

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Renukachari Kasee
Sent: 17 May 2012 5:24
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear experts

 

Excel macro for sendin outlook emails from Specific Templet With Attachments
formats  of .PDF  .htm

 

Thanks in Advance

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Deba Ranjan]

Dear Rajan,

  thats a very great vb code that you have shared to us, Thank you ver
much. can you please tell me, if i want to send more then 1 person, what i
need to do.

i have to insert comma after every mail ID ?


Thanks  Regards,
*Deba Ranjan P*





On Wed, May 30, 2012 at 9:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 Hi Deba,

 ** **

 See the attached Unprotected Version

 ** **

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
 *Sent:* 30 May 2012 9:56

 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

 ** **

 Sir, i dont have any tool for breaking password. If you have any set up
 you can let me know, or else, Please share the file without password. thank
 you Rajan Sir.
 

  

 Thanks  Regards,
 *Deba Ranjan P*

 ** **



 

 On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma rajanverma1...@gmail.com
 wrote:

  

 Sorry I forget that  password L if you have any tool to break the
 password will be good for you J

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
 *Sent:* 29 May 2012 10:11


 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Dear Rajan,

The file that you have shared is quite awesome. Can you please share us
 the coding too as you have protect the code with password. i Think it will
 be a great contribution form you side to the fellow members in this forum.
 Great job. thanks for sharing such experience.

  

 Thanks  Regards,
 *Deba Ranjan P*

  

 ** **

 On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma rajanverma1...@gmail.com
 wrote:

 Just give the front end.
 how you want to attached the file.. where you will put the Email ID and so
 on

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *t vinay
 *Sent:* 28 May 2012 7:47
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Hi Rajan,

  

 this is excellent, can you help with the code that you have used. as my
 requirement is on the same line.

 On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

 Try My Excel Outlook J

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee
 *Sent:* 17 May 2012 5:24
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Dear experts

  

 Excel macro for sendin outlook emails from Specific Templet With
 Attachments formats  of .PDF  .htm

  

 Thanks in Advance

  

  

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

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

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

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

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

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

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


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

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

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

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

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

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

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

 NOTE : Don't ever post personal

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Rajan_Verma]

 

Sorry I forget that  password L if you have any tool to break the password
will be good for you J

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 29 May 2012 10:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear Rajan,

   The file that you have shared is quite awesome. Can you please share us
the coding too as you have protect the code with password. i Think it will
be a great contribution form you side to the fellow members in this forum.
Great job. thanks for sharing such experience.



 

Thanks  Regards,
Deba Ranjan P

 





On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:

Just give the front end.
how you want to attached the file.. where you will put the Email ID and so
on

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of t vinay
Sent: 28 May 2012 7:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Hi Rajan,

 

this is excellent, can you help with the code that you have used. as my
requirement is on the same line.

On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

Try My Excel Outlook J

 

 

Regards

Rajan verma

+91 7838100659 tel:%2B91%207838100659  [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Renukachari Kasee
Sent: 17 May 2012 5:24
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear experts

 

Excel macro for sendin outlook emails from Specific Templet With Attachments
formats  of .PDF  .htm

 

Thanks in Advance

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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





 

-- 

Regards,

 

Vinay. T

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Deba Ranjan]

Sir, i dont have any tool for breaking password. If you have any set up you
can let me know, or else, Please share the file without password. thank you
Rajan Sir.


Thanks  Regards,
*Deba Ranjan P*





On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 ** **

 Sorry I forget that  password L if you have any tool to break the
 password will be good for you J

 ** **

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
 *Sent:* 29 May 2012 10:11

 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

 ** **

 Dear Rajan,

The file that you have shared is quite awesome. Can you please share us
 the coding too as you have protect the code with password. i Think it will
 be a great contribution form you side to the fellow members in this forum.
 Great job. thanks for sharing such experience.

 

  

 Thanks  Regards,
 *Deba Ranjan P*

 ** **



 

 On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma rajanverma1...@gmail.com
 wrote:

 Just give the front end.
 how you want to attached the file.. where you will put the Email ID and so
 on

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *t vinay
 *Sent:* 28 May 2012 7:47
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Hi Rajan,

  

 this is excellent, can you help with the code that you have used. as my
 requirement is on the same line.

 On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

 Try My Excel Outlook J

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee
 *Sent:* 17 May 2012 5:24
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Dear experts

  

 Excel macro for sendin outlook emails from Specific Templet With
 Attachments formats  of .PDF  .htm

  

 Thanks in Advance

  

  

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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



 

  

 -- 

 Regards,

  

 Vinay. T

  

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

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[t vinay]

Hi Rajan,

this is excellent, can you help with the code that you have used. as my
requirement is on the same line.

On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

 Try My Excel Outlook J

 ** **

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee
 *Sent:* 17 May 2012 5:24
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

 ** **

 Dear experts

  

 Excel macro for sendin outlook emails from Specific Templet With
 Attachments formats  of .PDF  .htm

  

 Thanks in Advance

  

  

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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




-- 
Regards,

Vinay. T

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Rajan_Verma]

Just give the front end.
how you want to attached the file.. where you will put the Email ID and so
on

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of t vinay
Sent: 28 May 2012 7:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Hi Rajan,

 

this is excellent, can you help with the code that you have used. as my
requirement is on the same line.

On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

Try My Excel Outlook J

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Renukachari Kasee
Sent: 17 May 2012 5:24
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook
emails sending Specific Templet With Attachments formats of .PDF  .htm

 

Dear experts

 

Excel macro for sendin outlook emails from Specific Templet With Attachments
formats  of .PDF  .htm

 

Thanks in Advance

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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





 

-- 

Regards,

 

Vinay. T

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

[Deba Ranjan]

Dear Rajan,

   The file that you have shared is quite awesome. Can you please share us
the coding too as you have protect the code with password. i Think it will
be a great contribution form you side to the fellow members in this forum.
Great job. thanks for sharing such experience.



Thanks  Regards,
*Deba Ranjan P*





On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 Just give the front end.
 how you want to attached the file.. where you will put the Email ID and so
 on

 ** **

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *t vinay
 *Sent:* 28 May 2012 7:47
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

 ** **

 Hi Rajan,

 ** **

 this is excellent, can you help with the code that you have used. as my
 requirement is on the same line.

 On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote:

 Try My Excel Outlook J

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee
 *Sent:* 17 May 2012 5:24
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for
 outlook emails sending Specific Templet With Attachments formats of .PDF 
 .htm

  

 Dear experts

  

 Excel macro for sendin outlook emails from Specific Templet With
 Attachments formats  of .PDF  .htm

  

 Thanks in Advance

  

  

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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



 

 ** **

 -- 

 Regards,

  

 Vinay. T

 ** **

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

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

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

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

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

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

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


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

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

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

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

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

 4) Acknowledge the responses you receive

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

[dguillett1]

Google is your friend.

excel version differences

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: Divaker Pandey 
Sent: Monday, March 05, 2012 8:53 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this 
question.

Hi Expert,

Can anyone list out different between Excel 2003,2007 and 2010.

1. Basis of Basic Enhancement.
2. Advanced Enhancement.
3.VBA Object Enhancement
4. Macros Enhancement

Really, if you expert spend you few minute to give you comment on your level, 
it may be great learning for each and everyone member of this blogger.

thanks in advance for your precious contribution.

Divaker

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

[Divaker Pandey]

yeah, that is true. Google is our universal friend.

but it will be awesome if group members  got list of  real time problem, or
difference expert faces during use of different versions of excel.


Divaker


On Mon, Mar 5, 2012 at 8:43 PM, dguillett1 dguille...@gmail.com wrote:

   Google is your friend.

 excel version differences

 Don Guillett
 Microsoft MVP Excel
 SalesAid Software
 dguille...@gmail.com

  *From:* Divaker Pandey divake...@gmail.com
 *Sent:* Monday, March 05, 2012 8:53 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Hi Expert- please spend your few minute only
 on this question.

 Hi Expert,

 Can anyone list out different between Excel 2003,2007 and 2010.

 1. Basis of Basic Enhancement.
 2. Advanced Enhancement.
 3.VBA Object Enhancement
 4. Macros Enhancement

 Really, if you expert spend you few minute to give you comment on your
 level, it may be great learning for each and everyone member of this
 blogger.

 thanks in advance for your precious contribution.

 Divaker

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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


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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[xlstime]

if i am not wrong u can use CALL macro function

On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer mmun...@ccc.com.qawrote:

  How to merge the Multiple Macro’s in single program?

 My question is little jovial – but still it is trying to learn some thing
 from u masters. Thanx anyway

 ** **

 This is only an example, that I put it here to show u exactly what I want
 u to help me for. ( in fact, I need the logic – How I can merge the
 multiple macros to form a single programming code).

 Or else u can do a help by providing me with any website like this that
 can fetch me the right/full explanation about the steps involved in doing
 so?

 ** **

 

 ** **

 ** **

 If my data is like this: (with Filter buttons are on): (filtering process
 taken up in anyway with the help of the “*Cell*” reference (or) “*Button*”.
 Its u r choice)…..

 ** **

 *Ename*

 *Start Date*

 *End Date*

 *Hours wor*

 *Tot pay*

 *Ded*

 *Net pay*

 *AA*

 1-Jan-12

 31-Jan-12

   40.0 

  2,600.0 

   650.0 

 *1,950.0 *

 *BB*

 1-Jan-12

 31-Jan-12

   45.0 

  1,800.0 

   450.0 

 *1,350.0 *

 *CC*

 1-Jan-12

 31-Jan-12

   32.0 

  1,472.0 

   368.0 

 *1,104.0 *

 *DD*

 1-Jan-12

 31-Jan-12

   60.0 

  2,100.0 

   525.0 

 *1,575.0 *

 *EE*

 1-Jan-12

 31-Jan-12

   52.0 

  1,664.0 

   416.0 

 *1,248.0 *

 *FF*

 1-Jan-12

 31-Jan-12

   80.0 

  2,000.0 

   500.0 

 *1,500.0 *

 ** **

 ** **

 ** **

 *309.0 *

 *   11,636.0 *

 *   2,909.0 *

 *8,727.0 *

 ** **

 Regards,

 Muneer,

 CC...

 ** **

 ** **

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

Re: $$Excel-Macros$$ Hi, Friends I have a ?

[xlstime]

Hi Mohammed Muneer,

you must be use proper subject line or Use concise, accurate thread titles.
for get quick attention or answered.


On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer mmun...@ccc.com.qawrote:

  How to merge the Multiple Macro’s in single program?

 ** **

 ** **

 

 ** **

 ** **

 If my data is like this: (with Filter buttons are on): (filtering process
 taken up in anyway with the help of the “*Cell*” reference (or) “*Button*”.
 Its u r choice)…..

 ** **

 *Ename*

 *Start Date*

 *End Date*

 *Hours wor*

 *Tot pay*

 *Ded*

 *Net pay*

 *AA*

 1-Jan-12

 31-Jan-12

   40.0 

  2,600.0 

   650.0 

 *1,950.0 *

 *BB*

 1-Jan-12

 31-Jan-12

   45.0 

  1,800.0 

   450.0 

 *1,350.0 *

 *CC*

 1-Jan-12

 31-Jan-12

   32.0 

  1,472.0 

   368.0 

 *1,104.0 *

 *DD*

 1-Jan-12

 31-Jan-12

   60.0 

  2,100.0 

   525.0 

 *1,575.0 *

 *EE*

 1-Jan-12

 31-Jan-12

   52.0 

  1,664.0 

   416.0 

 *1,248.0 *

 *FF*

 1-Jan-12

 31-Jan-12

   80.0 

  2,000.0 

   500.0 

 *1,500.0 *

 ** **

 ** **

 ** **

 *309.0 *

 *   11,636.0 *

 *   2,909.0 *

 *8,727.0 *

 ** **

 Regards,

 Muneer,

 CC...

 ** **

 ** **

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

RE: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[Asa Rossoff]

Hello Mohammed,

Agree on the subject line bit.. please use a short decsriptive subject line
- and best not to change the subject line if you post again, it can be more
difficult for others to follow the thread.

 

To your question:  the main part How to merge the multiple macros in single
program? - I understand that question. but I don't understand what your
sample data that looks like payroll records has to do with it.  Or what
filtering the payroll data in various ways has to do with it.

 

CALL is a VBA/macro command, as xlstime says that can execute other
VBA/macro procedures.  But, CALL is optional an usually not used. It is as
simple as typing the name of another sub procedure as in this example, which
doesn't use call:

 

Sub Macro1234 ()

'Execute Macro1 if user hits Yes button.

If MsgBox(Execute Macro1?,vbYesNo)=vbYes Then Macro1

'Execute Macro2 if userr hits Yes button.

If MsgBox(Execute Macro2?,vbYesNo)=vbYes Then Macro2

'Execute Macro3 if user hits Yes button.

If MsgBox(Execute Macro3?,vbYesNo)=vbYes Then Macro3

'Execute Macro4 no matter what!!!

Macro4

End Sub

 

Sub Macro1 ()

MsgBox MACRO 1 !

End Sub

 

Sub Macro2 ()

MsgBox MACRO 2!

End Sub

 

Sub Macro3 ()

MsgBox MACRO 3 !

End Sub

 

Sub Macro4 ()

MsgBox MACRO 4 !

End Sub

 

Hope this helps.

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of xlstime
Sent: Monday, February 20, 2012 12:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express
properly in my previous mail - so let us have it right now)

 

if i am not wrong u can use CALL macro function 

On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer mmun...@ccc.com.qa
wrote:

How to merge the Multiple Macro's in single program?

My question is little jovial - but still it is trying to learn some thing
from u masters. Thanx anyway

 

This is only an example, that I put it here to show u exactly what I want u
to help me for. ( in fact, I need the logic - How I can merge the multiple
macros to form a single programming code).

Or else u can do a help by providing me with any website like this that can
fetch me the right/full explanation about the steps involved in doing so?

 



 

 

If my data is like this: (with Filter buttons are on): (filtering process
taken up in anyway with the help of the Cell reference (or) Button. Its
u r choice)...

 


Ename

Start Date

End Date

Hours wor

Tot pay

Ded

Net pay


AA

1-Jan-12

31-Jan-12

  40.0 

 2,600.0 

  650.0 

1,950.0 


BB

1-Jan-12

31-Jan-12

  45.0 

 1,800.0 

  450.0 

1,350.0 


CC

1-Jan-12

31-Jan-12

  32.0 

 1,472.0 

  368.0 

1,104.0 


DD

1-Jan-12

31-Jan-12

  60.0 

 2,100.0 

  525.0 

1,575.0 


EE

1-Jan-12

31-Jan-12

  52.0 

 1,664.0 

  416.0 

1,248.0 


FF

1-Jan-12

31-Jan-12

  80.0 

 2,000.0 

  500.0 

1,500.0 


 

 

 

309.0 

   11,636.0 

   2,909.0 

8,727.0 

 

Regards,

Muneer,

CC...

 

 

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

Re: $$Excel-Macros$$ Hi friends, now its clear.....

[Sam Mathai Chacko]

Just a thought. Are you trying to say that if there is a common word in all
the lines, you need to know that word?

Example

I let you go
Let me in
Who let the dogs out
To let

and you need the value in your first column to be '*let*'?

I'd say caramba! if that's the case


And Excel_Lover, you need to add in error condition, otherwise it will
error out when there is no 'cell' in the text. Check Noorain's solution
where he suggested using IFERROR along with the SEARCH function.

Regards,
Sam Mathai Chacko


On Tue, Feb 7, 2012 at 11:15 AM, Excel_Lover idforex...@gmail.com wrote:

 =IF(FIND(cell,E13),cell,)


 On Tue, Feb 7, 2012 at 8:38 AM, Mohammed Muneer mmun...@ccc.com.qawrote:

 ** **

 *del** cell   *

 *bel cell del*

 *cell bel del*

 *cell ell llec*

 *blood consist of red cell and white cell*

 *simos is a cell*

 *max cell*

 *sony cell*

 *a cell is a source of energy for some electronic devices and stands as
 a two way power.*

 ** **

 Above mentioned lines are having the word “cell” in common, Ok I want to
 extract the same in the cell beside (the highlighted).

 For example, we are at first line *del** cell *and if I can do
 this to extract the word *cell.*

 * *

 cell

 del cell

 cell

 bel cell del

 cell

 cell bel del

 cell

 cell ell llec

 cell

 blood consist of red cell and white cell

 cell

 simos is a cell

 cell

 max cell

 cell

 sony cell

 cell

 a cell is a source of energy for some electronic devices and stands as a
 two way power.

 ** **

 ** **

 Regards,

 Muneer,

 CC...

 ** **

 ** **

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




-- 
Sam Mathai Chacko

-- 
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$$ hi can you solve this

[NOORAIN ANSARI]

Hi Renuka,

Can you more explain your query..


Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee jva.ch...@gmail.comwrote:


 *(¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!!
 `•.¸.•´
 Thanks  Regards´¨)
   ¸ •´ ¸.•*´¨)   ¸.•*¨)
  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
 * *
 *P Let us do our best to save nature, save water, plant trees, protect
 greenery, keep our surroundings clean, reduce usage of plastics, and use
 renewable energy sources.*

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

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

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

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

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

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

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


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




--

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ hi can you solve this

[Maries]

Hi Renuka,

Please find the attached file. I have used the below formula to solve.

=SMALL(IF(D2:D11=G2,D2:D11),{7,6,5,4,3,2})

Regards,

MARIES.

On Thu, Dec 8, 2011 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Hi Renuka,

 Can you more explain your query..


 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

 On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee jva.ch...@gmail.comwrote:


 *(¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!!
 `•.¸.•´
 Thanks  Regards´¨)
   ¸ •´ ¸.•*´¨)   ¸.•*¨)
  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
 * *
 *P Let us do our best to save nature, save water, plant trees, protect
 greenery, keep our surroundings clean, reduce usage of plastics, and use
 renewable energy sources.*

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

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

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

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

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

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

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


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




 --

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

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

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

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

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

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

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


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


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

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

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

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

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

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

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

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


Solved By Maries 08.12.2011.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Hi

[STDEV(i)]

http://chrisrae.com/vba/whatisvba.html
http://www.excel-vba.com/
http://www.excel-vba-easy.com/
http://www.youtube.com/watch?v=t1vdt0FddsE


On Fri, Aug 26, 2011 at 10:24 PM, Mohamed Youssouf 
youssouf.mohame...@gmail.com wrote:

 I'd like to learn how ti use MACRO

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

[Venkat CV]

Hi,

See below links..
http://www.excel-vba.com/
http://www.ozgrid.com/VBA/
http://excelvbatutor.com/

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Fri, Aug 26, 2011 at 8:54 PM, Mohamed Youssouf 
youssouf.mohame...@gmail.com wrote:

 I'd like to learn how ti use MACRO

 --

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

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

[Rajan_Verma]

You can Visit these sites :

www.ozgrid.com
www.cpearson.com
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
www.akoul.blogspot.com
www.excelpoweruser.com
www.ozgrid.com
akoul.posterous.com
www.mrexcel.com
www.contextures.com
www.rondebruin.nl
peltiertech.com
chandoo.org 
www.mvps.org/links.html
www.vbaexpress.com
www.functionx.com
www.freevbcode.com
www.excelforum.com
https://www.facebook.com/ExcelLover
https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897
https://www.facebook.com/microsoftexcel
https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2;
ref=ts
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o
nline/

Rajan.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohamed Youssouf
Sent: Friday, August 26, 2011 8:54 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Hi

I'd like to learn how ti use MACRO

-- 

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

[Sam K]

give me call at 12 tomorrow; or leave sms 028482

On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS Executive.
 I just want to know the exact qualification needed for the job. I mean, what
 are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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




-- 

*
*~~ With Best Regards ~~ *
*~(Sourav.Kamra)~ *


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

[krishna mummina]

Sam

Are you asking me or to whom you are referring to call you? Here is my
number : 09866902757

On Tue, Aug 2, 2011 at 5:25 AM, Sam K soura...@gmail.com wrote:

 give me call at 12 tomorrow; or leave sms 028482

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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




 --

 *
 *~~ With Best Regards ~~ *
 *~(Sourav.Kamra)~ *
 

  --

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

 To 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$$ Hi - Details needed for the MIS Executive Qualification

[krishna mummina]

Thank you very much for the links. Most of them are just a normal reports
like using the basic formulas. Is this is all about MIS Executive role to
create the reports like this?

Waiting for your reply - krrish

On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote:

 Please find the below links

 http://www.citesales.com/
 http://www.ksde.org/Default.aspx?tabid=2836


 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Thank you very much for the total input guys.

 Now, I just want to see some of the example reports and some excel sheets.
 Is there any site to find those reports etc..?

 Waiting for your kind reply - krrish


 On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas 
 venkateshs@gmail.com wrote:

 I some how feel he need to know a bit of database basics...


- Clean and organize the database before working on it...
- Ensure to know the compatible formula- other features based on
version and its disadvantages

 Regards
 Venkatesh
 +91 9841969353


  On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote:

 Hey

 Please find  below link

 http://en.wikipedia.org/wiki/Management_information_system

  On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.com wrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the 
 job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know
 from you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

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

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




 --
 .


 --

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

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

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




 --

 Regards
 Venkatesh KS
 Phone: +91 98419 69353

   --

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

 To 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 

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[Venkat CV]

Hi Kirish,

Just go to Linked in and search MIS Executive and see what are
all responsibilities and then you may get clear Picture what they are
doing...

*Best Regards,*
*Venkat*
*Chennai*

On Sat, Jul 30, 2011 at 11:41 AM, krishna mummina
lovemekris...@gmail.comwrote:

 Thank you very much for the links. Most of them are just a normal reports
 like using the basic formulas. Is this is all about MIS Executive role to
 create the reports like this?

 Waiting for your reply - krrish

 On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote:

 Please find the below links

 http://www.citesales.com/
 http://www.ksde.org/Default.aspx?tabid=2836


 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.com
  wrote:

 Thank you very much for the total input guys.

 Now, I just want to see some of the example reports and some excel
 sheets. Is there any site to find those reports etc..?

 Waiting for your kind reply - krrish


 On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas 
 venkateshs@gmail.com wrote:

 I some how feel he need to know a bit of database basics...


- Clean and organize the database before working on it...
- Ensure to know the compatible formula- other features based on
version and its disadvantages

 Regards
 Venkatesh
 +91 9841969353


  On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote:

 Hey

 Please find  below link

 http://en.wikipedia.org/wiki/Management_information_system

  On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.com wrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years.
 My daily work includes working with excel, Creating General Reports, Pdf 
 to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools 
 like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the 
 job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know
 from you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

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

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




 --
 .


 --

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

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

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




 --

 Regards
 Venkatesh KS
 Phone: +91 98419 69353

   --

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

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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[krishna mummina]

vijaykumar and venkat

thank you very much for your valuable input.

On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Dear Krishna,


 The profile of MIS Executive changes with the type organisation.If it is a
 small organisation MIS Executive role would be to prepare normal reports
  like the work you do.If it is a big and reputed organisation your role in
 addition to normal report preparation would be to do fianacial modelling or
 creating financial model which would help the management in its decision
 making process. For more information for using excel in financial modelling
 u can refer to the website   www.exinfm.com.



 Regards,
 Vijaykumar


 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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




 --









 P.VIJAY KUMAR

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[XLS S]

Please find the below links

http://www.citesales.com/
http://www.ksde.org/Default.aspx?tabid=2836

On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.comwrote:

 Thank you very much for the total input guys.

 Now, I just want to see some of the example reports and some excel sheets.
 Is there any site to find those reports etc..?

 Waiting for your kind reply - krrish


 On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas 
 venkateshs@gmail.com wrote:

 I some how feel he need to know a bit of database basics...


- Clean and organize the database before working on it...
- Ensure to know the compatible formula- other features based on
version and its disadvantages

 Regards
 Venkatesh
 +91 9841969353


 On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote:

 Hey

 Please find  below link

 http://en.wikipedia.org/wiki/Management_information_system

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.com wrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. 
 I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know
 from you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

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

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




 --
 .


  --

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

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

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




 --

 Regards
 Venkatesh KS
 Phone: +91 98419 69353

  --

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

 To 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$$ Hi - Details needed for the MIS Executive Qualification

[Venkat CV]

Hi Krish,

MIS Executive  Role also Same kind of role as you now doing...Reports
generation  Data Management activities 
*Best Regards,*
*Venkat*
*Chennai*


On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS Executive.
 I just want to know the exact qualification needed for the job. I mean, what
 are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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$$ Hi - Details needed for the MIS Executive Qualification

[krishna mummina]

Thank you venkat,

Report Generation and Data Management?

If you have some examples, can you please provide those?

Thanks in advance,
Krrish

On Tue, Jul 26, 2011 at 11:57 AM, Venkat CV venkat1@gmail.com wrote:

 Hi Krish,

 MIS Executive  Role also Same kind of role as you now doing...Reports
 generation  Data Management activities 
  *Best Regards,*
 *Venkat*
 *Chennai*


 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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$$ Hi - Details needed for the MIS Executive Qualification

[anandydr]

Hi,

In case of MIS Executives the kind of the data sets is very rigid. The
data is always in the same format. Mostly the amount of data would
also be the same every day/week. The frequency of reports would be
also same for them, i.e. the MIS is generated on a weekly, daily or 15
days or quarterly basis. The data is extracted from a source which is
set by a business analyst beforehand and should not or is not
manipulated without prior permission. Considering all this we can
conclude:

1. MIS Executive is Good at Excel functions like Lookup, Vlookup and
Hlookup
2. He/She has some knowledge of pivot tables and data extraction.
3. He/She can work comfortably on data sets of around 20,000 rows and
200 colums (approx)
4. He/She should have some knowledge of text manipulation functions
(Concatenate, len, find, left, right etc).
5. He/She should be comfortable using combination of functions e.g.
extract first name from email id in cell A1 when A1 contains
anand...@gmail.com
6. He/She should be able to use logical functions
7. Should be able to use error handling functions available in MS
Excel.
8. Last but not the least WILLINGNESS TO LEARN.

Warm regards,
Anand Kumar.

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


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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[krishna mummina]

Thank you very much sir,

Really very detailed explanation. Once again Thank you very much.

On Tue, Jul 26, 2011 at 4:28 PM, anandydr ananad...@gmail.com wrote:

 Hi,

 In case of MIS Executives the kind of the data sets is very rigid. The
 data is always in the same format. Mostly the amount of data would
 also be the same every day/week. The frequency of reports would be
 also same for them, i.e. the MIS is generated on a weekly, daily or 15
 days or quarterly basis. The data is extracted from a source which is
 set by a business analyst beforehand and should not or is not
 manipulated without prior permission. Considering all this we can
 conclude:

 1. MIS Executive is Good at Excel functions like Lookup, Vlookup and
 Hlookup
 2. He/She has some knowledge of pivot tables and data extraction.
 3. He/She can work comfortably on data sets of around 20,000 rows and
 200 colums (approx)
 4. He/She should have some knowledge of text manipulation functions
 (Concatenate, len, find, left, right etc).
 5. He/She should be comfortable using combination of functions e.g.
 extract first name from email id in cell A1 when A1 contains
 anand...@gmail.com
 6. He/She should be able to use logical functions
 7. Should be able to use error handling functions available in MS
 Excel.
 8. Last but not the least WILLINGNESS TO LEARN.

 Warm regards,
 Anand Kumar.

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Hi Everybody

[XLS S]

Hey,

Please register and download any HR related MIS report

http://www.citehr.com/

On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya mail2sanja...@gmail.comwrote:

 Hi

 All friends if u have these type others MIS Report file for Sales
 Department and Finance Department Please forward me.

 --
 ***Thanks
 Sanjay Kumar Maurya*

  --

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

 To 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$$ Hi - Details needed for the MIS Executive Qualification

[XLS S]

Hey

Please find  below link

http://en.wikipedia.org/wiki/Management_information_system

On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS Executive.
 I just want to know the exact qualification needed for the job. I mean, what
 are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

 To 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$$ Hi Everybody

[Dilip Pandey]

Nice portal and it is offering more solutions related to HR, not just
MIS reports..

Thanks,
DILIPandey

On 7/27/11, XLS S xlst...@gmail.com wrote:
 Hey,

 Please register and download any HR related MIS report

 http://www.citehr.com/

 On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya
 mail2sanja...@gmail.comwrote:

 Hi

 All friends if u have these type others MIS Report file for Sales
 Department and Finance Department Please forward me.

 --
 ***Thanks
 Sanjay Kumar Maurya*

  --

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

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

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




 --
 .

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

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

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



-- 
Thanks  Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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


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

Re: $$Excel-Macros$$ Hi Everybody

[XLS S]

yes Dilip sir, its really very good sit for all type hr related
document...



On Wed, Jul 27, 2011 at 9:46 AM, Dilip Pandey dilipan...@gmail.com wrote:

 Nice portal and it is offering more solutions related to HR, not just
 MIS reports..

 Thanks,
 DILIPandey

 On 7/27/11, XLS S xlst...@gmail.com wrote:
  Hey,
 
  Please register and download any HR related MIS report
 
  http://www.citehr.com/
 
  On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya
  mail2sanja...@gmail.comwrote:
 
  Hi
 
  All friends if u have these type others MIS Report file for Sales
  Department and Finance Department Please forward me.
 
  --
  ***Thanks
  Sanjay Kumar Maurya*
 
   --
 
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 
 
 
 
  --
  .
 
  --
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 


 --
 Thanks  Regards,

 DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 62, India

 --

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

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

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




-- 
.

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


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

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

[Venkatesh Srinivas]

I some how feel he need to know a bit of database basics...


   - Clean and organize the database before working on it...
   - Ensure to know the compatible formula- other features based on version
   and its disadvantages

Regards
Venkatesh
+91 9841969353


On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote:

 Hey

 Please find  below link

 http://en.wikipedia.org/wiki/Management_information_system

 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina 
 lovemekris...@gmail.comwrote:

 Hi Group,

 My Name is krishna, Working as a Data Analyst from the last 3 years. My
 daily work includes working with excel, Creating General Reports, Pdf to
 Excel Conversion, Data Mining and Analyzing data by using Data Tools like,
 Filter, Formulas, Sorting etc..

 But I got a mail from one of my friend, It is an Opening for MIS
 Executive. I just want to know the exact qualification needed for the job. I
 mean, what are the Tools i need to know,

 I know, Many of us are already well settled. So, I just want to know from
 you people,


 Thanking you and Waiting for your reply   - Krrish

 --

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

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

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




 --
 .


  --

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

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

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




-- 

Regards
Venkatesh KS
Phone: +91 98419 69353

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

[Rajan_Verma]

1)  Duplicate Unique Key

2)  Blank Cells

3)  Wrong Data/time format

4)  Wrong Data Type (Number to String)

5)   

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 24, 2011 5:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HI --help me

 

Hi,

 

 

I have one questions.Usually while doing reports what are errors you will
get ?

 

 

Thanks 

-- 

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

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

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

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


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

Re: $$Excel-Macros$$ HI --help me

[Sant Ram]

use formula
=IF(iserror(ur formula),,ur formula))

On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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




-- 
Regards,
Santy

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

[NOORAIN ANSARI]

 Dear Vijay,

Please find Error remover technique.

  * Errors-World* Error Type   Error
Remover Functions   *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()*
#N/A YES YES NO YES YES  #ISREF NO YES YES YES YES #NULL NO YES YES YES YES
#DIV/0! NO YES YES YES YES #NUM NO YES YES YES YES #NAME? NO YES YES YES YES
#VALUES NO YES YES YES YES Other Errors # Press
Alt+O+C+A 2.32335E+16 Press Ctrl+1,Custom Format-Press 0
   Circular
Reference Formula-Error checking-Select Circular Referenceand Decreas
formula Range


-- 
Thanks  regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/



On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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


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


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

Re: $$Excel-Macros$$ HI --help me

[Cab Boose]

Hi

Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet in
one click.  Magic.

Charlie







On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:



  Dear Vijay,

 Please find Error remover technique.

   * Errors-World* Error Type
 Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
 IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
 YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
 #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
  # Press Alt+O+C+A  2.32335E+16 Press
 Ctrl+1,Custom Format-Press 0  Circular Reference Formula-Error
 checking-Select Circular Reference and Decreas formula Range


 --
 Thanks  regards,
 Noorain Ansari
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/



 On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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



  --

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

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

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


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

[vijayajith VA]

Hello All,

Thank You very much..

On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose swch...@gmail.com wrote:

 Hi

 Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet
 in one click.  Magic.

 Charlie







 On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:



  Dear Vijay,

 Please find Error remover technique.

   * Errors-World* Error Type
 Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
 IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
 YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
 #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
# Press Alt+O+C+A  2.32335E+16 Press
 Ctrl+1,Custom Format-Press 0  Circular Reference Formula-Error
 checking-Select Circular Reference and Decreas formula Range


 --
 Thanks  regards,
 Noorain Ansari
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/



 On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA 
 vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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



  --

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

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

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


  --

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

 To 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$$ HI --help me

[Venkat CV]

Hi Vijay,

In Excel You May get errors are

#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function

*Best Regards,*
*Venkat*


On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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




-- 
*
*
*Chennai*
*
*
*
*

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


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

Re: $$Excel-Macros$$ HI --help me

[ashish koul]

http://www.ozgrid.com/Excel/formula-errors.htm

http://chandoo.org/wp/2009/04/20/excel-formula-errors/


On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV venkat1@gmail.com wrote:

 Hi Vijay,

 In Excel You May get errors are

 #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
 if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function

 *Best Regards,*
 *Venkat*


 On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:

 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

 --

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

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

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




 --
 *
 *
 *Chennai*
 *
 *
 *
 *


  --

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

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

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




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.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

Re: $$Excel-Macros$$ HI --help me

[Dilip Pandey]

Hi Vijayajith,

It depends which report having what kind of formula / function /
macros you are working on.

I have came across following errors so far:-

1) Excel Function errors - Can be corrected using ISError function(s)
2) VBA Macros - Can be prevented using Error handlers
3) Linking errors - if other sheets / databases are linked in your
excel report.

There are errors but there are solutions as well.  So cheers :)

Regards,
DILIPandey

On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote:
 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

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

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

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



-- 
Thanks  Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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


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

Re: $$Excel-Macros$$ HI --help me

[KAUSHIK SAVLA]

It depends upon the mistakes u do.

On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote:
 Hi,


 I have one questions.Usually while doing reports what are errors you will
 get ?


 Thanks

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

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

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


-- 
Sent from Gmail for mobile | mobile.google.com

Kaushik Savla

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

[neil johnson]

Thanks a lot

On Fri, Jul 15, 2011 at 9:44 PM, STDEV(i) setiyowati.d...@gmail.com wrote:

 *1.
 **Worksheet.Change Event*
 *
 *Occurs when cells on the worksheet are changed by the user or by an
 external link.
 This event doesn't occur when cells change during a recalculation. Use the
 Calculate event to trap a sheet recalculation.

 This example changes the color of changed cells to blue.
 Private Sub Worksheet_Change(ByVal Target as Range)
Target.Font.ColorIndex = 5
 End Sub


 *2
 Worksheet.SelectionChange Event *

 Occurs when* the selection changes* on a worksheet.

 e.g You move cell pointer from A1 to A2
 The parameter Target  is  Range(A2)

 This example scrolls through the workbook window until* the selection is
 in the upper-left corner of the window*.
  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveWindow
.ScrollRow = Target.Row
.ScrollColumn = Target.Column
End With
 End Sub


 CMIIW




 On Fri, Jul 15, 2011 at 6:45 PM, neil johnson neil.jh...@googlemail.com
 wrote:
 
  Hi Sir,
  Can you please tell me what is difference between these two codes, Please
 guide me.
 
  Private Sub Worksheet_Change(ByVal Target As Range)
  End Sub
 
  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  End Sub

 --

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

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

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


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


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

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

[Daniel]

Hi,

 

Private Sub Worksheet_Change(ByVal Target As Range)

 

is fired when you enter a value into a  cell

 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

is fired when you select another cell or if you change the current
selection.

 

In both cases, “Target” represents the activecell or  current selection.

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de neil johnson
Envoyé : vendredi 15 juillet 2011 13:45
À : excel-macros
Objet : $$Excel-Macros$$ Hi I need your help , Please explain it with
example.

 

Hi Sir, 

Can you please tell me what is difference between these two codes, Please
guide me. 

Private Sub Worksheet_Change(ByVal Target As Range) 

End Sub 

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 

End Sub 

-- 

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

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

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

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


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

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

[Daniel]

Note that in some cases, there is a difference between “Target” and
“ActiveCell”, when the active cell moves downwards or sidewards after you
hit the “Enter” key.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Daniel
Envoyé : vendredi 15 juillet 2011 18:07
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Hi I need your help , Please explain it with
example.

 

Hi,

 

Private Sub Worksheet_Change(ByVal Target As Range)

 

is fired when you enter a value into a  cell

 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

is fired when you select another cell or if you change the current
selection.

 

In both cases, “Target” represents the activecell or  current selection.

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de neil johnson
Envoyé : vendredi 15 juillet 2011 13:45
À : excel-macros
Objet : $$Excel-Macros$$ Hi I need your help , Please explain it with
example.

 

Hi Sir, 

Can you please tell me what is difference between these two codes, Please
guide me. 

Private Sub Worksheet_Change(ByVal Target As Range) 

End Sub 

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 

End Sub 

-- 

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

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

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

-- 

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

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

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

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

[STDEV(i)]

*1.
**Worksheet.Change Event*
*
*Occurs when cells on the worksheet are changed by the user or by an
external link.
This event doesn't occur when cells change during a recalculation. Use the
Calculate event to trap a sheet recalculation.

This example changes the color of changed cells to blue.
Private Sub Worksheet_Change(ByVal Target as Range)
   Target.Font.ColorIndex = 5
End Sub


*2
Worksheet.SelectionChange Event *

Occurs when* the selection changes* on a worksheet.

e.g You move cell pointer from A1 to A2
The parameter Target  is  Range(A2)

This example scrolls through the workbook window until* the selection is in
the upper-left corner of the window*.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   With ActiveWindow
   .ScrollRow = Target.Row
   .ScrollColumn = Target.Column
   End With
End Sub


CMIIW




On Fri, Jul 15, 2011 at 6:45 PM, neil johnson neil.jh...@googlemail.com
wrote:

 Hi Sir,
 Can you please tell me what is difference between these two codes, Please
guide me.

 Private Sub Worksheet_Change(ByVal Target As Range)
 End Sub

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 End Sub

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


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

Re: $$Excel-Macros$$ Hi - Number need to fill randomly

[Manoj kumar]

Pls find the attached...


Regards,
Manoj Kumar

On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C cmanjunathchen...@gmail.comwrote:

 Hi Team,

 I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly
 by clicking the button Press each time.
 Finally we need the data as highlighted in yellow.

 Thanks
 Manjunath

 --

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

 To 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=wallref=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=wallref=ts


Random filling-Manoj.xlsm
Description: Binary data

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 rajputpanka...@gmail.comwrote:

  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=wallref=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=wallref=ts

Re: $$Excel-Macros$$ Hi

[Swapnil Palande]

Hi Pankaj,

Please find attached excel for solution.

Regards,

Swapnil.

On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar rajputpanka...@gmail.comwrote:

 Hi, exper it urgent i need u r help i attached my excel sheet

 --
  *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=wallref=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=wallref=ts


Match Data - Solution.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Hi

[in . vaibhav]

PFA

Vaibhav J
www.excel.blog.com

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Pankaj Kumar rajputpanka...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 21:15:12 
To: excel-macrosexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi

Hi, exper it urgent i need u r help i attached my excel sheet

-- 
 *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=wallref=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=wallref=ts


Book2.xlsx
Description: Binary data

Re: $$Excel-Macros$$ Hi

[Aindril De]

Hi Pankaj,

In your attached example put the following formula in cell C2 and copy it
down:

=IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),Match,Mismatch)

The above formula matches the entries in the Column B with the column A.

Pl let me know if this works for you.

Regards,
Andy

On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar rajputpanka...@gmail.comwrote:

 Hi, exper it urgent i need u r help i attached my excel sheet

 --
  *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=wallref=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=wallref=ts

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

[Jai]

 Please Check this

2010/9/22 Abhidha Dixit abhidha.di...@gmail.com

 Dear  ALL

 Please help how can i transpose the data from notepad to excel with the
 similar colomn gap so that when we copy this again to notebook i shall get
 the data with the samilar spaces

 thanks

 --

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

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

 
 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




-- 
Thanks For Mail.

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


SGfrchg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

[P.VIJAYKUMAR]

Hello

You can copy the text in to excel and to break excel in the format as it is
in not pad you have to you text to columns in the  review menu of menu
bar.If you text is separated by comma or colon or space or other delimiters
you can choose delimited option  and choose the symbol that separates text
and  excel will break the text into columns wherever the delimiter is there.
If there is no such delimiter is there the you can choose fixed option.In
fixed option you can place the arrows where you want to  break the text into
columns and press the next button and once it is finished excel will break
the text into columns where you placed the arrows.But, select the first
column where you copied the text to break into columns or otherwise it will
not work properly. For more information see. this



Split names by using the Convert Text to Columns Wizard
 [image: Show All]Show
Allhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571
[image: Hide All]Hide
Allhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571

Use the Convert Text to Columns Wizard to separate simple cell content, such
as first names and last names, into different columns.
  *Full name*   *First name*   *Last name*   Syed Abbas   Syed
Abbas Molly
Dempsey   Molly Dempsey Lola Jacobsen   Lola Jacobsen Diane Margheim
  Diane Margheim

Depending on your data, you can split the cell content based on a delimiter,
such as a space or a comma, or based on a specific column break location
within your data.
What do you want to do?
--

   - Split content based on a
delimiterhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#BMdelimit
   - Split cell content based on a column
breakhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#BMbreak

--
 Split content based on a delimiter

Use this method if your names have a delimited format, such as First_name
Last_name (where the space between First_name and Last_name is the
delimiter) or Last_name, First_name (where the comma is the delimiter).
Split space-delimited content

To complete these steps, copy the following sample data to a blank
worksheet.

[image: Hide]How to copy an
examplehttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571

   1. Create a blank workbook or worksheet.
   2. Select the example in the Help topic.

* Note *  Do not select the row or column headers.

[image: Selecting an example from Help]

   1. Press CTRL+C.
   2. On the worksheet, select cell A1, and then press CTRL+V.
   3. To switch between viewing the results and viewing the formulas that
   return the results, press CTRL+` (grave accent), or on the
*Formulas*tab, in the
   *Formula Auditing* group, click the *Show Formulas* button.

  *1* *2* *3* *4*
   *A* Syed Abbas Molly Dempsey Lola Jacobsen Diane Margheim

   1. Select the range of data that you want to convert.
   2. On the *Data* tab, in the *Data Tools* group, click *Text to Columns*.


   1. In Step 1 of the Convert Text to Columns Wizard, click *Delimited*,
   and then click *Next*.
   2. In Step 2, select the *Space* check box, and then clear the other
   check boxes under *Delimiters*.

The *Data preview* box shows the first and last names in two separate
columns.

[image: Text to Columns Wizard - Step 2 of 3]

   1. Click *Next*.
   2. In Step 3, click a column in the *Data preview* box, and then click *
   Text* under *Column data format*.

Repeat this step for each column in the *Data preview* box.

   1. If you want to insert the separated content into the columns next to
   the full name, click the icon to the right of the *Destination* box, and
   then select the cell next to the first name in the list (B2, in this
   example).

[image: Destination of splitted contents]

* Important *  If you do not specify a new destination for the new columns,
the split data will replace the original data.

   1. Click the icon to the right of the *Convert Text to Columns Wizard*.

[image: Text to Columns Wizard Step 3 of 3]

   1. Click *Finish*.

[image: Top of 
Page]http://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#top
Top
of 
Pagehttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#top
 Split comma-delimited content

To complete these steps, copy the following sample data to a blank

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

[Sanjoy Nath]

Just open the notepad and find and replace all the spaces with comma
and after that close the file
and rename the file extension from .txt to .csv


see the magic

reverse process to get the thing in txt again


ITS WILL WORK GREAT

2010/9/22 Abhidha Dixit abhidha.di...@gmail.com

 Dear  ALL

 Please help how can i transpose the data from notepad to excel with the
 similar colomn gap so that when we copy this again to notebook i shall get
 the data with the samilar spaces

 thanks

 --

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

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

 
 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




-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

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

[Sanjoy Nath]

If you need the more shortcut then I can develop a macro for that



On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath sanjoy.nath...@gmail.comwrote:

 Just open the notepad and find and replace all the spaces with comma
 and after that close the file
 and rename the file extension from .txt to .csv


 see the magic

 reverse process to get the thing in txt again


 ITS WILL WORK GREAT

  2010/9/22 Abhidha Dixit abhidha.di...@gmail.com

 Dear  ALL

 Please help how can i transpose the data from notepad to excel with the
 similar colomn gap so that when we copy this again to notebook i shall get
 the data with the samilar spaces

 thanks

 --

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

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

 
 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




 --
 Your Sincerely
 Sanjoy Nath
 Engineer
 EOL Gurgaon
 EOL/M/NZ/Engg.Dept.(Haryana Division)




-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

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

[Abhidha Dixit]

Hi Vijay

I want the format as it is in the notepad eg if there is 2 spacebar distance
between the columns , and we transfer that to excel it should take the same
distance so that if we want to save this excel to notepad again ( after
calculation) the same distance of space ber should be maintained

My problem is if I transfer the data from this notepadd to excel and again
if I want to save the same data from excel to notepad then the previous
alignment gets disturbed

hope this is clear will be greatful if this could resolved

On Wed, Sep 22, 2010 at 12:20 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Hello

 You can copy the text in to excel and to break excel in the format as it is
 in not pad you have to you text to columns in the  review menu of menu
 bar.If you text is separated by comma or colon or space or other delimiters
 you can choose delimited option  and choose the symbol that separates text
 and  excel will break the text into columns wherever the delimiter is there.
 If there is no such delimiter is there the you can choose fixed option.In
 fixed option you can place the arrows where you want to  break the text into
 columns and press the next button and once it is finished excel will break
 the text into columns where you placed the arrows.But, select the first
 column where you copied the text to break into columns or otherwise it will
 not work properly. For more information see. this



  Split names by using the Convert Text to Columns Wizard
  [image: Show All]Show 
 Allhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571
 [image: Hide All]Hide 
 Allhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571

 Use the Convert Text to Columns Wizard to separate simple cell content,
 such as first names and last names, into different columns.
   *Full name*   *First name*   *Last name*   Syed Abbas   Syed
 Abbas Molly Dempsey   Molly Dempsey Lola Jacobsen   Lola Jacobsen 
 Diane
 Margheim   Diane Margheim

 Depending on your data, you can split the cell content based on a
 delimiter, such as a space or a comma, or based on a specific column break
 location within your data.
 What do you want to do?
 --

- Split content based on a 
 delimiterhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#BMdelimit
- Split cell content based on a column 
 breakhttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571#BMbreak

 --
  Split content based on a delimiter

 Use this method if your names have a delimited format, such as First_name
 Last_name (where the space between First_name and Last_name is the
 delimiter) or Last_name, First_name (where the comma is the delimiter).
 Split space-delimited content

 To complete these steps, copy the following sample data to a blank
 worksheet.

 [image: Hide]How to copy an 
 examplehttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101023409990lcid=1033NS=EXCELVersion=12respos=0CTT=1queryid=83976222ad054078b3f0369400bc8571

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.

 * Note *  Do not select the row or column headers.

 [image: Selecting an example from Help]

1. Press CTRL+C.
2. On the worksheet, select cell A1, and then press CTRL+V.
3. To switch between viewing the results and viewing the formulas that
return the results, press CTRL+` (grave accent), or on the *Formulas*tab, 
 in the
*Formula Auditing* group, click the *Show Formulas* button.

   *1* *2* *3* *4*
*A* Syed Abbas Molly Dempsey Lola Jacobsen Diane Margheim

1. Select the range of data that you want to convert.
2. On the *Data* tab, in the *Data Tools* group, click *Text to Columns
*.


1. In Step 1 of the Convert Text to Columns Wizard, click *Delimited*,
and then click *Next*.
2. In Step 2, select the *Space* check box, and then clear the other
check boxes under *Delimiters*.

 The *Data preview* box shows the first and last names in two separate
 columns.

 [image: Text to Columns Wizard - Step 2 of 3]

1. Click *Next*.
2. In Step 3, click a column in the *Data preview* box, and then click
*Text* under *Column data format*.

 Repeat this step for each column in the *Data preview* box.

1. If you want to insert the separated content into the columns next to
the full name, click the icon to the right of the *Destination* box,
and then select the cell next to the first name in the list (B2, in this
example).

 [image: Destination of splitted contents]

 * Important *  If you do 

Re: $$Excel-Macros$$ Hi

[siti Vi]

you have to send your posting from your email-client,
not from the group web.


On Thu, Sep 16, 2010 at 4:03 PM, dinoabeer umarab...@googlemail.com wrote:

 Can somebody help. I m a newbie here. how do I upload I file when I
 post something

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

[dhedhipya doradla]

http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx
http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx
http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data
http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data
http://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/89/Default.aspx
http://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/89/Default.aspx
http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
 http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/

On Sat, Aug 28, 2010 at 12:18 PM, dhedhipya doradla dhedhi...@gmail.comwrote:

 Learn from Help menu in excel


 On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar 
 rajputpanka...@gmail.comwrote:

 Hi, All,


 I am fresher in ms excel  wanted to learned how to prepared Pivot table 
 report in Msexcel

 --
 *Warm Regards
 Pankaj kumar
 M: 9899816107
 e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*

  --

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

[Vinod N]

In addition to the above, also please check the following link:

http://chandoo.org/excel-formulas/vlookup.html

http://chandoo.org/excel-formulas/vlookup.htmlThnx
Vinod N

On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju 
rajasekhar.prahar...@gmail.com wrote:

 Hi,


 Adding to this... this PPT Gives good understanding
 regarding
 Vlookup hope this helps you..


 Attached is the PPT presentation regarding the vlookup .

 In case of any queries just let me know

 Regards,
 Raj



 On Thu, Aug 26, 2010 at 11:18 PM, Kal xcel kalx...@gmail.com wrote:

 Hi Pankaj,

 Vlookup means Vertical lookup that is find the given value in vartical
 order. vlookup is the way to find the particular data from master file. It
 gives the data in vertical manner from the right side of the column
 against which data has to find.

 Syntax

 VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

 Lookup_value The value to search in the first column of the table array
 (array: Used to build single formulas that produce multiple results or
 that
 operate on a group of arguments that are arranged in rows and columns. An
 array range shares a common formula; an array constant is a group of
 constants used as an argument.). Lookup_value can be a value or a
 reference.

 Important: If lookup_value is smaller than the smallest value in the first

 column of table_array, VLOOKUP returns the #N/A error value.

 Table_array Two or more columns of data. Use a reference to a range or a
 range name. The values in the first column of table_array are the values
 searched by lookup_value. These values can be text, numbers, or logical
 values.

 Note: Uppercase and lowercase text are equivalent.

 Col_index_num The column number in table_array from which the matching
 value must be returned. A col_index_num of 1 returns the value in the
 first
 column in table_array; a col_index_num of 2 returns the value in the
 second
 column in table_array, and so on. If col_index_num is:

 Less than 1, VLOOKUP returns the #VALUE! error value.
 Greater than the number of columns in table_array, VLOOKUP returns the
 #REF!
 error value.

 Range_lookup A logical value that specifies whether you want VLOOKUP to
 find an exact match or an approximate match:

 If TRUE or omitted, an exact or approximate match is returned. If an exact

 match is not found, the next largest value that is less than lookup_value
 is
 returned.

 The values in the first column of table_array must be placed in ascending
 sort order; otherwise, VLOOKUP may not give the correct value. You can put

 the values in ascending order by choosing the Sort command from the Data
 menu
 and selecting Ascending. For more information, see Default sort orders.

 If FALSE, VLOOKUP will only find an exact match. In this case, the values
 in
 the first column of table_array do not need to be sorted. If there are two
 or
 more values in the first column of table_array that match the
 lookup_value,
 the first value found is used. If an exact match is not found, the error
 value #N/A is returned.

  --

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




-- 
Thanks and Regards

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

Re: $$Excel-Macros$$ hi

[C.G.Kumar]

Press F1 Key and see the examples.

On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:

 Hi,

 Can anyone help me to understand what is Vlookup  Hlookup,for a short
 example how to use it ,,

 --
 *Warm Regards
 Pankaj kumar
 M: 9899816107
 e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*

  --

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

[NOORAIN ANSARI]

Dear Pankaj,

Please find attachment with simple example of Vlookup  Hlookup.


   - Vlookup always take right value.
   - Vlookup doesn't take duplicate value.

Thanks,
Noorain Ansari



On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:

  Hi,

 Can anyone help me to understand what is Vlookup  Hlookup,for a short
 example how to use it ,,

 --
 *Warm Regards
 Pankaj kumar
 M: 9899816107
 e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*

 --

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




-- 
Thanks  regards,
Noorain Ansari

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


VLookup  HLookup Example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ hi

[Kal xcel]

Hi Pankaj,

Vlookup means Vertical lookup that is find the given value in vartical
order. vlookup is the way to find the particular data from master file. It
gives the data in vertical manner from the right side of the column against
which data has to find.

Syntax

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value The value to search in the first column of the table array
(array: Used to build single formulas that produce multiple results or that
operate on a group of arguments that are arranged in rows and columns. An
array range shares a common formula; an array constant is a group of
constants used as an argument.). Lookup_value can be a value or a reference.


Important: If lookup_value is smaller than the smallest value in the first
column of table_array, VLOOKUP returns the #N/A error value.

Table_array Two or more columns of data. Use a reference to a range or a
range name. The values in the first column of table_array are the values
searched by lookup_value. These values can be text, numbers, or logical
values.

Note: Uppercase and lowercase text are equivalent.

Col_index_num The column number in table_array from which the matching
value must be returned. A col_index_num of 1 returns the value in the first
column in table_array; a col_index_num of 2 returns the value in the second
column in table_array, and so on. If col_index_num is:

Less than 1, VLOOKUP returns the #VALUE! error value.
Greater than the number of columns in table_array, VLOOKUP returns the #REF!

error value.

Range_lookup A logical value that specifies whether you want VLOOKUP to
find an exact match or an approximate match:

If TRUE or omitted, an exact or approximate match is returned. If an exact
match is not found, the next largest value that is less than lookup_value is

returned.

The values in the first column of table_array must be placed in ascending
sort order; otherwise, VLOOKUP may not give the correct value. You can put
the values in ascending order by choosing the Sort command from the Data
menu
and selecting Ascending. For more information, see Default sort orders.

If FALSE, VLOOKUP will only find an exact match. In this case, the values in

the first column of table_array do not need to be sorted. If there are two
or
more values in the first column of table_array that match the lookup_value,
the first value found is used. If an exact match is not found, the error
value #N/A is returned.

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


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

Re: $$Excel-Macros$$ Hi, need your help - urgent

[SAJID MANSOOR]

Good!
But instead of copy paste we can use bring to front by keeping all images on
same position.

On Thu, Jul 1, 2010 at 7:38 PM, ashish koul koul.ash...@gmail.com wrote:

 hi


 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
 Boolean)


 If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then

 Call deletshape



  Sheets(Sheet1).Select
 Range(E9).Select
 Selection.Delete

  Sheets(2).Shapes(1).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then
 Call deletshape
  Sheets(2).Shapes(2).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then
 Call deletshape

  Sheets(2).Shapes(3).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then
 Call deletshape

  Sheets(2).Shapes(4).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste

 End If

 End Sub

 Sub deletshape()
 Dim sh As Shape


For Each sh In Sheets(1).Shapes

  If sh.Type = msoPicture Then
   sh.Delete
End If
 Next sh

 End Sub


 ashish koul

 akoul.blogspot.com



 On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote:

 Hi

 Pls find attached the excel file, I just want that when I move my mouse
 cursor over a cell, the image having the name equal to cell's value will get
 displayed, pls open the attached excel file for more clarification.

 Regards
 Rajender Soni

 --

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

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

 
 HELP US GROW !!

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


  --

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

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

 
 HELP US GROW !!

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


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

[Aindril De]

Hi Rajender,

I am not quite sure how would you want to do it. However there is a very
simple solution mentioned in the link below, which almost does what you are
trying to achieve.
http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html

http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html
Regards,
Andy

On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote:

 Hi

 Pls find attached the excel file, I just want that when I move my mouse
 cursor over a cell, the image having the name equal to cell's value will get
 displayed, pls open the attached excel file for more clarification.

 Regards
 Rajender Soni

 --

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

[nifaz islam]

hi
i need help how i can secure a hidden sheet no any one can unhide and modify
it.




Regards
Ni



On Thu, Jul 1, 2010 at 7:38 AM, ashish koul koul.ash...@gmail.com wrote:

 hi


 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
 Boolean)


 If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then

 Call deletshape



  Sheets(Sheet1).Select
 Range(E9).Select
 Selection.Delete

  Sheets(2).Shapes(1).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then
 Call deletshape
  Sheets(2).Shapes(2).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then
 Call deletshape

  Sheets(2).Shapes(3).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste


 ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then
 Call deletshape

  Sheets(2).Shapes(4).Copy
 Sheets(Sheet1).Select
 Range(E9).Select
 ActiveSheet.Paste

 End If

 End Sub

 Sub deletshape()
 Dim sh As Shape


For Each sh In Sheets(1).Shapes

  If sh.Type = msoPicture Then
   sh.Delete
End If
 Next sh

 End Sub


 ashish koul

 akoul.blogspot.com



 On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote:

 Hi

 Pls find attached the excel file, I just want that when I move my mouse
 cursor over a cell, the image having the name equal to cell's value will get
 displayed, pls open the attached excel file for more clarification.

 Regards
 Rajender Soni

 --

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




-- 
Kindly Regards
Nifaz Islam

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

[rf1234 rf1234]

Hello Dear,

Use the following instruction.

Select Range
Data Menu
Pivot Table And Pivot Chart Report
Next(Follow the instruction)



or go to link below
http://www.cpearson.com/excel/pivots.htm

http://www.contextures.com/xlpivot07.html








Hope it Will Help
Happy to Help
:)
Shyam


On Tue, Apr 6, 2010 at 11:47 AM, Sarvesh sarve...@yahoo.com wrote:

   hi
 thanks for your help.

 what you are doing is right..but i dont knwo pivot table and how did u do
 it...any tutorial for the same...?



  regards,
 *sarvesh lahoti.*


 --- On *Tue, 6/4/10, rf1234 rf1234 rfhyd1...@gmail.com* wrote:


 From: rf1234 rf1234 rfhyd1...@gmail.com
 Subject: Re: $$Excel-Macros$$ hi-help required .
 To: excel-macros@googlegroups.com
 Cc: sarve...@yahoo.com
 Date: Tuesday, 6 April, 2010, 10:52 AM


  Hello Dear,
 Attached workbook has a sample for your problem.











 Hope it Will Help
 Happy to Help
 :)
 Shyam








 On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh 
 sarve...@yahoo.comhttp://mc/compose?to=sarve...@yahoo.com
  wrote:


 hi

 firstly r u from hyderabad... just felt so with ur mail id.( i am from
 hyderabad)

 i am attaching my actual file. plz go thru it.

 thanks a ton.


  regards,
 *sarvesh lahoti.*


 --- On *Mon, 5/4/10, rf1234 rf1234 
 rfhyd1...@gmail.comhttp://mc/compose?to=rfhyd1...@gmail.com
 * wrote:


 From: rf1234 rf1234 
 rfhyd1...@gmail.comhttp://mc/compose?to=rfhyd1...@gmail.com
 
 Subject: Re: $$Excel-Macros$$ hi-help required .
 To: 
 excel-macros@googlegroups.comhttp://mc/compose?to=excel-mac...@googlegroups.com
 Cc: sarve...@yahoo.com http://mc/compose?to=sarve...@yahoo.com
 Date: Monday, 5 April, 2010, 5:03 PM


  Hello Dear,
 Following attachment have a solution regarding your problem.













 Hope it Will Help
 Happy to Help
 :)
 Shyam










 On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh 
 sarve...@yahoo.comhttp://mc/compose?to=sarve...@yahoo.com
  wrote:


 hi

 i have a worksheet where sizes and qty are maintained for each item in
 this way

460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet
 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12
 Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91

 daily some sizes and qty are added , deleted, modified.

 i need to know the total requirement of each size eg: 480*12 pet
 =+131+7+56+12+91  which is 297.

 same way need for all the sizes. the list is very big.

 i am not familiar with macros , any other formulae based solution will be
 helpful.

 thanks


   regards,
 *sarvesh lahoti.*

 --
 Your Mail works best with the New Yahoo Optimized IE8. Get it 
 NOW!http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/.


 --

 --
 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.comhttp://mc/compose?to=excel-mac...@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




 --

 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

Re: $$Excel-Macros$$ hi-help required .

[Hemant K]

Here is the solution attached you can do it with the help of sumproduct
formula or with Sumif Formula

Regards
Hemant

On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.com wrote:


 hi

 i have a worksheet where sizes and qty are maintained for each item in this
 way

  460*12 Pet 31  460*12 Pet 265  460*12 Pet 340  460*12 Pet 392  460*12 Pet
 523  460*12 Pet 150  470*12 Pet 35  470*12 Pet 212  470*12 Pet 159  480*12
 Pet 131  480*12 Pet 7  480*12 Pet 56  480*12 Pet 12  480*12 Pet 91

 daily some sizes and qty are added , deleted, modified.

 i need to know the total requirement of each size eg: 480*12 pet
 =+131+7+56+12+91  which is 297.

 same way need for all the sizes. the list is very big.

 i am not familiar with macros , any other formulae based solution will be
 helpful.

 thanks


 regards,
 *sarvesh lahoti.*

 --
 Your Mail works best with the New Yahoo Optimized IE8. Get it 
 NOW!http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/.


 --

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




-- 
Regards

Hemant Koranne
Check out my web site for learning excel
http://exceltnt.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 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.


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

Re: $$Excel-Macros$$ hi-help required .

[Sarvesh]

thanks ..thanks a lot.
one little doubt...if i delete or add a qty in the list...then pivot table is 
not updated immediately ?
i need it to be updated

regards,sarvesh lahoti.

--- On Tue, 6/4/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:

From: rf1234 rf1234 rfhyd1...@gmail.com
Subject: Re: $$Excel-Macros$$ hi-help required .
To: excel-macros@googlegroups.com
Cc: sarve...@yahoo.com
Date: Tuesday, 6 April, 2010, 10:52 AM

Hello Dear,
Attached workbook has a sample for your problem.
 
 
 
 
 
 
 
 
 
 
 
Hope it Will Help
Happy to Help
:)
Shyam
 
 
 
 
 


 
On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh sarve...@yahoo.com wrote:






hi 


firstly r u from hyderabad... just felt so with ur mail id.( i am from 
hyderabad)


i am attaching my actual file. plz go thru it.


thanks a ton.






regards,
sarvesh lahoti.

--- On Mon, 5/4/10, rf1234 rf1234 rfhyd1...@gmail.com wrote:



From: rf1234 rf1234 rfhyd1...@gmail.com
Subject: Re: $$Excel-Macros$$ hi-help required .

To: excel-macros@googlegroups.com
Cc: sarve...@yahoo.com
Date: Monday, 5 April, 2010, 5:03 PM 






Hello Dear,
Following attachment have a solution regarding your problem.
 
 
 
 
 
 
 
 
 
 
 
 
 
Hope it Will Help
Happy to Help
:)
Shyam
 
 
 
 
 
 
 


 
On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.com wrote:






hi  


i have a worksheet where sizes and qty are maintained for each item in this way








460*12 Pet
31

460*12 Pet
265

460*12 Pet
340

460*12 Pet
392

460*12 Pet
523

460*12 Pet
150

470*12 Pet
35

470*12 Pet
212

470*12 Pet
159

480*12 Pet
131

480*12 Pet
7

480*12 Pet
56

480*12 Pet
12

480*12 Pet
91

daily some sizes and qty are added , deleted, modified.

i need to know the total requirement of each size eg: 480*12 pet 
=+131+7+56+12+91  which is 297.


same way need for all the sizes. the list is very big.

i am not familiar with macros , any other formulae based solution will be 
helpful.

thanks 







regards,
sarvesh lahoti.




Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. 
-- 
--
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




-- 

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





The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.


-- 

Thanks Regards

Shyam
Software Engineer
''

When one door of happiness closes, another opens

Re: $$Excel-Macros$$ Hi Please Help ME

[rf1234 rf1234]

Hello Dear,
I am unable to understand your problem.Please 1'st explain problem.
In your attachment,you have not explain your problem.














Please Reply So that we can understand your requirements.



On Mon, Mar 22, 2010 at 3:27 PM, anil panchal anil.kan...@gmail.com wrote:

 Hi All

  A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB
 Height A CNB MTRL sum OF SB sum OF GB  0 0 0 0 0 0 48 72 24 SB

  10.22 GB 0 0 0 0 72 20 10 SB

  20.236111 GB 0 0 0 0 64 30 13.33 SB

  23.291667 GB 0 0 0 0 130 35 31.597222 SB

  0 0 0 0 0 0 0 0 0 0

  0 0 0 0 0 0 0 0 0 0



 Please help me

 --

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




-- 

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.

Re: $$Excel-Macros$$ hi all

[Puttaswamy]

How to use that, its not working for me? what is the use of that sheet?

On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote:

 just find it on goole see if it useful to u

 --

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




-- 
Putta

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


HELP US GROW !!

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

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

Re: $$Excel-Macros$$ hi all

[Auto Tours Inv Limited]

what is it supposed to do?

On Fri, Mar 19, 2010 at 9:49 AM, Puttaswamy puttu...@gmail.com wrote:

 How to use that, its not working for me? what is the use of that sheet?


 On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.comwrote:

 just find it on goole see if it useful to u

 --

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




 --
 Putta

 --

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




-- 
Thanks

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


HELP US GROW !!

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

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

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

[ankur]

hi harish

Ayush saying is true, unless u dont try by urself u will never
learn...if you really want to learn

ask any specific funtion or formula, we will be happy to make it clear to you

for any query you can mail me

On 26/01/2010, ayush jain jainayus...@gmail.com wrote:
 Dude, This forum is to help genuine  real life problems of excel and macros
 users.

 Your test appears to be quite simple and it was made to test your
 capability. You will not be able to learn if we will solve it.

 First try at your end and if you find any problems in specific question,
 just let us know.

 Thanks and best regards,
 Ayush Jain
 Group Owner

 On Mon, Jan 25, 2010 at 10:01 PM, harish chandru
 harish.chan...@gmail.comwrote:

 Hi All,

 May I kindly request you to help me out on the below
 attached spreadsheet query..
 I need it today as i need to submit this tomorrow morg in my class..
 please
 help me..

 Thanks,
 Harish

 -- Forwarded message --
 From: Vinu vinu1sm...@gmail.com
 Date: Mon, Jan 25, 2010 at 9:48 PM
 Subject: xl
 To: harish.chan...@gmail.com




 --
 Regards
 Vinod Kumar
 Bangalore
 +91-9986423819


  --

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


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

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


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


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

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



-- 
Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~

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

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

HELP US GROW !!

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

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

[ayush jain]

Dude, This forum is to help genuine  real life problems of excel and macros
users.

Your test appears to be quite simple and it was made to test your
capability. You will not be able to learn if we will solve it.

First try at your end and if you find any problems in specific question,
just let us know.

Thanks and best regards,
Ayush Jain
Group Owner

On Mon, Jan 25, 2010 at 10:01 PM, harish chandru
harish.chan...@gmail.comwrote:

 Hi All,

 May I kindly request you to help me out on the below
 attached spreadsheet query..
 I need it today as i need to submit this tomorrow morg in my class.. please
 help me..

 Thanks,
 Harish

 -- Forwarded message --
 From: Vinu vinu1sm...@gmail.com
 Date: Mon, Jan 25, 2010 at 9:48 PM
 Subject: xl
 To: harish.chan...@gmail.com




 --
 Regards
 Vinod Kumar
 Bangalore
 +91-9986423819


  --

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


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

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


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

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

HELP US GROW !!

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

Re: $$Excel-Macros$$ hi

[Y AlterS]

Your being troubled by array functions. those curly brackets cannot
be entered manually.

On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah shraddh...@sbm-india.comwrote:

  Hi,



 We are using the attached file to prepare certain reports for the bank.



 We need to actually bucket the all the deposits as per the maturities
 given.



 One of colleague is using this formula (highlighted in yellow). Can u
 suggest any other method.



 If not please help me with the same formula as im unable to use the same.





 *Thanks  Regards*

 *Shraddha Shah*

 *State Bank of **Mauritius*

 *Tel - 2 2846 560 Ext (115)*



 P* Please don't print this e-mail unless you really need to.*



 --

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


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

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

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

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

HELP US GROW !!

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

Re: $$Excel-Macros$$ hi

[Sandeep]

Hi

Use this in X5
=SUMIF($T$5:$T$717,=X3,$M$5:$M$717)

And this in Y5
=SUMIF($T$5:$T$717,=Y3,$M$5:$M$717) - SUMIF($T$5:$T$717,=X3,$M$5:$M$717)

Then copy the Y5 formula and paste it in Z5 to AF5

Regards
Sandeep
  - Original Message - 
  From: Shraddha Shah 
  To: excel-macros@googlegroups.com 
  Sent: Friday, November 13, 2009 2:15 PM
  Subject: $$Excel-Macros$$ hi


  Hi,

   

  We are using the attached file to prepare certain reports for the bank.

   

  We need to actually bucket the all the deposits as per the maturities given.

   

  One of colleague is using this formula (highlighted in yellow). Can u suggest 
any other method.

   

  If not please help me with the same formula as im unable to use the same.

   

   

  Thanks  Regards

  Shraddha Shah

  State Bank of Mauritius

  Tel - 2 2846 560 Ext (115)

   

  P Please don't print this e-mail unless you really need to.

   


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

   
  To post to this group, send email to excel-macros@googlegroups.com
  If you find any spam message in the group, please send an email to:
  Ayush Jain @ jainayus...@gmail.com or
  Ashish Jain @ 26may.1...@gmail.com
  
  HELP US GROW !!
   
  We reach over 6,500 subscribers worldwide and receive many nice notes about 
the learning and support from the group. Our goal is to have 10,000 subscribers 
by the end of 2009. Let friends and co-workers know they can subscribe to group 
at http://groups.google.com/group/excel-macros/subscribe

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

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

HELP US GROW !!

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

Re: $$Excel-Macros$$ hi need ur help

[ashish koul]

i want to find the value of adjacent row using vlookup  my answer should
come3  in this case but its not showing that

On Thu, Nov 12, 2009 at 12:42 PM, Aindril De aind...@gmail.com wrote:

 Hi Ashish

 =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1), NO EXACT
 MATCH)

 Is the corrected formula.

 Regards,
 Andy

   On Thu, Nov 12, 2009 at 11:44 AM, ashish koul koul.ash...@gmail.comwrote:

 hi sir

 can u please check whats wrong in the formual want to do case sensitive
 vkooup

 thanks

 --

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


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

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


 --

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


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

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


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

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

HELP US GROW !!

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

Re: $$Excel-Macros$$ hi need ur help

[Chandra Gupta]

Dear Ashish perhaps you need this.

Chandra Gupta

On Thu, Nov 12, 2009 at 2:18 PM, ashish koul koul.ash...@gmail.com wrote:

 i want to find the value of adjacent row using vlookup  my answer should
 come3  in this case but its not showing that


 On Thu, Nov 12, 2009 at 12:42 PM, Aindril De aind...@gmail.com wrote:

 Hi Ashish

 =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1), NO EXACT
 MATCH)

 Is the corrected formula.

 Regards,
 Andy

   On Thu, Nov 12, 2009 at 11:44 AM, ashish koul koul.ash...@gmail.comwrote:

 hi sir

 can u please check whats wrong in the formual want to do case sensitive
 vkooup

 thanks

 --

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


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

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


 --

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


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

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


  --

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


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

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


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

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

HELP US GROW !!

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

case senstive vlookup example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ hi need ur help

[Aindril De]

Sorry for the misunderstanding Ashish. Following is teh correct formula:

=IF(EXACT(F7,VLOOKUP(F7,$A$5:$B$7,2,1))=TRUE,VLOOKUP(F7,$A$5:$B$7,2,1), NO
EXACT MATCH)

Regards,
Andy

On Thu, Nov 12, 2009 at 3:48 PM, ashish koul koul.ash...@gmail.com wrote:

 i want to find the value of adjacent row using vlookup  my answer should
 come3  in this case but its not showing that


 On Thu, Nov 12, 2009 at 12:42 PM, Aindril De aind...@gmail.com wrote:

 Hi Ashish

 =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1), NO EXACT
 MATCH)

 Is the corrected formula.

 Regards,
 Andy

   On Thu, Nov 12, 2009 at 11:44 AM, ashish koul koul.ash...@gmail.comwrote:

 hi sir

 can u please check whats wrong in the formual want to do case sensitive
 vkooup

 thanks

 --

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


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

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


 --

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


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

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


 --

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


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

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


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

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

HELP US GROW !!

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

Re: $$Excel-Macros$$ hi help please

[Aindril De]

Hi Ashish,

You can simply use the exact match option of vlookup to do this.
The following links from MS have the complete explaination:

XL: How to Perform a Case-Sensitive Lookup
http://support.microsoft.com/kb/214264

How to Use VLOOKUP or HLOOKUP to find an exact match
http://support.microsoft.com/kb/181213


Please let us know if you need further help on this.

Regards,
Andy

On Thu, Nov 12, 2009 at 12:02 AM, ashish koul koul.ash...@gmail.com wrote:

 how can i go for case sensitive Vlookup and as well as using case sensitive
 in if condition


 thanks

 --

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


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

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

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

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

HELP US GROW !!

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