> *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@googl
-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
Use this .
Sub GotoSheet()
Dim StrString As String
Dim VarSheetArr
Dim wksSheet As Worksheet
Dim VarCount
VarCount = 1
For Each wksSheet In ThisWorkbook.Worksheets
StrString = StrString & VarCount & vbTab & wksSheet.Name & vbCrLf
VarC
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
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
Try this :
See the attached file.. Data should be in same format in RawData Sheet.
Revert if it not desired.
Sub TranformThis()
Dim rng As Range
Dim rngCell As Range
Dim wksRawData As Worksheet
Dim wksOutput As Worksheet
Dim rngTarget As Range
Set wksOutpu
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
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
>
> --
>
>
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
25 matches
Mail list logo
