[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 solution for switch between sheet.
1. I am having on file containing 12 sheets and i have
*Dear Rajan*
*Please elaborate how it will work.*
*Thanks,*
*Pravin Gunjal
*
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros@googlegroups.com
*Use
-Macros$$ Solution required
Dear Rajan
Please elaborate how it will work.
Thanks,
Pravin Gunjal
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros
*Subject:* Fwd: $$Excel-Macros$$ Solution required
** **
*Dear Rajan*
*Please elaborate how it will work.*
*Thanks,*
*Pravin Gunjal*
-- Forwarded message --
From: *Rajan_Verma* rajanverma1...@gmail.com
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE
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
Chacko samde...@gmail.com
*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, 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
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
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(C21,Incomplete,Complete)
Regards
Sam Mathai Chacko
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
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
@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
MATCH
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*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
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..
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 prince.seth...@gmail.comwrote:
Dear Excel Guru !!!
I need
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
PFA
On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Prince,
Please select filtered data, press alt+; then copy
Excellent Solution SAM
On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
PFA
On Mon, Jan 23, 2012 at 6:54
Thank you soo much (Noorain Sam)
On Jan 23, 6:44 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Excellent Solution SAM
On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's how you do it with code
Regards,
Sam Mathai
Set rng = Nothing
Set rngCell = Nothing
Set wksRawData = Nothing
Set wksOutput = Nothing
Set rngTarget = Nothing
End Sub
From: Priya Jose [mailto:questpr...@gmail.com]
Sent: Jan/Tue/2012 06:33
To: rajanverma1...@gmail.com
Subject: Fwd: $$Excel-Macros
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
Can you please help me in workbook..
Regards,
Subhash yadav
On Tue, Jun 28, 2011 at 2:02 PM, Vasant vasant...@gmail.com 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
Please help me out.
On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com 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
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
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
...@gmail.com
Date: 14 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 jk9779771...@gmail.comwrote:
Dear Excel Gurus,
Urgent help
Dear Jitender,
Use the mail merge option in the word
On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar jk9779771...@gmail.comwrote:
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
Hi All
Finally I have recorded the following macro code:
Sub reports()
'
' reports Macro
'
'
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord =
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 azhar@gmail.com wrote:
Hi All
Finally I have recorded the following macro code:
Sub reports()
'
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 alvin.c.s.f...@gmail.com wrote:
Hi Azhar,
Try using a variable for your file name. This variable file name can
be driven from the
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 azhar@gmail.com wrote:
Hi Gurus
My work relates to prepare a large number of reports and I use mail merge
for all this process. I
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
32 matches
Mail list logo