$$Excel-Macros$$ formula help

[Kamal Ganeshan]

Dear All,

I have attached one files need your help to applied correct formula

Kindly help.

Regards,
Ganeshan

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


Formula help require (1).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 10 updates in 8 topics

[Kamal Prasoon]

On Thu, May 3, 2018, 4:57 AM  wrote:

> excel-macros@googlegroups.com
> 
>  Google
> Groups
> 
> 
> Today's topic summary
> View all topics
> 
>
>- Hiring for GCP Engineer - Onsite/Remote - CA
><#m_5071039455803661636_group_thread_0> - 1 Update
>- Urgent Sr.Java Developer at Las Vegas,NV-89169
><#m_5071039455803661636_group_thread_1> - 1 Update
>- Back Fill Position || Urgent Need Healthcare Data Analysts (Ft.
>Lauderdale, FL) 01+ Years <#m_5071039455803661636_group_thread_2> - 1
>Update
>- Hiring for Salesforce Developer for Richmond, VA
><#m_5071039455803661636_group_thread_3> - 1 Update
>- Urgent Requirement :: Mobile Developer :: Cleveland, OH :: Long Term
><#m_5071039455803661636_group_thread_4> - 1 Update
>- Immediate hire for SAP PO Consultant at Branchburg, NJ
><#m_5071039455803661636_group_thread_5> - 3 Updates
>- Immediate hire for Senior SCM at Raleigh, NC
><#m_5071039455803661636_group_thread_6> - 1 Update
>- Help Required on VE Project <#m_5071039455803661636_group_thread_7>
>- 1 Update
>
> Hiring for GCP Engineer - Onsite/Remote - CA
> 
> akshita mittal : May 02 01:43PM -0400
>
> *Role : GCP Engineer - Onsite/Remote*
>
> *Duration: 3+ months*
>
> *Location: first 2 weeks in CA, the rest remote with occasional short trips
> to client site*
>
> *Interview: phone/skype*
>
>
> ...more
> 
> Back to top <#m_5071039455803661636_digest_top>
> Urgent Sr.Java Developer at Las Vegas,NV-89169
> 
> Roshni Siddiqui : May 02 10:09AM -0700
>
> *Hi *
>
> *Our one of premier client is looking for a strong “Java Developer” at
> “Las Vegas,NV-89169”*
>
>
>
>
>
> *Title: Java Developer*
>
> *Location: Las Vegas,NV-89169*
> ...more
> 
> Back to top <#m_5071039455803661636_digest_top>
> Back Fill Position || Urgent Need Healthcare Data Analysts (Ft.
> Lauderdale, FL) 01+ Years
> 
> Javeed Khan : May 02 11:46AM -0400
>
> Please share profile on ja...@nestarit.com
>
> Direct contact number: (201) 448 1184
>
>
>
> This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have
> an immediate requirement with our ...more
> 
> Back to top <#m_5071039455803661636_digest_top>
> Hiring for Salesforce Developer for Richmond, VA
> 
> akshita mittal : May 02 10:57AM -0400
>
> *Role : Salesforce Developer *
>
> *Location : Richmond, VA*
>
> *Interview : Phone and F2F/Skype*
> ...more
> 
> Back to top <#m_5071039455803661636_digest_top>
> Urgent Requirement :: Mobile Developer :: Cleveland, OH :: Long Term
> 
> Technical Recruiter : May 02 10:52AM
> -0400
>
> Hi,
>
>
> Hope you are doing well,
>
>
> If you have any consultant available for the below requirement please send
> me their resume on *s...@galaxy-soft.com .*
>
> ...more
> 
> Back to top <#m_5071039455803661636_digest_top>
> Immediate hire for SAP PO Consultant at Branchburg, NJ
> 
> Srikanth HCL Global : May 02 09:32AM
> -0400
>
> Hello,
>
>
>
> Greetings of the day!!!
>
>
>
> *Please share resumes to* *s...@hclglobal.com* * at
> earliest.*
>
>
>
> *Below is the job description for your consideration:*
> ...more
> 
> Ahmed Honest : May 02 04:40PM +0300
>
> SRIKANTH:
>
> THIS IS NOT JOB PUBLISHING PORTAL. KINDLY STOP SENDING EMAILS TO THE
> GROUP..!!!
>
> On Wed, May 2, 2018 

$$Excel-Macros$$ Excel experts- Help require on

[Kamal Ganeshan]

Hi everyone,

Hope all is well, Can you please help on the below requirement.

*Requirement*: I need formula or VBA code which split to each code sequence
which is highlighted in yellow colour.

Eg: *Z020- Z026*  =  Z020 | Z021 | Z022 | Z023 | Z024 | Z025 | Z026

Code 1 2 3 4 5 6 7
Z005-Z006 Z005 Z006
Z020-Z026 Z020   Z021 Z022   Z023Z024Z025  Z026
Z048-Z049 Z048 Z049
Z110-Z114 Z110   Z114
Regards,
Ganeshan

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


Codes.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA

[Kamal Paul]

Hi All ,
i have an urgent Opening for ab-initio with Java Back ground. please find 
the details for the Position and Reply me if you have available consultant 
for the same.

 Title : Ab-nitio with AWS java 

Job Type : Contractual
location : Richmond VA
Duration : 6 months  








· Work involves transferring from DDE to AWS using Ab Initio – Need 
candidates with strong Ab Initio background with java skills

· Need folks with AWS knowledge with scripting  to create 
infrastructure, should have Java background 




 

*Kamal Paul*

*Technical Recruiter*

 

(Desk):610-590-1511 
*Gtalk* : recruiter.kp...@gmail.com

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Introduce Yourself !!

[Kamal Paul]

HI ,
My name is kamal paul working as an US IT recruiter at Zodiac -solutions. 

On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

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

FORUM RULES

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

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

$$Excel-Macros$$ How to apply validation in Open office 3.1

[Kamal Ganeshan]

Hi All,

Can you please help me to apply validation in Open Office 3.1

Regards,
Ganeshan

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

FORUM RULES

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

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

$$Excel-Macros$$ Need help to create a user form.

[Kamal Ganeshan]

Hi All,

Need some help to create a User form based on the logic.

If any enter Sub Brand numbers in cell F12  Invoice number in cell
G12 then I want the H should be update automatic as per the above
table numbers.

I have done the exercise which is manual Vlookup formula but i need
the same logic in User form VBA .

Requesting you to please do the needful  revert.

Regards.
Ganeshan

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


Need help in User form.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Need help to create a user form.

[Kamal Ganeshan]

Hi All,

I want you to understand the requirements.

Sub Brand numbers  Invoice number combination will be multiple.

Can anyone will be help me out to create a user form.

for eg:

Brand numbers  Invoice numbersStatus
90121   97012 2
90121   97013 0
90121   90124 1

Regards,
Ganeshan

On Wed, Nov 12, 2014 at 11:23 AM, Kamal Ganeshan
ganesh.theva...@gmail.com wrote:
 Hi All,

 Need some help to create a User form based on the logic.

 If any enter Sub Brand numbers in cell F12  Invoice number in cell
 G12 then I want the H should be update automatic as per the above
 table numbers.

 I have done the exercise which is manual Vlookup formula but i need
 the same logic in User form VBA .

 Requesting you to please do the needful  revert.

 Regards.
 Ganeshan

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

 FORUM RULES

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

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

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

FORUM RULES

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

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

$$Excel-Macros$$ Only Excel formuala

[Kamal Ganeshan]

Hi Friends,

Can anyone help me with the excel formula for the attached list of question

Regards,
Ganeshan

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

FORUM RULES

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

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


Excel Test_2014_Tanveer Khan.xlsb
Description: Binary data

Re: $$Excel-Macros$$ Only Excel formuala

[Kamal Ganeshan]

Awesome,

Appreciate a lot for really good information.

Regards,
Ganeshan

On Tue, Aug 26, 2014 at 1:39 AM, Pramod Singh pramod...@gmail.com wrote:
 Hi
 Kamal Ganeshan

 Please find the attached file i cheersss


 Regards
 Pramod


 On Tue, Aug 26, 2014 at 12:16 AM, Kamal Ganeshan ganesh.theva...@gmail.com
 wrote:

 Hi Friends,

 Can anyone help me with the excel formula for the attached list of
 question

 Regards,
 Ganeshan

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




 --
 PramodSingh

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

 FORUM RULES

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

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ need help on maximum value and thier name

[Kamal]

सुनिता पौडेल tosune...@gmail.com wrote:

Guys do me one favor again!!
Thanx

