>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
> *Sent:* 13 October 2012 11:46
> *To:* excel-macros@googlegroups.com
> *Subject:* Fwd: $$Excel-Macros$$ Solution required
>
> ** **
>
> *Dear Rajan*
>
-Macros$$ Solution required
Dear Rajan
Please elaborate how it will work.
Thanks,
Pravin Gunjal
-- Forwarded message --
From: Rajan_Verma
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros@googlegroups.com
Use this
*Dear Rajan*
*Please elaborate how it will work.*
*Thanks,*
*Pravin Gunjal
*
-- Forwarded message --
From: Rajan_Verma
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros@googlegroups.com
*Use this .*
* *
*Sub GotoSheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Subhash Yadav
Sent: 13 October 2012 9:19
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Solution required
Dear Members,
I wnat one solutio
Dear Members,
I wnat one solution for switch between sheet.
1. I am having on file containing 12 sheets and i have to work between the
two sheets (sheet 2 & sheet 11) alternatively. If any shorcut key is there
to switch between sheets. Sheets are no adjuscent othewise I can use
ctrl+page up, down
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
m 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
&
llett
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 fo
r 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
>
egroups.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
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
The basic premise of a solution oriented approach is that it requires some
element of dynamic adjustment or a self corrective modus operandus that
will ensure proximity to correctness within a set of expected variations.
1. Your suggestion of having each column hard coded will (may) not suffice
th
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 Mat
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
Thank you soo much (Noorain & Sam)
On Jan 23, 6:44 am, NOORAIN ANSARI wrote:
> Excellent Solution SAM
>
> On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko wrote:
>
>
>
>
>
>
>
>
>
> > Here's how you do it with code
>
> > Regards,
> > Sam Mathai Chacko
>
> > On Mon, Jan 23,
Excellent Solution SAM
On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko wrote:
> Here's how you do it with code
>
> Regards,
> Sam Mathai Chacko
>
> On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
> wrote:
> > PFA
> >
> >
> > On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI <
> noor
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
wrote:
> PFA
>
>
> On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI
> wrote:
>>
>> Dear Prince,
>>
>> Please select filtered data, press alt+; then copy and paste
>>
>> or
>>
>> Select Data
Dear Prince,
Please select filtered data, press alt+; then copy and paste
or
Select Data and press ctrl+g and click on Visible cells only then copy and
paste
Hope it will help to you.
On Mon, Jan 23, 2012 at 5:05 PM, prince sethi wrote:
> Dear Excel Guru !!!
>
> I need the solution for a quer
Dear Excel Guru !!!
I need the solution for a query. Suppose i am having below data.
I am having start date, & End Date. I want data should be filtered &
copy to another location. I am able to do so by applying fileter but
facing its taking all the record while i want visible records only..
Da
End Sub
From: Priya Jose [mailto:questpr...@gmail.com]
Sent: Jan/Tue/2012 06:33
To: rajanverma1...@gmail.com
Subject: Fwd: $$Excel-Macros$$ Solution Required as per the Raw Data
Hi Rajan,
Good day to you...!
Please find attach and request you to provide me a solution. The
Dear Experts,
I have been given the following task.
Please help me solving the problem attached in the excel sheet.
Thanks.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and l
Can you please help me in workbook..
Regards,
Subhash yadav
On Tue, Jun 28, 2011 at 2:02 PM, Vasant wrote:
> Sorry...correction.
>
> use this.
>
> Public Function CalculateType(Rng As Range)
> If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
> = 1050 Or Rng.Value = 1300 O
Sorry...correction.
use this.
Public Function CalculateType(Rng As Range)
If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
= 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then
CalculateType = 50
ElseIf Rng.Value = 750 Then
CalculateType = 250
ElseIf Rng.Value = 1000 Or Rng.Val
try this.
use this UDF for the type columns. Pass the Previous Type value into
the function
Public Function CalculateType(Rng As Range)
If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
= 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then
CalculateType = 50
ElseIf Rng.Value =
Please help me out.
On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav wrote:
> Dear Experts,
>
> Please refer my attached file for which i want solution.
>
> My queries are:
>
> 1. In the "type" column - Value is "previous type+50". but if the values
> are 300,550,800,1050,1300,1550 etc this st
February 2011 12:46
Subject: Re: $$Excel-Macros$$ Solution required
To: excel-macros@googlegroups.com
Dear Jitender,
Use the mail merge option in the word
On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar wrote:
> Dear Excel Gurus,
>
> Urgent help required from your part, Plz help me on
Dear Jitender,
Use the mail merge option in the word
On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar wrote:
> Dear Excel Gurus,
>
> Urgent help required from your part, Plz help me on the file attached.
> Problem in file
>
> Thanks in advance
>
> Regards
>
> Jitender
>
> --
>
>
Dear Excel Gurus,
Urgent help required from your part, Plz help me on the file attached.
Problem in file
Thanks in advance
Regards
Jitender
--
--
Some important links for excel users:
1. Follow us on TWITTER for t
Thanks Alvin
My question is HOW? I am just failed to accomplish the task. Please help me.
AZHAR RAI
Skype: azhar.rai
On Wed, Jun 16, 2010 at 07:10, fongie wrote:
> Hi Azhar,
>
> Try using a variable for your file name. This variable file name can
> be driven from the mail merge data set or f
Hi Azhar,
Try using a variable for your file name. This variable file name can
be driven from the mail merge data set or from an adjacent data set.
Alvin
On Jun 15, 8:08 pm, Azhar Rai wrote:
> Hi All
>
> Finally I have recorded the following macro code:
>
> Sub reports()
> '
> ' reports Mac
Hi All
Finally I have recorded the following macro code:
Sub reports()
'
' reports Macro
'
'
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = ActiveDocument.MailMerge.DataSource.Act
Hello Gurus
I am afraid I did not receive response from anyone.
AZHAR RAI
Cell: +92-333-552-7731
Skype: azhar.rai
On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote:
> Hi Gurus
>
> My work relates to prepare a large number of reports and I use mail merge
> for all this process. I have to save each
Hi Gurus
My work relates to prepare a large number of reports and I use mail merge
for all this process. I have to save each and every report separately. The
file name I need to use is also generated through mail merge at the very
first line of each report in MS Word document.
What I need is when
33 matches
Mail list logo
