$$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Hi Team,

I would like to know if I can use the value of one procedure as input
to the other procedure.

For example:

I have a user form, it has two command buttons, the first one is
requesting for a file location(address/path) and the second does also
requesting another file  location (address/path).

And in my next procedure I would like to open the file which is stored
in my first command button, similarly would like to open second
command buttion file.

Here is the code I have...

Public Sub IButton_Click()

Dim IFileName As Variant
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")

MsgBox IFileName

End Sub

Public Sub IIButton_Click()

Dim SFileName As Variant
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName

End Sub


Public Sub StartButton_Click()

Workbooks.Open IFileName
Workbooks.Open SFileName

End Sub

Thanks in advance.

Best regards,
Amar

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[NOORAIN ANSARI]

Dear Amarender,

Please use it..

Public Sub Lfile_Name()
Dim IFileName As Variant
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub SFile_Name()
Dim SFileName As Variant
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName
End Sub

Public Sub StartButton_Click()
On Error Resume Next
Call Lfile_Name
Workbooks.Open IFileName
Call SFile_Name
Workbooks.Open SFileName
End Sub


On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
wrote:

> Hi Team,
>
> I would like to know if I can use the value of one procedure as input
> to the other procedure.
>
> For example:
>
> I have a user form, it has two command buttons, the first one is
> requesting for a file location(address/path) and the second does also
> requesting another file  location (address/path).
>
> And in my next procedure I would like to open the file which is stored
> in my first command button, similarly would like to open second
> command buttion file.
>
> Here is the code I have...
>
> Public Sub IButton_Click()
>
> Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>
> MsgBox IFileName
>
> End Sub
>
> Public Sub IIButton_Click()
>
> Dim SFileName As Variant
> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox SFileName
>
> End Sub
>
>
> Public Sub StartButton_Click()
>
> Workbooks.Open IFileName
> Workbooks.Open SFileName
>
> End Sub
>
> Thanks in advance.
>
> Best regards,
> Amar
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Excel Help - using value of one procedure into other

[Kris]

Hi,
 
Try
 
Dim IFileName As Variant
Dim SFileName As Variant
Public Sub IButton_Click()
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub IIButton_Click()
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName
End Sub

Public Sub StartButton_Click()
Workbooks.Open IFileName
Workbooks.Open SFileName
End Sub
 
Kris
 

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Custom Excel Functions

[Kris]

Hi
 
I have created one UDF, which can be found at: 
http://www.excelfox.com/forum/f12/number-into-words-rupees-45/
 
Kris

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Thanks Noorain!

Simple and Superb!