On Mon, Jun 25, 2012 at 6:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 ** **

 ** **

 =INDEX(A2:A15   B2:B15,MATCH(MAX(B2:B15),B2:B15,0),1) with CSE

 ** **

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed
 *Sent:* 25 June 2012 12:32
 *To:* excel-macros@googlegroups.com

 *Subject:* Re: $$Excel-Macros$$ need help on maximum value and thier name*
 ***

 ** **

 PFA

 On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com
 wrote:

 Dear all,

  

 It has always been previlege to query on this group whenever needed and
 thanks from heart.

  

 I need one help regarding finding out maximum number and their name in one
 cell ?

  

 Have a wonderful day !!

  

 Thank you!!

 Sunita

  

 P.S: in case if file not attached(having probs)

  

 name

 amount

 * Bijay Barma *

 11640

 * Binod Barma *

 10983

 * Manoj Barma *

 10983

 * Jitendra Barma *

 16215

 * Birbal Sunar *

 15207

 * Dinesh Rokaya *

 28742

 *Nisha Basnet*

 10041

 *Daman Raj Aidi *

 11356

 *Nara Rawat*

 32130

 *Surya Buda*

 10001

 *Binita Bam*

 9699

 *RajKumar Rawat*

 29512

 *Shiva Thapa*

 28393

 *Rajesh Singh*

 10365

 *Can we find maximum number and their name in one cell or different?*

 *Can we find 2nd maximum number and their name/*

 *Likewise from greates to least number?*

  

  

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

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

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

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

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

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

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


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

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

  

 ** **

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

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


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

Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

[kamal ganeshan]

Just follow few steps below

data=import External Data = select the ftxt file option then select the txt
file and press alt +d + e (text to colums)delimited and click on other and
next other option one box is given just press shift + \ it will show you
this | and then next and finish

txt file will be convert into excel

Regards,
Ganesh


On Tue, Jul 12, 2011 at 9:03 AM, Susan sunni...@gmail.com wrote:

  I did that.  See the excel spreadsheet I attached.  My question was how
 can I move over the imported txt file format and into the excel spreadsheet
 format under the appropriate column headings… I was thinking I did the Text
 Import Wizard incorrectly… and thought someone here had another way of doing
 it??

 ** **

 Thanks,

 Sunnie

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Sanjib Chatterjee
 *Sent:* Monday, July 11, 2011 9:16 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Convert Txt file into Excel into proper
 Columns

 ** **

 Open excel
 data=import External Data = select datasource=select the appropriate
 option=ok

 

 On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 sunni...@gmail.com wrote:

 Hi,
 Need your help.  How can I do this project faster than manually CTRL+ X ,
 then CTRL+ V , to delete and paste contact information into appropriate
 column headings?

 maybe I did the the Text Import Wizard incorrectly...

 Any help / ideas would be greatly appreciated!

 Thanks,
 Sunnie

 --

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

[kamal shah]

Thanks a ton Rohan!

Long Live, Excel-Macro group.


Cheers
Kamal

On Wed, Feb 23, 2011 at 5:15 AM, Rohan Young rohan.j...@gmail.com wrote:

 HI Kamal,

 Please see the attachment if it helps,


 Regards

 ROHAN


 On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 Dear Kamal,

 Please see attached sheet..if it help..

 On Mon, Feb 21, 2011 at 11:25 PM, kamal shah kamal...@gmail.com wrote:

 Hello Excel Gurus,

 Need small favour from experts,
 I have two columns in Excel, I need a macro, where if Column A contains
 value as Step, column B should populate Complete.
 If column A contains VP, Column B should populate Pass.


Step
   Complete
  VP
  Pass
  Step
  Complete
  VP
  Pass
  VP
  Pass
  Step
  Complete
  VP
  Not Run
  Step
  Not Run
  VP
  Not Run
  VP
  Not Run
  Step
  Not Run
  VP
  Not Run


 Your help is highy appreciated.


 cheers
 Kamal

 --

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

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

[Rahul Kamal Gandhi]

Sir,

I don't know your expertise level in excel, the only one solution I Can give
you with the help of formulas only. Not with the macros.

Please find attached for your reference.


Regards, Rahul Gandhi
+91-9711772297



On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain vebhav.j...@gmail.com wrote:

 Hi All,

 Please help me in finding the missing entries from the below data.

 ListAListB
   1   1
   2   3
   3   5
   4
   5

 Regards
 Vebhav Jain

 --

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


Vaibhav Jain - Missing Value - Rahul Gandhi.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Problem regarding sum

[Rahul Kamal Gandhi]

Sir,

As per my interpretation your output is in Attached file.


Regards, Rahul Gandhi
+91-9711772297



On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca santanu...@gmail.com wrote:

 I want to Add two digit or multiply as this way.

 Column A   Column B
  Rs. 5.00Rs. 10.00  =   Can I sum two cells by formula ?
  Rs. 5.00Rs. 10.00  =   Can I multiply Two Cells by formula
 ?


 --

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


Santanu_CA - Sum  Multiply - Rahul Gandhi.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

[Rahul Kamal Gandhi]

Vaibhav,

I wrote an macro in excel where in the macro automatically find the to, cc, 
subject, mail body, attachment name, attachment extention, and attachment path, 
send on behalf of name

The above attributes are already been defined in excel

What actually I want is to do some formatting in mail body

The trailed mail is carrying an example that how I need the bold in some parts 
of mail body

Wanna help in VBA function. 



Sent from my iPhone

On Nov 30, 2010, at 12:40 PM, in.vaib...@googlemail.com 
in.vaib...@gmail.com wrote:

 Dear Rahul
 
 Pl explain the procedure, if you are saying you will be sending it to 9000, 
 then will you be using mail merge or not.
 
 If not how u will be sending (i.e. using which application) to 9000 employees.
 
 Rgds
 
 Vaibhav J
 
 
 
 On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. myname.ra...@gmail.com wrote:
 Sir,
 
 Thanks for the prompt action, But I have a Data of 9000 Employees.
 
 I have to Send the Letters to Employees without using the Mail Merge.
 
 Only with The Hlp of Concatenate.
 
 Eg.
 
 =Your Salary is increased with Rs. A1/- Please find enclosed
 attachment which contains the breakup of amount
 
 What actually I want is the Value which is derived from A1 should be
 Bold.
 
 
 Thanks.
 Rahul Gandhi
 
 On Nov 28, 9:37 pm, Dilip Pandey dilipan...@gmail.com wrote:
  Hi Rahul,
 
  I dont think there is any existing function using which you can bold
  at text. Considering your problem, I have thought of one smart way :-
  let say A1 has the text which needs to be bold. Go to B1 and type the
  formula =a1. Now apply conditional formatting in B1 that if cell B1 is
  not blank, then text should be bold. (=not(isblank(b1))  :)
 
  Best Regards,
  DILIPandey
 
  On 11/28/10, Rahul Kamal Gandhi myname.ra...@gmail.com wrote:
 
 
 
   Guys, Can anyone Help me to Bold the text with the help of Formula
 
   Eg.
 
   A1 Cell Contains ABC
 
   I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1)
 
   And My output should be *ABC* But in Bold Format
 
   Any Formula or Code.  Please Guys I am Struck
 
   Regards,
   Rahul Gandhi
   +91-9711772297
 
   --
   --
   Some important links for excel users:
   1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
   2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
   3. Excel tutorials athttp://www.excel-macros.blogspot.com
   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
   To post to this group, send email to excel-macros@googlegroups.com
 
   
   Like our page on facebook , Just follow below link
  http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;...
 
  --
  Sent from my mobile device
 
  Thanks  Regards,
 
  DILIP KUMAR PANDEY
MBA-HR,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/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

$$Excel-Macros$$ Bold a Text with Help Of Formula

[Rahul Kamal Gandhi]

Guys, Can anyone Help me to Bold the text with the help of Formula

Eg.

A1 Cell Contains ABC

I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1)

And My output should be *ABC* But in Bold Format


Any Formula or Code.  Please Guys I am Struck



Regards,
Rahul Gandhi
+91-9711772297

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

[kamal shah]

Simply said than done.

An IT Engineer starts career with Excel... reaches level of excellence in
various technology and toolsbecomes Manager/ Director/ VP... ends up
working again on Excel !!!

So nothing changes.. First love remains First forever !!!
Ask this question to any Director/VP in world, n it would be same answer.

Cheers Folks
Kamal
Director - www.tisyalimited.com

On Tue, Aug 31, 2010 at 3:35 PM, Rajesh Janardanan rajesh...@gmail.comwrote:

  Hi,

 I  Love excel because it makes the finance manager in me to be more and
 more creative in financial analysis and impress my bosses. SAP/Excel helped
 my career in a big way :-)
 best regards
 rajesh

   On Tue, Aug 31, 2010 at 5:04 PM, sudhir kumar sudhir.p...@gmail.comwrote:

 hi ,
 I love excel due to its mathematical interface, using excel is like u r
 solving a puzzle with some logic .

 On Tue, Aug 31, 2010 at 2:01 AM, obahor o oba...@gmail.com wrote:

 I love excel becuz it helps me excel in my day-to-day data
 manipulation and analytics solution.
 Mog

 Sent from my HTC Snap on the Now Network from Sprint®.

 -Original Message-
 From: Ayush jainayus...@gmail.com
 Sent: Sunday, August 29, 2010 10:05 PM
 To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ I love excel because...


 Hi Guyzz,

 Come on ..Please participate in this

 If you dont respond, It means that you dont love excel.

 Express yourself !!

 Thanks to those who responded quickly :)

 -Ayush Jain
 Group Manager

 On Aug 29, 1:26 am, Vinod N nvino...@gmail.com wrote:
  Excel makes life simple Be it an analysis or dashboard or reports
 or any
  daily activities.. Just Excel it.. [?]
 
  I consider Excel as an Ocean and my knowledge is only a spoonful... I
 really
  love it and can go gaga over it anytime and every-time...
 
  On the lighter note: My wife calls Excel as my mistress [?]
 Whenever she
  sees me glued to the computer [?].. its always MS Excel that i'm
 working
  on... AND get kicked...[?]..but still I Love Excel...
 
 
 
  On Sun, Aug 29, 2010 at 1:20 AM, Dilip Pandey dilipan...@gmail.com
 wrote:
   I love Excel because it is excellent anaylitics package  every user
   in the world is familar with its spreadsheets n welcomes the reports
   in Excel format.
 
   Thx n Regards,
   Dilip kumar pandey
 
   On 8/28/10, Ayush jainayus...@gmail.com wrote:
Its a very handy tool for any data analysis and reporting. - Ayush
Jain
 
  
 ---
 
Guyzzz, Let me know why you like excel so muchThe best response
will be published on the home page with thanks. Please continue in
this thread only just below my line I want to see the active
participation...
 
Thank u so much.
 
-Ayush Jain
Group Manager
 
--
 
  
 --
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
   http://twitter.com/exceldailytip
2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials athttp://www.excel-macros.blogspot.com
4. Learn VBA Macros athttp://www.quickvba.blogspot.com
5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com
 

HELP US GROW !!
 
We reach over 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
 
   --
   Sent from my mobile device
 
   Thanks  Regards,
 
   DILIP KUMAR PANDEY
MBA-HR,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 athttp://www.excel-macros.blogspot.com
   4. Learn VBA Macros athttp://www.quickvba.blogspot.com
   5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 
   To post to this group, send email to excel-macros@googlegroups.com
 
   
   HELP US GROW !!
 
   We reach over 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 Nhttp://cavinod.blogspot.com/
 
   538.gif
   1KViewDownload
 
   361.gif
   1KViewDownload
 
   B0C.gif
   1KViewDownload
 
   347.gif
   1KViewDownload

$$Excel-Macros$$ Help needed- Macro to repeat lines 10000 times

[kamal shah]

Hi group

I have piece of XML for example below which i need to repeat it for 1
times
May I request one of expert to develop a simple macro which will use Paste
command and paste piece of lines for 1 times.


Cheers
Kamal

P.S
Sample XML


TRACONCO1

NamCO17KARV G./NamCO17

StrAndNumCO122DU PONT/StrAndNumCO122

PosCodCO12365487/PosCodCO123

CitCO124ROME/CitCO124

CouCO125IT/CouCO125

TRACONCO1LNGIT/TRACONCO1LNG

/TRACONCO1

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


HELP US GROW !!

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

$$Excel-Macros$$ Need Help !!

[kamal shah]

I have piece of MACRO as below,

Sub LaunchHMRCMARK()
Dim NTCUSER As String
MARKPATH = InputBox(Enter HMRCMARK PATH -  )
'Filename = InputBox(Enter XML file name here - )
Set oshell = CreateObject(WScript.Shell)
oshell.Run cmd, 9
Sleep 100
oshell.SendKeys (cd )
oshell.SendKeys MARKPATH
oshell.SendKeys ({ENTER})
oshell.SendKeys (Set PATH=C:\Program Files\Java\jre1.5.0_07\bin;%PATH%)
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
oshell.SendKeys ({ENTER})
Sleep 100
oshell.SendKeys (hmrccsp)
Sleep 100
oshell.SendKeys ( )
'oshell.SendKeys FILEPATH
'Sleep 100
'oshell.SendKeys (\)
'oshell.SendKeys Filename
'oshell.SendKeys ({ENTER})
End Sub

Once I run this, it generates a set of XML Code into Command prompt (DOS)
window.
I would like to extract this text string and store it on Excel,

My question is, will MACRO be able to do this?


TA

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


HELP US GROW !!

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

$$Excel-Macros$$ Excel Macro for Dos Prompt

[kamal shah]

Hi Group,

I am looking for a Macro, which can execute commands on DOS Prompt.
My actual requirement is, to pick up each cell value (which is apparently a
DOS command ) and execute them on command prompt.

Macro needs to do following,

1. pick up value from Cell
2. Open Command prompt ( start -- cmd)
3. Change Directory - (cd c:\temp)
4. Paste VALUE picked from line 1


Your help on this will be highly appreciated.

Cheers
Kamal

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

[kamal shah]

Its Possible !!!

Here is a solution what you are looking.






Add a Picture to an Excel Comment

   1. Right-click the cell which contains the comment.
   2. Choose *Show/Hide Comments*, and clear any text from the comment.
   3. Click on the border of the comment, to select it.
   4. Choose *Format*|*Comment*
   5. On the *Colors and Lines* tab, click the drop-down arrow for *Color*.
   6. Click *Fill Effects*
   7. On the picture tab, click *Select Picture*
   8. Locate and select the picture
   9. To keep the picture in proportion, add a check mark to *Lock Picture
   Aspect Ratio*
   10. Click *Insert*, click OK, click OK



Cheers

KAMAL


On Mon, May 31, 2010 at 4:35 PM, Alfred WALLACE jos...@gmail.com wrote:

 its impossible ??

 .thx
 José

 On 31 mai, 07:39, Alfred WALLACE jos...@gmail.com wrote:
  Hi to all,
  and first od all, sorry for my poor english ...
 
  so,
  how can i show à graphic inside a popup windows (or other thing)
  at then moment my mouse go over a cell (or range of cells)
  all graphics exist, I only want to make them appear as popup
  when mouse flies over a particular range
 
  thanks a lot !!!
 
  José from France

 --

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

[kamal shah]

Any takers for this call?



On Fri, Dec 18, 2009 at 3:32 PM, kamal shah kamal...@gmail.com wrote:

 Hello Excel Gurus,

 I have a task of copying data (specific column from specific place) to a
 new work book's worksheet at specific column from specific cell.
 I have attached both work books for reference here.

 ST - Original Workbook.
 AT - Target Workbook

 my requirement is
 Map E19 onwards Column of ST to F Column of AT = Session Date
 (Into next down cell of text value - DATE)
 Map F19 onwards Column of ST to H Column of AT = Function (Into
 next down cell of text value - FUNCTION)
 Map G19 onwards Column of ST to G Column of AT = Description
 (Into next down cell of text value - Event)
 Map H19 onwards Column of ST to I Column of AT = Comments (Into
 next down cell of text value - Check)

 I hope you got what my requirements is.

 I have to merge almost 300 plus excel files into a new format.

 Any help on this will be highly appreciated.
 Even if I get a code to copy/paste one column, I should be able to do it
 iteratively for all columns.

 thanks once again!



 --

 --
 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$$ Automatic compilation of 5 file in to one

[kamal shah]

In master file (where you want data to be populated) just provide a link of
respective cells ( of Branch files - in your case)
So as n when you open Master file, it will come up with a pop up saying that
-  links available.. do you want to update.. press update n ur data will
in masters !

Cheers
Kamal

On Sun, Dec 20, 2009 at 5:07 AM, Muneer Ansari
muneerahmadans...@gmail.comwrote:

 Hi,


Is it Possible to compile 5 files into one master file automatically, I
 have 5 files from 5 different branch offices and one master file ie:- 5
 files from branch are A,B.C,D  E, these file have branch name, pod dispatch
 date and pod number like this


 *BRANCH-A* ** ** *BRANCH-B* ** ** *BRANCH-C* ** ** *BRANCH-D*
 ** ** *BRANCH-E* ** *BRANCH* *DATE* *POD NUMBER* ** *BRANCH* *DATE* *POD
 NUMBER* ** *BRANCH* *DATE* *POD NUMBER* ** *BRANCH* *DATE* *POD NUMBER* **
 *BRANCH* *DATE* *POD NUMBER* A 1-Dec-09 Z1259 B 1-Dec-09 X1478 C 1-Dec-09
 Y4578 D 1-Dec-09 J7892 E 1-Dec-09 F2569 A 2-Dec-09 Z1260 B 2-Dec-09 X1479
 C 2-Dec-09 Y4579 D 2-Dec-09 J7893 E 2-Dec-09 F2570 A 3-Dec-09 Z1261 B
 3-Dec-09 X1480 C 3-Dec-09 Y4580 D 3-Dec-09 J7894 E 3-Dec-09 F2571 A
 4-Dec-09 Z1262 B 4-Dec-09 X1481 C 4-Dec-09 Y4581 D 4-Dec-09 J7895 E
 4-Dec-09 F2572 A 5-Dec-09 Z1263 B 5-Dec-09 X1482 C 5-Dec-09 Y4582 D
 5-Dec-09 J7896 E 5-Dec-09 F2573


 Now I want to compile all these file in to one master file automatically
 like this

   *MASTER FILE* ** ** ** ** *DATE* *A* *B* *C* *D* *E* 1-Dec-09 Z1259
 X1478 Y4578 J7892 F2569 2-Dec-09 Z1260 X1479 Y4579 J7893 F2570 3-Dec-09
 Z1261 X1480 Y4580 J7894 F2571 4-Dec-09 Z1262 X1481 Y4581 J7895 F2572
 5-Dec-09 Z1263 X1482 Y4582 J7896 F2573

 Anybody having some idea about this ?

 --
 Past Can not be change but future can be change by effectively utilizing
 today

 --

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


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

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

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

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

HELP US GROW !!

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

$$Excel-Macros$$ Managing TELNET Session with Macro

[kamal shah]

Hi Excel-Experts !

I wish to build a Macro which does some routine work on UnixBoxes via
launching Telnet.
I can successfully launch Telnet Session using SHELL command but further if
I wish to type in using Macro I am not...

Please anyone can share an idea to make it work?

cheers
Kamal

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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: unprotecting pdf files

[kamal shah]

send me PDF file and i get it unlocked for you!

kamal

On Wed, Oct 14, 2009 at 10:42 AM, Bhairav Chhaya bhairavchh...@gmail.comwrote:

 Hi,
 The file is asking for a password ?

 Regards
 Bhairav

 2009/10/14 hari kumar prekkeh...@gmail.com

  Hi All,
 Can anyone unprotect the files.
 --
 Hari kumar
 Our strength grows out of our weaknesses.




 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: saving VBA-created objects

[kamal shah]

Could you paste your Macro Codes here and probably it will be easy to
identify solution.
May be your macros are event based.

Kamal

On Mon, Aug 24, 2009 at 5:09 PM, Joseph Choi jsk.c...@gmail.com wrote:

 you may need to save the user input state of your controls (combo box,
 listbox) and save it on your workbook, into cells.  then, at startup (or
 workbook/sheet load), read these values and reapply them to your controls.

 of course, someone here may have a solution to actually save the form.

 On Mon, Aug 24, 2009 at 8:41 AM, Jene jene.grandm...@gmail.com wrote:


 Hi all, I'm new to your board and hope you might be able to help me
 out. I've been searching for an answer to this problem and coming up
 empty - maybe I'm not using the correct terms. I have a set of macros
 that create combo and list boxes on a worksheet in my workbook. When
 you click on a command button it populates all of those boxes based on
 cell inputs. If I save the workbook, all of the boxes are still
 populated, but when I close and re-open the saved workbook the data
 disappear. What am I doing wrong here?




 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Dynamic Menu Creation - EVent bassd

[kamal shah]

Hi Team,

I wrote piece of code to generate Dropdown Menu and call various Macros from
it.
This piece of code makes Menu permanent. My requirement is when User open
specific WorkBook and in specific Workbook a Specific Sheet, then only
custom Dropdown menu should appear.

Any help on this will be highly appreciated.

Here is a code I used to create Menu for Macros,


' GENERATE MENU ITEM WITH NAME AS Macros


Sub AddNewMenu()
Dim HelpIndex As Integer
Dim NewMenu As CommandBarPopup
HelpIndex = CommandBars(1).Controls(Help).Index
' CommandBar 1 = Menu
' msoControlPopup = builtin constant
' Before = Position on Menu
' Temporary, if it is True then Menu will be available as long as Excel is
open,
'if False then it will permanent.
' Menu Name = Macros
Set NewMenu = CommandBars(1) _
.Controls.Add(Type:=msoControlPopup, _
Before:=HelpIndex, Temporary:=False)
NewMenu.Caption = Macros
End Sub


' MAcro to add Macros to  Menu

Sub AddMenuItem()


Set Item = CommandBars(1).Controls(Macros).Controls.Add
' Macro - Combine
Item.Caption = UpdateAwardValues
Item.OnAction = UpdateAwardValues
Item.BeginGroup = True

End Sub
===



Kamal

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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: Help with formatting and subtotal

[kamal shah]

USe Pivot Table .. Probably that will give solution what you are looking
for.

Kamal

On Sat, Aug 15, 2009 at 6:57 AM, vivek agrawal vivek.agrawa...@gmail.comwrote:

 Hi
 Attached is the solution to problem.. you just need to hide to column
 C.

 Hope this helps

 Thanks and Regards,
 Vivek Agrawal
 Skype ID - vivek.agrawal83

 GoogleMoonlight.com  - Saving energy-Save Earth




 On Sat, Aug 15, 2009 at 1:34 AM, Cesar Delanoval cdelano...@gmail.comwrote:


 I have a simple table of banking transactions.
 Columns are as follows

 Column A = Date in MM/DD/YY format
 Column B = Empty
 Column C = Unit ID
 Column D = Empty
 Column E = Amount (numeric, 2 decimals)
 Column F = Empty
 Column G = Check No
 Column H = Subtotal

 On this sheet, the transactions are listed and sorted by date.  There
 could be several transactions on a single date or just one transaction
 on a single date.

 I am looking for a way to Subtotal the column E (Amount) by date and
 show that Sub-Total on colum H (see attached sample which was done
 manually)

 As an addional formatting I also like to place like from column A to
 column H whenever the subtotal is calculated to visually show the
 group of transactions within that subtotal.

 see sample below

 DateUnit ID Amount  Check NoSubTotal
 7/10/2009   5220363.39  1083
 7/10/2009   3103222.25  6754
 7/10/2009   5118222.25  2508
 7/10/2009   3102211.88  1232
 7/10/2009   3218188.37  393
 7/10/2009   3206211.88  2704
 7/10/2009   6211188.37  0
 7/10/2009   6221195.00  785
 7/10/2009   3220363.39  414 2166.78
 7/13/2009   4218188.37  480
 7/13/2009   3117270.00  712
 7/13/2009   4106267.30  5026725.67
 7/14/2009   6227188.37  2206
 7/14/2009   6216188.37  798 376.74
 7/16/2009   6229211.88  6285211.88
 7/17/2009   5110222.25  613
 7/17/2009   5229211.88  3287
 7/17/2009   6209268.12  1061702.25

 The number of transactions varies so it is never the same.


 if anyone has a question, feel free to call me.

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

$$Excel-Macros$$ Re: Need Help on Macro - image Resizing

[kamal shah]

Thanks Andy,

Let me try and come back.

cheers,
Kamal

On Thu, Aug 6, 2009 at 5:22 PM, Aindril De aind...@gmail.com wrote:

 Dear Kamal,

 Just add the following line to the top of your code to select all pictures
 in the worksheet

 ActiveSheet.Pictures.Select

 Hope this helps.

 Otherwise please post your code here so that we can take a alook.

 Regards,
 Andy

 On Thu, Aug 6, 2009 at 4:51 PM, kamal shah kamal...@gmail.com wrote:

 Hi Excel Gurus,

 I am looking for help to solve one of mechanical process in Excel sheet.
 I have more than 50 screeenshots pasted in Worksheet (as part of Business
 evidence).
 I wish to reduce (Image) Size by 50 % of all screenshots pasted in
 worksheet in one go.

 I did play around with Macro and could achieve doing it in one click (
 Plain record and Play kind of macro) but I get stuck up to select all images
 in worksheet.

 any help on this will be highly appreciated.

 Kamal



 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: Need Help on Macro - image Resizing

[kamal shah]

thanks Andy.

It worked !!

Kamal

On Thu, Aug 6, 2009 at 5:22 PM, Aindril De aind...@gmail.com wrote:

 Dear Kamal,

 Just add the following line to the top of your code to select all pictures
 in the worksheet

 ActiveSheet.Pictures.Select

 Hope this helps.

 Otherwise please post your code here so that we can take a alook.

 Regards,
 Andy

 On Thu, Aug 6, 2009 at 4:51 PM, kamal shah kamal...@gmail.com wrote:

 Hi Excel Gurus,

 I am looking for help to solve one of mechanical process in Excel sheet.
 I have more than 50 screeenshots pasted in Worksheet (as part of Business
 evidence).
 I wish to reduce (Image) Size by 50 % of all screenshots pasted in
 worksheet in one go.

 I did play around with Macro and could achieve doing it in one click (
 Plain record and Play kind of macro) but I get stuck up to select all images
 in worksheet.

 any help on this will be highly appreciated.

 Kamal



 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

[kamal shah]

Hi Shivashankar.

Remove Private from VB Macro build, save and Close VB window n your job
done.

Any issues, please shout.

Kamal

On Wed, Aug 12, 2009 at 3:15 PM, shivashankar katageri 
shankarkatag...@gmail.com wrote:

 Hello every body,

 I am unable to use this function in excell work book,whether it is
 possible? I am dont know about  VBA,Please helpm of using this TIP,

 Regards

 On Tue, Aug 11, 2009 at 1:27 PM, ankur ankurpande...@gmail.com wrote:


 hello friends
 i dont know much about vba
 i had bring calender to my sheet, but don't know how to proceed
 further,can anybody guide me
 i had written the code
 my query is how to insert the date by using calendar, i can see only
 embedded calendar on my sheet

 Have A Nice Time  Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~



 On Tue, Aug 11, 2009 at 11:24 AM, Iqbal Shaikhiqbal.sw...@gmail.com
 wrote:
  Dear Deepak,
 
 
  Thanks a ton !!
 
 
 
 
  Iqbal
  
 
  On 8/11/09, Deepak Rai daksh1...@gmail.com wrote:
 
  Hi,
 
  In the Developer Tools click on More Controls  then select Calender
  Control 12.0.
  Please follow the below steps to get the Calender Control:
 
  1. Right Click on Menu Bar
  2. Select Customize Quick Access Toolbar..
  3. Select Customize option
  4. In the Choose commands from drop down
  5. Select Developer Tab
  6. Select Insert Controls option
  7. Don't forget to select the option Show Quick Access Toolbar below
 the
  Ribbon
 
  Hope this will help you.
 
  Regards,
 
  Deepak Rai
 
 
  On Mon, Aug 10, 2009 at 1:38 PM, Iqbal Shaikh iqbal.sw...@gmail.com
  wrote:
 
  Hi ALL.
 
  How to use this calender in XL 2007.
 
 
 
 
  Iqbal Shaikh
 
 
  On 8/7/09, Ayushj jainayus...@gmail.com wrote:
 
  Hi Shafiq,
 
  This is the awesome tip. Appreciate your knowledge. :)
  regards,
  Ayush Jain
 
  On Aug 7, 3:48 pm, shafiq online shafiq_onl...@hotmail.com wrote:
   Dear All,
  
   Here is a tip for pop up calendar in Excel. You can display a
 clander
   in a excel sheet and enter date in a cell by slecting the
 appropriate date.
   Steps are given below;
  
   1. Open excel work book.
  
   2. go to wiewToolbarsControll Toolbox
  
   3. Now u can see a toolbox window in the sheet. Go to last button
   (more controll) and clink on it. Here u can see a list of controls,
 click on
   Calendar control 11.0
  
   4. Adjust the clander in the sheet where you required to be
 diplayed
   this.
  
   5. Important steps. Double click on calender or right click, then
 view
   code following code will diplay
  
   Private Sub Calendar1_Click()
  
   End Sub
  
   6. Enter following lind between 1st and last line
  
   ActiveCell.Value = Calendar1.Value
  
   7. Your code will look like this
  
Private Sub Calendar1_Click()
   ActiveCell.Value = Calendar1.Value
   End Sub
  
   8. Get out of VBA and go to excel sheet and use the calender.
  
   Regards,
  
   _
   Share your memories online with anyone you
   want.
 http://www.microsoft.com/middleeast/windows/windowslive/products/phot...
 
 
  --
  Thanks,
 
  Deepak Rai
 
 
 
 
  --
 
 
 
 
 
  Iqbal Shaikh
  
 


 --
 Thanks  Regards

 Shivashankar.C.Katageri.


 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Need Help on Macro - image Resizing

[kamal shah]

Hi Excel Gurus,

I am looking for help to solve one of mechanical process in Excel sheet.
I have more than 50 screeenshots pasted in Worksheet (as part of Business
evidence).
I wish to reduce (Image) Size by 50 % of all screenshots pasted in worksheet
in one go.

I did play around with Macro and could achieve doing it in one click ( Plain
record and Play kind of macro) but I get stuck up to select all images in
worksheet.

any help on this will be highly appreciated.

Kamal

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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: When searching Ctrl F default to workbook vs. sheet

[kamal shah]

Hi JMR,
ow you do Control Find and data will be fetched from all Sheets.

hope this helps,

Kamal

On Wed, Jul 22, 2009 at 3:00 PM, JMR jmr...@gmail.com wrote:


 How can I configure Excel so that when I do a search it defaults to
 searching the whole workbook vs. just the sheet.  It is a pain to have
 to make sure workbook is selected everytime I do a search.  I have a
 screen shot but do not see where to add it to this post.

 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Re: Currency Conversion macro

[kamal shah]

Are you looking for standard Exchange Rate or a variable?
If so then u dont need macro for it. you can get it done with simple
formula..

let me know if u need it.

kamal

On Sun, Jul 19, 2009 at 6:09 PM, krishnan moorthy
krishnanm2...@gmail.comwrote:


 Dear Moderators,

 I am a beginner to the excel macro world. Needed your assistance to
 create a macro that can convert currency i.e. Dollars and Euros to
 Rupees and vice versa.

 Any help with this is highly appreciated.

 Thanks in advance!


 Krishnan Moorthy




 


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

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

HELP US GROW !!

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

$$Excel-Macros$$ Fwd: $$Excel-Macros$$

[Kamal Gulati]

kindly help by sending Advance Ebook on Excel.

-- Forwarded message --
From: bathina srinivasa rao ask_...@rediffmail.com
Date: Sun, May 10, 2009 at 5:48 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com


kindly help by sending Ebook on Excel.

regards,

B.SRINIVASA RAO
http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline@middle?



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

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

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

$$Excel-Macros$$ Re: E Book on Excel.

[Kamal Gulati]

Dear Hari,
Plz send the advance book of excel along with the VBA and MACROS using
excel.

regards,

Kamal Gulati

E-mail:kamalgula...@gmail.com

On Sat, May 9, 2009 at 9:57 AM, hari kumar prekkeh...@gmail.com wrote:

 Hi Prateek,

 FYI.
 This book covers basics. if need more details or advanced, let me know.

 Regards
 Hari Kumar

 On Fri, May 8, 2009 at 11:46 AM, PRATEEK PAHWA pahwa.prat...@gmail.comwrote:


 Hi All,

 Please help me out with an Ebook on excel.

 Thanks  Regards
 Prateek Pahwa





 --
 Hari kumar

 


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

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

$$Excel-Macros$$ Re: single password for excel

[Kamal Gulati]

Plz help me to crack the password for MS - Word.
Thanks and regards,

Kamal Gulati




On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte praveen.khu...@gmail.comwrote:

  Install Ultimate Add-in attached along with the mail. Explore the options,
 I m sure you can break passwords of excel *worksheet* and *module*.
 In case of problems, revert back

 Praveen Khunte


 Prashanth Banneni wrote:

 Hi all,

 Can any one give me the password breaker tool.

 Thanks in advance

 Regards,
 Prashanth

  On Sat, May 2, 2009 at 3:06 PM, girish gv giritri...@gmail.com wrote:

 post the file i will break the password

 On 12/19/08, jasm...@1908 manjit2...@gmail.com wrote:

  HI there,….



 Send me the file and I will break the password and give you the new
 password..



 Regards..



 Manjit Singh


  --

 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *AMARNATH RAVEENDRANATH
 *Sent:* 16 December 2008 09:12 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: single password for excel



 Hello All



 I have forgotten my password for an excel. Is there a way to retrieve it
 or delete it.



 Thanks  Regards

 Amar











 



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

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

Fwd: $$Excel-Macros$$ Re: Convert pdf to excel

[Kamal Gulati]

Dear,
Could you please send me the software Able2Extract or the link from where I
can download the full version of the software.

Thanks and regards,

Kamal Gulati



On Tue, Mar 17, 2009 at 1:41 PM, Chinmay Antani
chinmayantan...@gmail.comwrote:

 ajay i have a sofwatre called Able2extract which converts pdf to any
 format...i hope that might solve ur problem..

 convey it to me hw shuld i forward it to u...

 gd day..

 On Tue, Mar 17, 2009 at 1:04 PM, ajay kashyap connect2a...@gmail.comwrote:

 Hi there,

 Is there any help on conversion of PDF to excel in the same format. Its
 very challenging for me.Thanks in anticipation.

 Regards,

 --
 Ajay Kashyap





 --
 regards,

 ION-Chinmay J Antani
 Remembered by Dreamz,Recognized by Deeds
 www.ionbangalore.org

 



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

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

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

$$Excel-Macros$$ Re: Help-Excel files formula

[Tariq Kamal]

Hi Rabindra,

Please find the attached file with the formula in table B.

Regards,
Tariq Kamal
www.gate2quality.com



On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa rabinthapa2...@gmail.comwrote:


 Please help me on attach files.
 --

 Regards,
 Rabindra Thapa
 ¨`·.·´¨) Always
 `·.¸(¨`·.·´¨) Keep
 (¨`·.·´¨)¸.·´ Smiling!
 `·.¸.·´
 (¨`·.·´¨) (¨`·.·´¨)
 `·.¸(¨`·.·´¨)¸.·´
 `·.¸.·«*:·.
 .·:*
 *:·.
 *«*:·.
 .·:*
 *:·.

 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---



help.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Find Add

[Tariq Kamal]

Here is the code to do it

 Cells.Find(What:=Apple, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate

ActiveCell.FormulaR1C1 =  Mr.   ActiveCell
In the first line of code it asks what do you want to searc like i have put
Apple and then in teh last line it says that when it finds apple then the
cell containing apple wil be active and then it says to put Mr. before
apple...

If you want you can refer a cell and then put different thing in it to
search and when ever you run the macro it will search and put Mr. before it,
for that the code will be changed as


Cells.Find(What:=Worksheets(Sheet1).Cells(1,2), LookIn:=xlFormulas, LookAt
_
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate

ActiveCell.FormulaR1C1 =  Mr.   ActiveCell

Here it will search for anythng that is put in B1 of sheet1

Hope it helps

Tariq Kamal
www.gate2quality.com
www.rideahead.blogspot.com



On Mon, Jan 19, 2009 at 7:14 PM, H Upadhyay harishcupadh...@gmail.comwrote:

 Dear Group,

 Need ur help, pls suggest is it possible some macro or formula find some
 specific text from data  Add some text in before the text

 e.g in a lage data base i have some name containing
 Kumar,Kaur,Chandra, Kumari

 if name contains Kumar then Mr. will add as prefix like

 Pradeep Kumar Sharma  Mr. Pradeep Kumar Sharma
 Kiran Kumari -- Ms Kiran Kumari
 Harish Chandra Upadhyay    Mr. Harish Chandra Upadhyay

 will appreciate ur valuable revert

 Thanks in anticipation

 Thanks  Regards
 Harish Upadhyay
 9773284902


 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Protect Cell Content on Input Result

[Tariq Kamal]

It can be doen by writing a simple macro, wherein you will have to use two
properties

You will have to mention that a prticular cell in column A if it is true
then select the corresponding cell in column B / C / D and then

Selection.Locked=True
and
ActiveSheet.Protect (Password)

these two will do the job


On Tue, Jan 20, 2009 at 6:09 PM, lukethegooner lukethegoo...@gmail.comwrote:


 Hi all!

 I'm looking to protect a number of cells, or, make them 'read only' if
 you like dependant on the result of the inpurt from a certain cell.
 The spreadsheet I'm composing is to be sent out to a third party for
 input so I want to tie down some detail without making it look too
 daunting.

 To try and put some details here, consider thus

 A  B  C   D
 1   True  1  100%
 2   False

 So in the above example, if the cell A1 was configured 'True' then
 cells B1, C1 and D1 would behave normally and be open to edit.

 If Cell A2 is configured False, then cells B2, C2 and D2 would go
 blank (or display a message) and the cells would become 'read only' /
 inaccessible for edit.

 Can this be done easily in Excel?

 Luke

 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: msgbox limits and scrolling

[Tariq Kamal]

Hi,

Instead of a mssgbox use a userform.

Regards,
Tariq Kamal
www.gate2quality.com



On Thu, Jan 15, 2009 at 9:01 PM, mickeyc cohen.mic...@gmail.com wrote:


 Hi,

 I have a LOT of text I want to display on a msgbox and it doesn't fit.
 There's no error, it simply doesn't display all the text.
 What are the limitations? Is there a way around them?
 Is it possible to use scrolling?

 If none of the above can be done, what would be a good alternative?

 Thanks

 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: IF-THEN macro

[Tariq Kamal]

You have not mentioned any bracket, coma etc anywhere in the code...

Like
if(sheet1.cells(3,39))=4 then

you need to write the code in correct format first.

To lock the cell you can have the following code

Cells.Select
Selection.Locked = True

Regards,
Tariq Kamal
www.gate2quality.com


On Wed, Jan 14, 2009 at 6:00 AM, Thunderwhelmed april.hil...@gmail.comwrote:


 Hi all,

 I have a worksheet that contains a column of 8 dropdown lists (combo-
 boxes) from a range in a different sheet. I have the (numerical)
 results of each selection set up to display in a hidden column. In
 another cell, I used the COUNTIF function to count the results of all
 selections 0 (0=no selection).

 What I need to do is, based on that count, use a command button to
 activate another sheet in the same workbook, select a range of cells,
 then copy + paste into yet another sheet.

 Basically:

 if Cell C39=4, then
 Activate Sheet3
 Select range A1:M7
 Copy range
 Activate Sheet2
 Paste range into Sheet2, starting at cell A7.

 --OR--

 if Cell C39=5, then
 Activate Sheet3
 Select range A9:N15
 Copy range
 Activate Sheet2
 Paste range into Sheet2, starting at cell A7.

 etc, etc, when C39 = 6, 7, or 8

 I know it's all pretty much there, but I don't know the VB language.

 I would really appreciate some help!  Thank you in advance!

 April

 PS, does anyone know how to lock the contents of an entire sheet once
 that command button has been pressed? thanks!

 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Project Management Excel Sheet or Software

[Tariq Kamal]

Hi,

What all fields do you want to track and what all heads (date, eforrt,
etc) do you want in te sheet

Regards,
tariq kamal
www.gate2quality.com



On Mon, Jan 12, 2009 at 12:56 PM, Archana Mestry
glad_archu2...@yahoo.comwrote:

   Hi Guys  Gals,

 I need a project mangement excel sheet where I can track all the tasks and
 projects on periodically basis. Please help me to create that. Or if you are
 already using any kind of software for this, then please reply over this
 email.

 Help would be great appreciated. As I'm in really need of this.

 --
 Thanks  Regards,
 Archana


 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Unsubscribe

[Kamal Gulati]

May I know what is happening?
Y users are unsubscribing ??



On Thu, Jan 8, 2009 at 1:29 PM, shafiq warraich
shafiq.warra...@gmail.comwrote:

 me excel-macros@googlegroups.com tooo

 thanks

 -- Forwarded message --
 From: jyoti jyotisach...@gmail.com
 Date: Thu, Jan 8, 2009 at 11:48 AM
 Subject: $$Excel-Macros$$ Re: Unsubscribe
 To: excel-macros@googlegroups.com


 me t please..


 On 1/8/09, Rahul Roongta rahul_roon...@yahoo.com wrote:

   me too

 --- On *Thu, 8/1/09, Arora, Aman (GE Money) aman.ar...@ge.com* wrote:

 From: Arora, Aman (GE Money) aman.ar...@ge.com
 Subject: $$Excel-Macros$$ Re: Unsubscribe
 To: excel-macros@googlegroups.com
 Date: Thursday, 8 January, 2009, 11:41 AM

  Me too..

 Regards
 Aman S Arora



  --
 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *Madhu
 *Sent:* Thursday, January 08, 2009 11:40 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: Unsubscribe


 Please unsubscribe me too


 On Wed, Jan 7, 2009 at 10:06 PM, Soumya p soumya2...@gmail.com wrote:

 Hello,

 Please unsubscribe me too from this group.

 Regards,
 Soumya


 On Thu, Jan 8, 2009 at 12:54 AM, kris servai krisma...@gmail.comwrote:

 please unsubscribe me too.

 thanks in advance.

 On Wed, Jan 7, 2009 at 7:06 PM, Bhaskar Sharma 
 bhaskarsharm...@gmail.com wrote:

 Please unsubscribe me

 --
 Bhaskar S.





 --
 __
 The woods are lovely,dark and deep
 But i have promises to keep..
 Miles to go before i sleep..
 Miles to go before i sleep..
 --
 Uzhaippae Uyarvu Tharum






 --
 Bring your gang together. Do your thing. Find your favourite Yahoo!
 Group.

  
 http://in.rd.yahoo.com/tagline_groups_9/*http://in.promos.yahoo.com/groups/




 --
 Jyoti Sachdeva



 



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Need Help - VBA Excel!!

[Kamal Gulati]

*Dear All,*

* *

*I am new in this group. And I really like the posting that you all have
made. It's a very useful group as I am getting new things to learn. Could
you please provide with help for the following topics below.*

* *

*I would appreciate if some one can send the material for the following
topics.*

* *

*Thanks in advance.*

* *

*Regards,*

* *

*Kamal Gulati** – **India** (**New Delhi**)*

* *

*+91-9899101928, 9718361928*

*E-mail: kamalgula...@gmail.com*

* *

*TOPICS*

*Advance MS
Excel*
* **Formatting Numbers*

Apply number formats (accounting, currency, and number)

Create custom number formats

Use conditional formatting


*Working with Named Ranges*

Add and delete a named range

Use a named range in a formula

Use Lookup Functions (Hlookup or Vlookup)

Statistical Functions In Excel
* **Working with Toolbars*

Hide and display toolbars

Customize a toolbar

Assign a macro to a command button
* **Auditing a Worksheet*

Work with the Auditing Toolbar

Trace errors (find and fix errors)

Trace precedents (find cells referred to in a specific formula)

Trace dependents (find formulas that refer to a specific cell)
* **Displaying and Formatting Data*

Apply conditional formats

Perform single and multilevel sorts

Use grouping and outlines

Use data forms

Use subtotaling

Apply data filters

Extract data

Query databases

Use data validation
* **Using Analysis Tools*

Use the Microsoft PivotTable(R) autoformat

Use Goal Seek

Create Microsoft PivotChart(R) reports

Use data analysis and PivotTable
* **Collaborating with Workgroups*

Create, edit, and remove a comment

Apply and remove worksheet and workbook protection

Change workbook properties

Apply and remove file passwords

Create a shared workbook

* *

*Recording a Macro in Word and Excel*

Running and Recording a Macro in Word and Excel

* *

*Interactive Macros*

Creating and Using Dialog and Input Boxes

Extracting Data From Excel

* *
*Visual Basic for Applications Programming**
 **Introduction to Visual Basic for Applications*

Running and Recording a Macro

Examining Module Design

* *

*Assigning Macros*

Absolute and Relative Recording of Macros

Assigning Macros to Menus, Buttons, and Toolbars

* *

*Creating Decision Making Code*

The If-Then Decision Structure

The If-Then-Else and Select Case Decision Structures

* *

*Using **Loop** Structures*

For-Next Structures in VBA

Do- Loop and For Each-Next Structures in VBA

* *

*Macro Management*

Personal Macro Workbook and Automatic Procedures

* *

*Visual Basic Programming*

Data Access Objects, Using ADODC, Crystal Reports

Working with Variables and Procedures, Event and Error Handling, More
Controls.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Help

[Kamal Gulati]

 *Dear All, *

* *

*I am new in this group. And I really like the posting that you all have
made. It's a very useful group as I am getting new things to learn. Could
you please provide with help for the following topics below. *

* *

*I would appreciate if some one can send the material for the following
topics. *

* *

*Thanks in advance. *

* *

*Regards,*

* *

*Kamal Gulati** – **India** (**New Delhi**)*

* *

*+91-9899101928, 9718361928*

*E-mail: kamalgula...@gmail.com*

* *

*TOPICS*

*Advance MS
Excel *
* * *Formatting Numbers*

Apply number formats (accounting, currency, and number)

Create custom number formats

Use conditional formatting


*Working with Named Ranges*

Add and delete a named range

Use a named range in a formula

Use Lookup Functions (Hlookup or Vlookup)

Statistical Functions In Excel
* * *Working with Toolbars*

Hide and display toolbars

Customize a toolbar

Assign a macro to a command button
* * *Auditing a Worksheet*

Work with the Auditing Toolbar

Trace errors (find and fix errors)

Trace precedents (find cells referred to in a specific formula)

Trace dependents (find formulas that refer to a specific cell)
* * *Displaying and Formatting Data*

Apply conditional formats

Perform single and multilevel sorts

Use grouping and outlines

Use data forms

Use subtotaling

Apply data filters

Extract data

Query databases

Use data validation
* * *Using Analysis Tools*

Use the Microsoft PivotTable(R) autoformat

Use Goal Seek

Create Microsoft PivotChart(R) reports

Use data analysis and PivotTable
* * *Collaborating with Workgroups*

Create, edit, and remove a comment

Apply and remove worksheet and workbook protection

Change workbook properties

Apply and remove file passwords

Create a shared workbook

* *

*Recording a Macro in Word and Excel *

Running and Recording a Macro in Word and Excel

* *

*Interactive Macros *

Creating and Using Dialog and Input Boxes

Extracting Data From Excel

* *
*Visual Basic for Applications Programming *
* * *Introduction to Visual Basic for Applications *

Running and Recording a Macro

Examining Module Design

* *

*Assigning Macros *

Absolute and Relative Recording of Macros

Assigning Macros to Menus, Buttons, and Toolbars

* *

*Creating Decision Making Code *

The If-Then Decision Structure

The If-Then-Else and Select Case Decision Structures

* *

*Using **Loop** Structures *

For-Next Structures in VBA

Do- Loop and For Each-Next Structures in VBA

* *

*Macro Management *

Personal Macro Workbook and Automatic Procedures

* *

*Visual Basic Programming*

Data Access Objects, Using ADODC, Crystal Reports

Working with Variables and Procedures, Event and Error Handling, More
Controls.

* *











-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: is there any Filter macro

[Tariq Kamal]

Hi Shay,

The code for filtering is

Sub filter1()

Dim count As Integer
Dim i As Integer
count = 12
For i = 1 To count
Selection.AutoFilter Field:=2, Criteria1:=Cells(i, 4)
Next i
End Sub

What you need to do is write down the name of all the months in one column
say column D (that's why cells (i,4) ) starting from first row...This way it
will go to row 12 and hence the definition of i from 1 to count, where count
= 12

Hope this helps..

Regards
Tariq Kamal
http://www.gate2quality.com
http://www.rideahead.blogspot.com


On Fri, Jan 9, 2009 at 10:35 AM, shay shay shahinarafi...@gmail.com wrote:

 Hi All,

 can any one help me with a filter macro which will filter the all
 the invoices based on monthly basis like jan , feb etc and I also want to
 cretae pivot as well as chart togethere and this pivot and chart shd update
 automatically.

 --
 Shay

 A Thinker tends to use reason and logic

 A feeler tends to use values and subjective Judgement.

 Be a Thinker in Life.

 



--

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: is there any Filter macro

[Tariq Kamal]

Just forgot to mention that Field 2 means Second column in which filter is
applied



On Fri, Jan 9, 2009 at 11:10 AM, Tariq Kamal tariq.kamal@gmail.comwrote:

 Hi Shay,

 The code for filtering is

 Sub filter1()

 Dim count As Integer
 Dim i As Integer
 count = 12
 For i = 1 To count
 Selection.AutoFilter Field:=2, Criteria1:=Cells(i, 4)
 Next i
 End Sub

 What you need to do is write down the name of all the months in one column
 say column D (that's why cells (i,4) ) starting from first row...This way it
 will go to row 12 and hence the definition of i from 1 to count, where count
 = 12

 Hope this helps..

 Regards
 Tariq Kamal
 http://www.gate2quality.com
 http://www.rideahead.blogspot.com


 On Fri, Jan 9, 2009 at 10:35 AM, shay shay shahinarafi...@gmail.comwrote:

 Hi All,

 can any one help me with a filter macro which will filter the all
 the invoices based on monthly basis like jan , feb etc and I also want to
 cretae pivot as well as chart togethere and this pivot and chart shd update
 automatically.

 --
 Shay

 A Thinker tends to use reason and logic

 A feeler tends to use values and subjective Judgement.

 Be a Thinker in Life.

 



 --




-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Help - Excel VBA

[Kamal Gulati]

Dear All, 

 

I am new in this group. And I really like the posting that you all have
made. It's a very useful group as I am getting new things to learn. Could
you please provide with help for the following topics below. 

 

I would appreciate if some one can send the material for the following
topics. 

 

Thanks in advance. 

 

Regards,

 

Kamal Gulati - India (New Delhi)

 

+91-9899101928, 9718361928

E-mail: kamalgula...@gmail.com

 

TOPICS

Advance MS Excel



 


Formatting Numbers


Apply number formats (accounting, currency, and number) 

Create custom number formats 

Use conditional formatting 

 


Working with Named Ranges


Add and delete a named range 

Use a named range in a formula 

Use Lookup Functions (Hlookup or Vlookup) 

Statistical Functions In Excel


 


Working with Toolbars


Hide and display toolbars 

Customize a toolbar 

Assign a macro to a command button 


 


Auditing a Worksheet


Work with the Auditing Toolbar 

Trace errors (find and fix errors) 

Trace precedents (find cells referred to in a specific formula) 

Trace dependents (find formulas that refer to a specific cell) 


 


Displaying and Formatting Data


Apply conditional formats 

Perform single and multilevel sorts 

Use grouping and outlines 

Use data forms 

Use subtotaling 

Apply data filters 

Extract data 

Query databases 

Use data validation 


 


Using Analysis Tools


Use the Microsoft PivotTableR autoformat 

Use Goal Seek 

Create Microsoft PivotChartR reports 

Use data analysis and PivotTable 


 


Collaborating with Workgroups


Create, edit, and remove a comment 

Apply and remove worksheet and workbook protection 

Change workbook properties 

Apply and remove file passwords 

Create a shared workbook 

 

Recording a Macro in Word and Excel 

Running and Recording a Macro in Word and Excel

 

Interactive Macros 

Creating and Using Dialog and Input Boxes 

Extracting Data From Excel

 


Visual Basic for Applications Programming 


 


Introduction to Visual Basic for Applications 


Running and Recording a Macro 

Examining Module Design 

 

Assigning Macros 

Absolute and Relative Recording of Macros 

Assigning Macros to Menus, Buttons, and Toolbars 

 

Creating Decision Making Code 

The If-Then Decision Structure 

The If-Then-Else and Select Case Decision Structures 

 

Using Loop Structures 

For-Next Structures in VBA 

Do- Loop and For Each-Next Structures in VBA 

 

Macro Management 

Personal Macro Workbook and Automatic Procedures 

 

Visual Basic Programming

Data Access Objects, Using ADODC, Crystal Reports

Working with Variables and Procedures, Event and Error Handling, More
Controls.

 

 

 

 

 


--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Help - Excel VBA

[Tariq Kamal]

Some of the topic you can find on the site www.gate2quality.com

I will be updating the site with more stuff in coming days.



On Wed, Jan 7, 2009 at 10:17 AM, Kamal Gulati kgul...@amity.edu wrote:

  *Dear All, *

 * *

 *I am new in this group. And I really like the posting that you all have
 made. It's a very useful group as I am getting new things to learn. Could
 you please provide with help for the following topics below. *

 * *

 *I would appreciate if some one can send the material for the following
 topics. *

 * *

 *Thanks in advance. *

 * *

 *Regards,*

 * *

 *Kamal Gulati** – **India** (**New Delhi**)*

 * *

 *+91-9899101928, 9718361928*

 *E-mail: kamalgula...@gmail.com*

 * *

 *TOPICS*

 *Advance MS
 Excel
 *
 * * *Formatting Numbers*

 Apply number formats (accounting, currency, and number)

 Create custom number formats

 Use conditional formatting


 *Working with Named Ranges*

 Add and delete a named range

 Use a named range in a formula

 Use Lookup Functions (Hlookup or Vlookup)

 Statistical Functions In Excel
 * * *Working with Toolbars*

 Hide and display toolbars

 Customize a toolbar

 Assign a macro to a command button
 * * *Auditing a Worksheet*

 Work with the Auditing Toolbar

 Trace errors (find and fix errors)

 Trace precedents (find cells referred to in a specific formula)

 Trace dependents (find formulas that refer to a specific cell)
 * * *Displaying and Formatting Data*

 Apply conditional formats

 Perform single and multilevel sorts

 Use grouping and outlines

 Use data forms

 Use subtotaling

 Apply data filters

 Extract data

 Query databases

 Use data validation
 * * *Using Analysis Tools*

 Use the Microsoft PivotTable(R) autoformat

 Use Goal Seek

 Create Microsoft PivotChart(R) reports

 Use data analysis and PivotTable
 * * *Collaborating with Workgroups*

 Create, edit, and remove a comment

 Apply and remove worksheet and workbook protection

 Change workbook properties

 Apply and remove file passwords

 Create a shared workbook

 * *

 *Recording a Macro in Word and Excel *

 Running and Recording a Macro in Word and Excel

 * *

 *Interactive Macros *

 Creating and Using Dialog and Input Boxes

 Extracting Data From Excel

 * *
 *Visual Basic for Applications Programming
 * * * *Introduction to Visual Basic for Applications *

 Running and Recording a Macro

 Examining Module Design

 * *

 *Assigning Macros *

 Absolute and Relative Recording of Macros

 Assigning Macros to Menus, Buttons, and Toolbars

 * *

 *Creating Decision Making Code *

 The If-Then Decision Structure

 The If-Then-Else and Select Case Decision Structures

 * *

 *Using **Loop** Structures *

 For-Next Structures in VBA

 Do- Loop and For Each-Next Structures in VBA

 * *

 *Macro Management *

 Personal Macro Workbook and Automatic Procedures

 * *

 *Visual Basic Programming*

 Data Access Objects, Using ADODC, Crystal Reports

 Working with Variables and Procedures, Event and Error Handling, More
 Controls.

 * *









 




-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Excel Macro

[Kamal Gulati]

Dear Mr. Tom,

Even I also required some more examples on Excel, VB and Access for Macro.
If you any material for the same kindly send to me.

Thanks and regards,

Kamal Gulati

On Tue, Jan 6, 2009 at 2:14 PM, vijender kumar simplevi...@gmail.comwrote:

 Hi Tom,

 Thanks this book is very useful. but do you have any such book which has
 more examples of macro .I am very keen to learn macros to automate most of
 my process.

 Thanks.


   On 1/4/09, Kamal Gulati kamalgula...@gmail.com wrote:

 Thanks a lot Mr. Tom, for the nice file for the Macro.

 Could you also provide me the file for Access Macro's as I need to do with
 all these.


 I know this is not the group for Access but still if you provide me that I
 would be highly obliged.


 Thanks and regards,


 =
 - k...@m@l' g...@ti' -
 =
 Ph: +91 9899101928, 9718361928

  On Sun, Jan 4, 2009 at 8:59 PM, Tom Jeffries tjeff...@gmail.com wrote:

 Attached is a good introduction to Excel Macros provided by a member of
 this group.

 On Sat, Jan 3, 2009 at 11:22 AM, Kamal Gulati kamalgula...@gmail.comwrote:

 Hi friend,

 Can any one send me the simple steps and sample file to create Macro's
 in Excel.


 As  I am new in macro's in excel plz send me all the steps with example.




 Thanks and regards,


 =
 - k...@m@l' g...@ti' -
 =
 Ph: +91 9899101928, 9718361928

 -















 



-- 
=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-
Don't compare yourself with anyone in this world. If you do so, you are
insulting yourself.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Obtaining_VBA_MACRO_PASSWORD

[Tariq Kamal]

Hi Madhur,

Freewares are also available which can open the file and then you can reset
the password.

Regards,
Tariq



On Tue, Jan 6, 2009 at 6:59 PM, Tanzeem Ahmad tanzeemah...@gmail.comwrote:

 Hi Madhur,

 The passwords cud be changed . Like i Changed the password of this VBA to
 1234
 try and check it :)

 Regards
 Tanzeem

 On Mon, Dec 8, 2008 at 5:00 PM, madhur baharani madhur.bahar...@gmail.com
  wrote:


 Dear All,

I am very much thankfull for all the support and positive
 feedback.

 My query is how to recover the VBA_Password if someone forgotten it.

 Please find the attachment of the excel_files for which password is
 required.
 Also please do mail me the procedure of obtaining it.

 Thanks alot




 



-- 
http://www.gate2quality.com
http://www.rideahead.blogspot.com

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel Macro

[Kamal Gulati]

Hi friend,
Can any one send me the simple steps and sample file to create Macro's in
Excel.

As  I am new in macro's in excel plz send me all the steps with example.


Thanks and regards,


=
- k...@m@l' g...@ti' -
=
Ph: +91 9899101928, 9718361928

-

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit  Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---