On 08/02/2012, NOORAIN ANSARI  wrote:
> Dear Amarender,
>
> Please use it..
>
> Public Sub Lfile_Name()
> Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox IFileName
> End Sub
> Public Sub SFile_Name()
> Dim SFileName As Variant
> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox SFileName
> End Sub
>
> Public Sub StartButton_Click()
> On Error Resume Next
> Call Lfile_Name
> Workbooks.Open IFileName
> Call SFile_Name
> Workbooks.Open SFileName
> End Sub
>
>
> On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
> wrote:
>
>> Hi Team,
>>
>> I would like to know if I can use the value of one procedure as input
>> to the other procedure.
>>
>> For example:
>>
>> I have a user form, it has two command buttons, the first one is
>> requesting for a file location(address/path) and the second does also
>> requesting another file  location (address/path).
>>
>> And in my next procedure I would like to open the file which is stored
>> in my first command button, similarly would like to open second
>> command buttion file.
>>
>> Here is the code I have...
>>
>> Public Sub IButton_Click()
>>
>> Dim IFileName As Variant
>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>
>> MsgBox IFileName
>>
>> End Sub
>>
>> Public Sub IIButton_Click()
>>
>> Dim SFileName As Variant
>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox SFileName
>>
>> End Sub
>>
>>
>> Public Sub StartButton_Click()
>>
>> Workbooks.Open IFileName
>> Workbooks.Open SFileName
>>
>> End Sub
>>
>> Thanks in advance.
>>
>> Best regards,
>> Amar
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.com/*
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ IT Calculator_Revised

[PrIyAnKa]

Dear Team

Kindly find the attached file

One of my friend has sent revised IT calc sheet today

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


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

$$Excel-Macros$$ Hi everyone,

[Mohammed Muneer]

See I have something to aks u?

Can we convert the office 2007 file into office 2003 format, currently
being in the office 2003.

 

 

Any help is appreciated. 

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

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

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

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

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

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

RE: $$Excel-Macros$$ Excel test file Basic & Advance

[Amit Desai (MERU)]

Dear Maries,

This one was nice...can you please also provide us the solution for it?

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Maries
Sent: 07 February 2012 16:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel test file Basic & Advance

Find the attached Excel File
On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI 
mailto:noorain.ans...@gmail.com>> wrote:
PFA

On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Team,

Please forward excel test file for basic & advance level, if anybody have it.

Best Regards,
Amit



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

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

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

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

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

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

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

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


--
Thanks & regards,
Noorain Ansari
http://noorainansari.com/
http://excelmacroworld.blogspot.com/


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

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

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

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

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

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

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

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

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

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

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

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

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

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

NOTE : Don't ever post 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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message a

$$Excel-Macros$$ Jai plz, give me 2003 format to make work easy.....

[Mohammed Muneer]

Dear Jai, how to use the file i.e., in some .xlam format.

U have any vba code to change the file format (2003 - 2007).

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Formula to find Maximum number from list

[The Viper]

hi ashish

use   =MAX(--REPLACE(A2:A41,1,9,"")) with CSE


On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara wrote:

> Dear expert,
>
> I want to formula of maximum number find from a different list which
> example attached herewith.
>
> Thanks & regards
>
> Ashish Bhalara
>
> --
> 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
>



-- 
*Great day,*
*viper*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Formula to find Maximum number from list

[Ashish Bhalara]

Maximum number is 1003, not display in your formula

On Wed, Feb 8, 2012 at 4:49 PM, The Viper  wrote:

> hi ashish
>
> use   =MAX(--REPLACE(A2:A41,1,9,"")) with CSE
>
>
> On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara 
> wrote:
>
>> Dear expert,
>>
>> I want to formula of maximum number find from a different list which
>> example attached herewith.
>>
>> Thanks & regards
>>
>> Ashish Bhalara
>>
>> --
>> 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
>>
>
>
>
> --
> *Great day,*
> *viper*
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Formula to find Maximum number from list

[The Viper]

its working fine.
now i have wrote two types of formulas
go through the attachment.

On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara wrote:

> Maximum number is 1003, not display in your formula
>
>
> On Wed, Feb 8, 2012 at 4:49 PM, The Viper  wrote:
>
>> hi ashish
>>
>> use   =MAX(--REPLACE(A2:A41,1,9,"")) with CSE
>>
>>
>> On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara > > wrote:
>>
>>> Dear expert,
>>>
>>> I want to formula of maximum number find from a different list which
>>> example attached herewith.
>>>
>>> Thanks & regards
>>>
>>> Ashish Bhalara
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> *Great day,*
>> *viper*
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Great day,*
*viper*

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


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

$$Excel-Macros$$ Required Unsubscribe

[sudhir kumar]

Dear Group Owner,

 

I am required link of Unsubscribe or you may unsubscribe me from this Group.

Because this company id.

 

Thanking u

 

Thanks&Regards

  _  

Sudhir Verma

Asstt. Mngr. A/c's

 

QUALITY HOME APPLIANCES

47, RAJASTHANI UDYOG NAGAR

DELHI - 110033
MOBILE +91 9818479722
E-MAIL: sudhir.ku...@lazerindia.com

Personal E-Mail: bluecore...@gmail.com

WEBSITE :   www.lazerindia.com

P think Before you print 

http://www.fileden.com/files/2008/8/21/2058970/greatday.gif

^^ஜ۩۞۩ஜ▬▬▬ ▬^^

 

 

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Hi everyone,

[hemal shah]

HI

following link will solve your issue

http://ubitmenu.en.softonic.com/

Take care self and other
Regards
Hemal

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Index and Choose Function Problem

[hilary lomotey]

thanks Don, but it doesnt solve what i want on the summary sheet, i want to
be able to SELECT from the drop down list from the summary sheet and hv the
ind. companies populate. c

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

>   Why not just use data>filter>autofilter>filter on col B. See attached.
> Then you can use SUBTOTAL formula to total the visible. See attached.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* hilary lomotey 
> *Sent:* Wednesday, February 08, 2012 7:53 AM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ Index and Choose Function Problem
>
>   Hello Experts
>
> In the attached file, the financial analysis sheet contains general
> information categorized by industry.what i want to achive in the  summary
> sheet is that from the drop down list that i hv created conyaining the
> various industries, i want the individual companies under those industries
> to populate anytime i select a particular industry, i tried using the
> choose and index function, i am only able to see rightly the first company
> (am assuming for instance in the breweries sector there is only one company
> and thats why i get that right), however all of the industries besides the
> breweris hv more than one companies under them,  what function or formula
> can help me achieve this. thanks.
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Thanx in advance!

[Mohammed Muneer]

Ok Don I understand u what u want to get from me.

Hope this will serve u to understand what I want to say, means (aa),
(bb) & (cc) are the 3 separate macros ok. If I want to merge these 3
macros into 1. what could be the process?

How I can merge them?

What code is applicable in doing so?

(aa)   macro1

(bb)  macro2

(cc)macro3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: Index and Choose Function Problem

[hilary lomotey]

Great Kris,

Seems to be getting there but what about the other members under the
industry eg Agro has Benso and GWEB, ie 2 members , banking has eight
members, you formula is great in populating the first line but what about
the other members. thanks in advance, you guys are realy good

On Wed, Feb 8, 2012 at 2:08 PM, Kris  wrote:

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Capture Image using VBA

[Prakash Gusain]

I want to capture an image and save to specified location in system
using vba.  Also need the file address in the active cell.

Thank you in advance for your help.

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: Index and Choose Function Problem

[Kris]

Hi

OK. Try this.

In A1 on Summary,

=INDEX(A3:A14,A2)

In AD3 on 'FINANCIAL ANALYSIS'

0

In AD4 and copied down,

=IF(B4<>"",IF(B4=Summary!$A$1,LOOKUP(9.99E+307,$AD$3:AD3)+1,""),"")

In AE3

=MAX(AD4:AD38)


In E5 on 'Summary' and copied down & across,

=IF(ROWS(E$5:E5)<='FINANCIAL ANALYSIS'!$AE$3,INDEX('FINANCIAL 
ANALYSIS'!$A$4:$Z$38,MATCH(ROWS(E$5:E5),'FINANCIAL 
ANALYSIS'!$AD$4:$AD$38,0),E$1),"")

Kris

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Thanx in advance!

[dguillett1]

I don’t understand what you want the final result to look like... I’m trying..

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mohammed Muneer 
Sent: Wednesday, February 08, 2012 8:15 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Thanx in advance!

  Ok Don I understand u what u want to get from me.
 
  Hope this will serve u to understand what I want to say, means (aa), (bb) 
& (cc) are the 3 separate macros ok. If I want to merge these 3 macros into 1. 
what could be the process?
 
  How I can merge them?
 
  What code is applicable in doing so?

  (aa)   macro1

  (bb)  macro2

  (cc)macro3

   

   

   

   

   

   

   
 
   
  
 
   
  
 
   
  
 

 

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Index and Choose Function Problem

[dguillett1]

My point is that you may not NEED a summary sheet. However, if you insist a 
macro could do  the autofilter and copy/paste to the summary sheet driven by 
the drop down...

Don Guillett
SalesAid Software
dguille...@gmail.com

From: hilary lomotey 
Sent: Wednesday, February 08, 2012 8:09 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Index and Choose Function Problem

thanks Don, but it doesnt solve what i want on the summary sheet, i want to be 
able to SELECT from the drop down list from the summary sheet and hv the ind. 
companies populate. c


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

  Why not just use data>filter>autofilter>filter on col B. See attached. Then 
you can use SUBTOTAL formula to total the visible. See attached.

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: hilary lomotey 
  Sent: Wednesday, February 08, 2012 7:53 AM
  To: excel-macros 
  Subject: $$Excel-Macros$$ Index and Choose Function Problem

  Hello Experts

  In the attached file, the financial analysis sheet contains general 
information categorized by industry.what i want to achive in the  summary sheet 
is that from the drop down list that i hv created conyaining the various 
industries, i want the individual companies under those industries to populate 
anytime i select a particular industry, i tried using the choose and index 
function, i am only able to see rightly the first company (am assuming for 
instance in the breweries sector there is only one company and thats why i get 
that right), however all of the industries besides the breweris hv more than 
one companies under them,  what function or formula can help me achieve this. 
thanks.
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

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


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

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

Re: $$Excel-Macros$$ Index and Choose Function Problem

[hilary lomotey]

Hi Don

am not the VBA type for now, still reading beginners manual. but a lil help
with VBA wont hurt . thanks
On Wed, Feb 8, 2012 at 2:42 PM, dguillett1  wrote:

>   My point is that you may not NEED a summary sheet. However, if you
> insist a macro could do  the autofilter and copy/paste to the summary sheet
> driven by the drop down...
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* hilary lomotey 
> *Sent:* Wednesday, February 08, 2012 8:09 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Index and Choose Function Problem
>
>  thanks Don, but it doesnt solve what i want on the summary sheet, i want
> to be able to SELECT from the drop down list from the summary sheet and hv
> the ind. companies populate. c
>
> On Wed, Feb 8, 2012 at 2:05 PM, dguillett1  wrote:
>
>>   Why not just use data>filter>autofilter>filter on col B. See attached.
>> Then you can use SUBTOTAL formula to total the visible. See attached.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* hilary lomotey 
>> *Sent:* Wednesday, February 08, 2012 7:53 AM
>> *To:* excel-macros 
>> *Subject:* $$Excel-Macros$$ Index and Choose Function Problem
>>
>>   Hello Experts
>>
>> In the attached file, the financial analysis sheet contains general
>> information categorized by industry.what i want to achive in the  summary
>> sheet is that from the drop down list that i hv created conyaining the
>> various industries, i want the individual companies under those industries
>> to populate anytime i select a particular industry, i tried using the
>> choose and index function, i am only able to see rightly the first company
>> (am assuming for instance in the breweries sector there is only one company
>> and thats why i get that right), however all of the industries besides the
>> breweris hv more than one companies under them,  what function or formula
>> can help me achieve this. thanks.
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 

Re: $$Excel-Macros$$ Solution required plz

[Sam Mathai Chacko]

What does that have to do with MATCH?

Sam

On Wed, Feb 8, 2012 at 1:29 AM, dguillett1  wrote:

>   OK. Just add some text  to the rest of the rows in col A on sheet2 so
> the “activites”name works
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Tuesday, February 07, 2012 1:14 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Solution required plz
>
> Just checked it Don. Couldn't figure out what you were referring to. Could
> you please let me know.
>
> Sam
>
> On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko wrote:
>
>> OKAY
>>
>>
>> On Wed, Feb 8, 2012 at 12:41 AM, dguillett1  wrote:
>>
>>>   Sam, pls go back and test your MATCH
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Sam Mathai Chacko 
>>> *Sent:* Tuesday, February 07, 2012 11:28 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Solution required plz
>>>
>>>  I have added two named ranges for activities and the states.
>>>
>>> The formula for percentage will then be
>>>
>>>
>>> =COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)
>>>
>>> and for the status will be
>>>
>>> =IF(C2>=1,"Complete","Incomplete")
>>>
>>> OR
>>>
>>> =IF(C2<1,"Incomplete","Complete")
>>>
>>> Regards
>>>
>>> Sam Mathai Chacko
>>>
>>> On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza wrote:
>>>
 Hi,

 Iam an ardent follower of this group. I was just wondering if someone
 can help me find a solution. I have mentioned the issue in the attached
 file. thanks in advance for the Patience in going through my email.

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

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

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

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

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

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

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


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

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

Re: $$Excel-Macros$$ Thanx in advance!

[Sam Mathai Chacko]

Duh.

Sub macro4()

call macro1
call macro2
call macro3

End Sub

???

Sam

On Wed, Feb 8, 2012 at 8:10 PM, dguillett1  wrote:

>   I don’t understand what you want the final result to look like... I’m
> trying..
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Mohammed Muneer 
> *Sent:* Wednesday, February 08, 2012 8:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Thanx in advance!
>
>
> Ok Don I understand u what u want to get from me.
>
> Hope this will serve u to understand what I want to say, means (aa), (bb)
> & (cc) are the 3 separate macros ok. *If I want to merge these 3 macros
> into 1*. what could be the process?
>
> How I can merge them?
>
> What code is applicable in doing so?
>
> (aa)   macro1
>
> (bb)  macro2
>
> (cc)macro3
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> 
>
> Regards,
>
> Muneer,
>
> CC...
>
> 
>
> 
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Solution required plz

[dguillett1]

Sam, I MIS spoke the first time

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Wednesday, February 08, 2012 9:21 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Solution required plz

What does that have to do with MATCH?

Sam


On Wed, Feb 8, 2012 at 1:29 AM, dguillett1  wrote:

  OK. Just add some text  to the rest of the rows in col A on sheet2 so the 
“activites”name works

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: Sam Mathai Chacko 
  Sent: Tuesday, February 07, 2012 1:14 PM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Solution required plz

  Just checked it Don. Couldn't figure out what you were referring to. Could 
you please let me know.

  Sam


  On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko  wrote:

OKAY 



On Wed, Feb 8, 2012 at 12:41 AM, dguillett1  wrote:

  Sam, pls go back and test your MATCH

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: Sam Mathai Chacko 
  Sent: Tuesday, February 07, 2012 11:28 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Solution required plz

  I have added two named ranges for activities and the states.

  The formula for percentage will then be

  
=COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)

  and for the status will be

  =IF(C2>=1,"Complete","Incomplete")

  OR

  =IF(C2<1,"Incomplete","Complete")

  Regards

  Sam Mathai Chacko


  On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza  
wrote:

Hi, 

Iam an ardent follower of this group. I was just wondering if someone 
can help me find a solution. I have mentioned the issue in the attached file. 
thanks in advance for the Patience in going through my email.

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

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




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

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





-- 
Sam Mathai Chacko




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

Re: $$Excel-Macros$$ Thanx in advance!

[dguillett1]

Sam, I hope you guessed right. Maybe I’m just getting too old.
However, his data showed an autofilter for the same column without much 
explanation.
Hopefully, OP will help us help.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Wednesday, February 08, 2012 9:31 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Thanx in advance!

Duh.

Sub macro4()

call macro1
call macro2
call macro3

End Sub

???

Sam


On Wed, Feb 8, 2012 at 8:10 PM, dguillett1  wrote:

  I don’t understand what you want the final result to look like... I’m trying..

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: Mohammed Muneer 
  Sent: Wednesday, February 08, 2012 8:15 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Thanx in advance!

Ok Don I understand u what u want to get from me.
   
Hope this will serve u to understand what I want to say, means (aa), 
(bb) & (cc) are the 3 separate macros ok. If I want to merge these 3 macros 
into 1. what could be the process?
   
How I can merge them?
   
What code is applicable in doing so?

(aa)   macro1

(bb)  macro2

(cc)macro3














   

   
   

   
   

   
   







  Regards,

  Muneer,

  CC...





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

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




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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Thanx in advance!

[Sam Mathai Chacko]

The OP was / is sounding a little rhetorical, and I have the slightest idea
what is being conveyed and I was also hoping that's what he wanted.. Yes
Don, there is an autofilter which you pointed out rightly.. and only
the OP can help.

Sam

On Wed, Feb 8, 2012 at 9:16 PM, dguillett1  wrote:

>   Sam, I hope you guessed right. Maybe I’m just getting too old.
> However, his data showed an autofilter for the same column without much
> explanation.
> Hopefully, OP will help us help.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Wednesday, February 08, 2012 9:31 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Thanx in advance!
>
> Duh.
>
> Sub macro4()
>
> call macro1
> call macro2
> call macro3
>
> End Sub
>
> ???
>
> Sam
>
> On Wed, Feb 8, 2012 at 8:10 PM, dguillett1  wrote:
>
>>   I don’t understand what you want the final result to look like... I’m
>> trying..
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Mohammed Muneer 
>> *Sent:* Wednesday, February 08, 2012 8:15 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Thanx in advance!
>>
>>
>> Ok Don I understand u what u want to get from me.
>>
>> Hope this will serve u to understand what I want to say, means (aa), (bb)
>> & (cc) are the 3 separate macros ok. *If I want to merge these 3 macros
>> into 1*. what could be the process?
>>
>> How I can merge them?
>>
>> What code is applicable in doing so?
>>
>> (aa)   macro1
>>
>> (bb)  macro2
>>
>> (cc)macro3
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> 
>>
>> Regards,
>>
>> Muneer,
>>
>> CC...
>>
>> 
>>
>> 
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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

$$Excel-Macros$$ Excel and Macro PPT or Materials required

[Liyakath Khan]

Hi,

I am new to excel field but want to learn excel and macros, could you
please provide me training materials. And also add my Id to this
group.


Thanks
Liyakath Ali Khan

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Sum Product

[Krishna madolli]

Hi

Can you please provide training material for Sum Product with few examples.
-- 
Krishnaraddi V Madolli.

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Add to this group

[Krishna madolli]

Thanks Sam.

On 2/7/12, Sam Mathai Chacko  wrote:
> Use this link and send an invite to your friend
>
> https://groups.google.com/group/excel-macros/members_invite?hl=en
>
> Regards,
>
> Sam
>
> On Tue, Feb 7, 2012 at 11:00 PM, Sam Mathai Chacko
> wrote:
>
>> I have sent you an invite just now. Please check the link
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Tue, Feb 7, 2012 at 10:26 PM, Krishna madolli
>> wrote:
>>
>>> Hi my friend want to add his ID to this group, please let us know the
>>> procedure
>>> --
>>> Krishnaraddi V Madolli.
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
Krishnaraddi V Madolli.

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel and Macro PPT or Materials required

[Sam Mathai Chacko]

Currently you are a member of this group

Sam

On Wed, Feb 8, 2012 at 8:03 PM, Liyakath Khan wrote:

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



-- 
Sam Mathai Chacko

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

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

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

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

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

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

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

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

$$Excel-Macros$$ How to protect cells or formulas in excel sheets

[Veeru TOC]

Dear Team

  in excel file i know protect sheets but i need particular
Cells put the code or protect how it possible

VBA code also no problem
-- 





*Thanks&Regards*

* *

*   **Veerendra.Vanam*

  *TOC TEAM*
* *  *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
  Hyderabad-500072,-Andhra Pradesh
**   **91-9177-444-840**,*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

[Sam Mathai Chacko]

select all the cells, right click, format cell, protection tab, uncheck the
locked status

Now select only those cells that need to be protected, right click, format
cell, protection tab, now check the locked status

Finally, protect the sheet. now those cells cannot be editted.

Sam Mathai Chacko

On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC  wrote:

>
> Dear Team
>
>   in excel file i know protect sheets but i need particular
> Cells put the code or protect how it possible
>
> VBA code also no problem
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> *   **Veerendra.Vanam*
>
>   *TOC TEAM*
> * *  *Bhagyanagar Electrical & Contractors**
> ****H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>   Hyderabad-500072,-Andhra Pradesh
> **   **91-9177-444-840**,*
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

[Veeru TOC]

sir,

   it;s not working sir

   small example:


  A B total  12 6 72  14 8 112  15 8 120

above columns i protect of cells  72,112,120 only how its possible



On Wed, Feb 8, 2012 at 10:51 PM, Sam Mathai Chacko wrote:

> select all the cells, right click, format cell, protection tab, uncheck
> the locked status
>
> Now select only those cells that need to be protected, right click, format
> cell, protection tab, now check the locked status
>
> Finally, protect the sheet. now those cells cannot be editted.
>
> Sam Mathai Chacko
>
>
> On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC  wrote:
>
>>
>> Dear Team
>>
>>   in excel file i know protect sheets but i need particular
>> Cells put the code or protect how it possible
>>
>> VBA code also no problem
>> --
>>
>>
>>
>>
>>
>> *Thanks&Regards*
>>
>> * *
>>
>> *   **Veerendra.Vanam*
>>
>>   *TOC TEAM*
>> * *  *Bhagyanagar Electrical & Contractors**
>> ****H.No-5-9-286/65,Plot No-65
>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>   Hyderabad-500072,-Andhra Pradesh
>> **   **91-9177-444-840**,*
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 





*Thanks&Regards*

* *

*   **Veerendra.Vanam*

  *TOC TEAM*
* *  *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
  Hyderabad-500072,-Andhra Pradesh
**   **91-9177-444-840**,*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Index and Choose Function Problem

[hilary lomotey]

Superb, wonderful sam, the formula is a beautiful and works to perfection.

Thanks Kris, Don you guys are genius.

On Wed, Feb 8, 2012 at 3:42 PM, Sam Mathai Chacko wrote:

> Not sure why you need a CHOOSE in there. Anyway, is this what you are
> looking for?
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Wed, Feb 8, 2012 at 8:40 PM, hilary lomotey  wrote:
>
>> Hi Don
>>
>> am not the VBA type for now, still reading beginners manual. but a lil
>> help with VBA wont hurt . thanks
>>  On Wed, Feb 8, 2012 at 2:42 PM, dguillett1  wrote:
>>
>>>   My point is that you may not NEED a summary sheet. However, if you
>>> insist a macro could do  the autofilter and copy/paste to the summary sheet
>>> driven by the drop down...
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* hilary lomotey 
>>> *Sent:* Wednesday, February 08, 2012 8:09 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Index and Choose Function Problem
>>>
>>>  thanks Don, but it doesnt solve what i want on the summary sheet, i
>>> want to be able to SELECT from the drop down list from the summary sheet
>>> and hv the ind. companies populate. c
>>>
>>> On Wed, Feb 8, 2012 at 2:05 PM, dguillett1  wrote:
>>>
   Why not just use data>filter>autofilter>filter on col B. See
 attached. Then you can use SUBTOTAL formula to total the visible. See
 attached.

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* hilary lomotey 
 *Sent:* Wednesday, February 08, 2012 7:53 AM
 *To:* excel-macros 
 *Subject:* $$Excel-Macros$$ Index and Choose Function Problem

   Hello Experts

 In the attached file, the financial analysis sheet contains general
 information categorized by industry.what i want to achive in the  summary
 sheet is that from the drop down list that i hv created conyaining the
 various industries, i want the individual companies under those industries
 to populate anytime i select a particular industry, i tried using the
 choose and index function, i am only able to see rightly the first company
 (am assuming for instance in the breweries sector there is only one company
 and thats why i get that right), however all of the industries besides the
 breweris hv more than one companies under them,  what function or formula
 can help me achieve this. thanks.
 --
 FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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


 --
 To post to this group, send email to excel-macros@googlegroups.com
  --
 FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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


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

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

Re: $$Excel-Macros$$ Re: Index and Choose Function Problem

[hilary lomotey]

this formula also works to perfection, great guys



On Wed, Feb 8, 2012 at 4:04 PM, Kris  wrote:

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Sum Product

[NOORAIN ANSARI]

*Learn:*

   - Introduction to SUMPRODUCT
Formula
   - Advanced SUMPRODUCT Formula
Examples
   - Introduction to SUMIFS
Formula
   - Array Formula Examples, Tutorials &
More
   - More articles on SUMPRODUCT Formula



On Wed, Feb 8, 2012 at 11:29 PM, NOORAIN ANSARI wrote:

> Dear Krishna,
>
> See attached Sumproduct example
>
>
> On Wed, Feb 8, 2012 at 8:29 PM, Krishna madolli wrote:
>
>> Hi
>>
>> Can you please provide training material for Sum Product with few
>> examples.
>> --
>> Krishnaraddi V Madolli.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
>


-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

[NOORAIN ANSARI]

Dear Veeru,

Visit on below link
http://www.youtube.com/watch?v=hForkbT9vgs
http://oreilly.com/pub/h/1216


On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC  wrote:

>
> Dear Team
>
>   in excel file i know protect sheets but i need particular
> Cells put the code or protect how it possible
>
> VBA code also no problem
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> *   **Veerendra.Vanam*
>
>   *TOC TEAM*
> * *  *Bhagyanagar Electrical & Contractors**
> ****H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>   Hyderabad-500072,-Andhra Pradesh
> **   **91-9177-444-840**,*
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Capture Image using VBA

[NOORAIN ANSARI]

Dear Prakash,

Please share a sample workbook with excel macro group

On Wed, Feb 8, 2012 at 8:04 PM, Prakash Gusain wrote:

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



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel and Macro PPT or Materials required

[Mahesh parab]

Hi

You can download ebooks from below links

   - *Excel 2007 VBA Macro Programming*

 http://www.mediafire.com/?9sl8iagf5e51144


   - *Microsoft Office Specialist (MOS) 2010 Study Guide for Microsoft®
   Excel*

 http://www.mediafire.com/?bs2dpn9qbwhih0n

HTH
Mahesh

On Wed, Feb 8, 2012 at 11:56 PM, NOORAIN ANSARI wrote:

>
>
> On Wed, Feb 8, 2012 at 8:03 PM, Liyakath Khan wrote:
>
>> Hi,
>>
>> I am new to excel field but want to learn excel and macros, could you
>> please provide me training materials. And also add my Id to this
>> group.
>>
>>
>> Thanks
>> Liyakath Ali Khan
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Thanx in advance!

[David Grugeon]

How about putting the aa bb or cc in the cell manually and then having a
generic macro which would select whichever one you put.

Or could you just use the drop down arrow of the autofilter to get the same
effect faster and more efficiently.

On 9 February 2012 00:15, Mohammed Muneer  wrote:

>Ok Don I understand u what u want to get from me.
>
> Hope this will serve u to understand what I want to say, means (aa), (bb)
> & (cc) are the 3 separate macros ok. *If I want to merge these 3 macros
> into 1*. what could be the process?
>
> How I can merge them?
>
> What code is applicable in doing so?
>
> **(aa)   **macro1
>
> **(bb)  **macro2
>
> **(cc)**macro3
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC...
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
David Grugeon

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

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

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

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

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

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

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

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

$$Excel-Macros$$ MASTER macro.

[pawel lupinski]

Hi All, 
 
I know you can help me as many times before,so this time I'd like to ask you 
for help with simple macro. 
I'd like to do macro that will copy "MASTER" tab to the end of the tabs, but 
this macro (will be perfect) if can ask user for week number, 
and change name "MASTER" to "week and the number that user wrote", e.g. user 
wrote "10" so the new tab will be "week 10" 
 
Can you help me on this point. 
 
Thanks, 
 
Pawel 

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ MASTER macro.

[dguillett1]

Sub copysheetnameSAS()
Sheets("Master").Copy after:=Sheets(Sheets.Count)
ActiveSheet.Name = "Week " & _
InputBox("Enter week NUMBER ie: 10")
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: pawel lupinski 
Sent: Wednesday, February 08, 2012 5:01 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ MASTER macro.

  Hi All, 

 
  I know you can help me as many times before,so this time I'd like to ask 
you for help with simple macro. 
  I'd like to do macro that will copy "MASTER" tab to the end of the tabs, 
but this macro (will be perfect) if can ask user for week number, 
  and change name "MASTER" to "week and the number that user wrote", e.g. 
user wrote "10" so the new tab will be "week 10" 

 
  Can you help me on this point. 

 
  Thanks, 

 
  Pawel 

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ MASTER macro.

[pawel lupinski]

Don,

love it

thanks a lot

Pawel




 From: dguillett1 
To: excel-macros@googlegroups.com 
Sent: Wednesday, February 8, 2012 11:33 PM
Subject: Re: $$Excel-Macros$$ MASTER macro.
 

Sub copysheetnameSAS()
Sheets("Master").Copy after:=Sheets(Sheets.Count)
ActiveSheet.Name = "Week " & _
InputBox("Enter week NUMBER ie: 10")
End Sub
 
Don 
Guillett
SalesAid Software
dguille...@gmail.com 
From: pawel lupinski 
Sent: Wednesday, February 08, 2012 5:01 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ MASTER macro.
  Hi  All, 
 
I know you can  help me as many times before,so this time I'd like to ask you 
for help  with simple macro. 
I'd like to do  macro that will copy "MASTER" tab to the end of the tabs, but 
this macro  (will be perfect) if can ask user for week number, 
and change name  "MASTER" to "week and the number that user wrote", e.g. user 
wrote "10" so  the new tab will be "week 10" 
 
Can you help me on  this point. 
 
Thanks, 
 
Pawel -- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use 
concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 
Need Help, Formula Problem, Code Problem, and Need Advice will not get quick 
attention or may not be answered.
 
2) Don't post a question in the 
thread of another member.
 
3) Don't post questions regarding 
breaking or bypassing any security measure.
 
4) Acknowledge the 
responses you receive, good or bad.
 
5) Cross-promotion of, or links 
to, forums competitive to this forum in signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any 
loss.
 
--
To 
post to this group, send email to 
excel-macros@googlegroups.com

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ To excel macro team

[bpascal123]

 Btw, taking a bath or a shower every single minutes is such a
waste!!! even every day, in poor countries or our grand-parents from
the country side were more clean than what we can think we are today
with less water. I don't take a shower every single day if I had a
'quiet' day, just a soda can volume-like of water in the morning if i
want to feel confidence and have a social life is just enough. However
i understand in today's modern life where we're running out of time,
we need showers,eventually wearing clean clothing or changing clothing
throughout the day can be an alternative. Sorry Don about being rude
on my last reply, this is what i wanted to say initially. -pascal

On Feb 3, 12:46 am, bpascal123  wrote:
> why, u want an invit?
>
> On Feb 1, 10:12 pm, "dguillett1"  wrote:
>
>
>
>
>
>
>
> > Did you bathe today.
>
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
>
> > From: Pascal Baro
> > Sent: Wednesday, February 01, 2012 3:48 PM
> > To: excel-macros@googlegroups.com
> > Subject: $$Excel-Macros$$ To excel macro team
>
> > Hi,
> > I'm not receiving mail summary from group posting anymore. Is there any 
> > reasons?
> > Regards,
> > Pascal
> > --
> > FORUM RULES (986+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> > will not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security 
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5) Cross-promotion of, or links to, forums competitive to this forum in 
> > signatures are prohibited.
>
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> > owners and members are not responsible for any loss.
>
> > --- 
> > ---
> > To post to this group, send email to excel-macros@googlegroups.com

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Hi Noorain,

I'm getting error ... Can you please try your code and check?

thanks,
Amar

On 08/02/2012, Kasireddy Amarender  wrote:
> Thanks Noorain!
>
> Simple and Superb!
>
> On 08/02/2012, NOORAIN ANSARI  wrote:
>> Dear Amarender,
>>
>> Please use it..
>>
>> Public Sub Lfile_Name()
>> Dim IFileName As Variant
>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox IFileName
>> End Sub
>> Public Sub SFile_Name()
>> Dim SFileName As Variant
>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox SFileName
>> End Sub
>>
>> Public Sub StartButton_Click()
>> On Error Resume Next
>> Call Lfile_Name
>> Workbooks.Open IFileName
>> Call SFile_Name
>> Workbooks.Open SFileName
>> End Sub
>>
>>
>> On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
>> wrote:
>>
>>> Hi Team,
>>>
>>> I would like to know if I can use the value of one procedure as input
>>> to the other procedure.
>>>
>>> For example:
>>>
>>> I have a user form, it has two command buttons, the first one is
>>> requesting for a file location(address/path) and the second does also
>>> requesting another file  location (address/path).
>>>
>>> And in my next procedure I would like to open the file which is stored
>>> in my first command button, similarly would like to open second
>>> command buttion file.
>>>
>>> Here is the code I have...
>>>
>>> Public Sub IButton_Click()
>>>
>>> Dim IFileName As Variant
>>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>>
>>> MsgBox IFileName
>>>
>>> End Sub
>>>
>>> Public Sub IIButton_Click()
>>>
>>> Dim SFileName As Variant
>>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>> MsgBox SFileName
>>>
>>> End Sub
>>>
>>>
>>> Public Sub StartButton_Click()
>>>
>>> Workbooks.Open IFileName
>>> Workbooks.Open SFileName
>>>
>>> End Sub
>>>
>>> Thanks in advance.
>>>
>>> Best regards,
>>> Amar
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://noorainansari.com/* 
>> *http://excelmacroworld.blogspot.com/*
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum
>> owners and members are not responsible for any loss.
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Capture Image using VBA

[Prakash Gusain]

You can use any excel file.  I just want to trigger the webcam using
VBA.  Hope you guys can help me provide the solution.

On Feb 8, 11:14 pm, NOORAIN ANSARI  wrote:
> Dear Prakash,
>
> Please share a sample workbook with excel macro group
>
> On Wed, Feb 8, 2012 at 8:04 PM, Prakash Gusain wrote:
>
>
>
> > I want to capture an image and save to specified location in system
> > using vba.  Also need the file address in the active cell.
>
> > Thank you in advance for your help.
>
> > --
> > FORUM RULES (986+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> > will not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > --
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kris]

Hi
 
Have you tred mine ?
 
 

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Cstr function

[Lakshman Prasad]

Dear Darwin,
 
Plz see attached file.
is it ok?



From: Darwin Chan 
To: excel-macros@googlegroups.com 
Sent: Thursday, 9 February 2012 9:24 AM
Subject: $$Excel-Macros$$ Cstr function


Dear group, 

Would like to ask how to use Cstr, left and mid functions to split the data 
into 2 parts??

Attached can find the file for reference.

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

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

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

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

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

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

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

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

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


Required(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ nitin arora wants to chat

[nitin arora]

---

nitin arora wants to stay in better touch using some of Google's coolest new
products.

If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-1bce156c49-49439e65f4-TjijJGrT3mGgSPg1dNIXfciG6S4
You'll need to click this link to be able to chat with nitin arora.

To get Gmail - a free email account from Google with over 2,800 megabytes of
storage - and chat with nitin arora, visit:
http://mail.google.com/mail/a-1bce156c49-49439e65f4-TjijJGrT3mGgSPg1dNIXfciG6S4

Gmail offers:
- Instant messaging right inside Gmail
- Powerful spam protection
- Built-in search for finding your messages and a helpful way of organizing
  emails into "conversations"
- No pop-up ads or untargeted banners - just text ads and related information
  that are relevant to the content of your messages

All this, and its yours for free. But wait, there's more! By opening a Gmail
account, you also get access to Google Talk, Google's instant messaging
service:

http://www.google.com/talk/

Google Talk offers:
- Web-based chat that you can use anywhere, without a download
- A contact list that's synchronized with your Gmail account
- Free, high quality PC-to-PC voice calls when you download the Google Talk
  client

We're working hard to add new features and make improvements, so we might also
ask for your comments and suggestions periodically. We appreciate your help in
making our products even better!

Thanks,
The Google Team

To learn more about Gmail and Google Talk, visit:
http://mail.google.com/mail/help/about.html
http://www.google.com/talk/about.html

(If clicking the URLs in this message does not work, copy and paste them into
the address bar of your browser).

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Deletion of Posts

[nitin arora]

Hi,

I sent few mails to this group which have excel file attched to them. I
request you to please delete all my posts on priority from the group.

My email id is: nitinaror...@gmail.com

Regards,

Nitin Arora

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ split the value in two part

[Shaik Waheed]

Hi Sanjib,

In your sample data u can do this by clicking to 'Data' tab in ur excel
sheet--->Text To Colums---> Fixed width-->Next---> Set the scale line as
per ur requirement---> finish

Do the necessary formatting as per ur requirement.
Find the attached sheet for ur review.

On Thu, Feb 9, 2012 at 12:49 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

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

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

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

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

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

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

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

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

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


sample_data(Solved).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Next Working date

[Chidurala, Shrinivas]

Dear Group,

Please suggest any formula to pick next working date, but Saturday and Sunday 
should not include.

Working day  Next Working day
9-Feb-12 10-Feb-12
10-Feb-1213-Feb-12


Regards,
Shrinivas


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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Next Working date

[Shaik Waheed]

Hi Shinivas,

=Workday(A2,1,0)

See the attached
On Thu, Feb 9, 2012 at 1:14 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:

> **
>
> Dear Group,
>
> Please suggest any formula to pick next working date, but Saturday and
> Sunday should not include.
>
>*Working day* *Next Working day* 9-Feb-12 10-Feb-12 10-Feb-12 13-Feb-12
>
>
> Regards,
> Shrinivas
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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


Next Working day.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet