see the attachment if you want to do it with combination of functions
On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad wrote:
> thanks for your response Dguillett1 & Rohan but when I run the macro its
> shows attached error. Please see the issue. And I don't want to remove the
> duplicates if na
>
> hi
>
Don Guillett Thanks for ur help.Please clarify one more doubt.code in that
file working good.Can i copy the code to my needy file .Is it works? or any
modicifcations in that.
>
>
Thanq
>
> -
Hi,
I want a vba code to have line spacing as zero in my signature.
Currently when I am creating an email I am getting my signature
dispayed as below:-
Kaushik Savla
Assistant Manager – Jardine Discretionary Trust Accounting
JLT India Pvt Ltd
Direct Line: +91 022 43377441, Extenstion # 4141
M
-- Forwarded message --
From: Ansar Ellahi
Date: Wed, Dec 28, 2011 at 10:41 AM
Subject: $$Excel-Macros$$ dob
To: excel-macros@googlegroups.com
please send excel formula
my accurate date of birth
from 16/03/1986
today 28/12/2011
thanks
--
best regards.
Ansar Ellahi
Management
please send excel formula
my accurate date of birth
from 16/03/1986
today 28/12/2011
thanks
--
best regards.
Ansar Ellahi
Management Office
*SML-Bhone (Jhang)
*Cell +92 303 790 2645
Ph 048-6889211-12
Fax 048-6889213
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concis
*Remove Duplicates:*
Sub Macro1()
'
' Macro1 Macro
'
'
Range("C1:D26").Select
ActiveSheet.Range("$C$1:$D$26").RemoveDuplicates Columns:=Array(1, 2),
Header:=xlYes
End Sub
Regards,
MARIES.
On Tue, Dec 27, 2011 at 11:50 PM, Rohan wrote:
> One more way of doing it...
>
> Sub Macro1()
>
>
What I have is a workbook for each month, one worksheet is the raw
data, and 6 more are reports. The workbook is set up this way so the
reports can either be printed and mailed, or the whole workbook can be
emailed.
A few of the fields in the report are rolling three month or twelve
month values t
See if the link below has something that would help you:
https://sites.google.com/site/normay/excel-files
Norman
2011/12/27 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>
> Dear Excel Experts
>
> If anybody has good automated Excel invoice template (
> http://www.youtube
How do I create a stand alone application out of an excel worksheet.
That is all tab lists up top ie "home insert pagelayout" etc. needs
to not be displayed.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
How do I create an application in excel that hides all the components
of excel in order to have a stand alone custom applicaion. I posted
this earlier but without a subject I think. So Here is is again.
Thxn
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate t
Hi Santosh,
Assuming the value you have labeled ROI and I is really just ROI (remember,
your graphic indicates that i=ROI/400), you can replicate the formula in
your graphic like this:
=(I4*((1+I6/400)*I5-1))/(1-(1+I6/400)-1/3)
The result is -31751. Surely not what you hoped.
I think the
Have you looked at Office templates?
http://office.microsoft.com/en-us/templates/templates-presentations-spreadsheets-documents-calendars-more-FX101741961.aspx
Don Guillett
SalesAid Software
dguille...@gmail.com
From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
Sent: Tuesday, December 27, 2011
Dear Excel Experts
If anybody has good automated Excel invoice template (
http://www.youtube.com/watch?v=Fzlwb8OkbBA&feature=related)
I shall be thankful if anybody can send me
Regards
V.Kiran Kumar
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titl
One more way of doing it...
Sub Macro1()
Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select
Application.CutCopyMode = False
Range("A1:B" & Cells(Rows.Count,
"B").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"F1"), Unique:=True
Columns(
Recorded a macro and then cleaned it up. Use the second macro. Sub
MakeUniqueNumbers(). Save file as .xlsM
Sub Macro2() 'recorded
'
' Macro2 Macro
'
'
Range("D1").Select
Range("C1:D26").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"H1"), Unique:=True
Columns("I:
thanks one all for your help
On Tue, Dec 27, 2011 at 11:34 AM, Rajan_Verma wrote:
> Try this:
>
> ** **
>
> Dim intIAs Integer
>
> For intI = 1 To Len(rngVal.Value)
>
> If Asc(UCase(Mid(rngVal.Value, intI, 1))) > 64 And
> Asc(UCase(Mid(rngVal.Value, intI, 1))) < 91 The
Hi,
Use the below Code:
Sub hotlead()
Dim QStage As Range
Dim i As Integer
Set QStage = Range("Sheet1!A3:A21")
For i = 1 To 19
If QStage.Cells(i, 1) <> "Hot Lead" Then
QStage.Cells(i, 3).Value = ""
End If
Next i
End Sub
Regards,
MARIES.
On Tue, Dec 27, 2011 at 4:20 PM, Anjul Porwal
Dear Expert,
I want *B*lank Candidate Stages if Qualification Stage is not "hot
lead",this result only VBA Coding.
Regards
Anjul
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
All 20 sheets in one month file. Ex. November month file has 20 sheets and
december month file has 20 sheets. every sheet has its won name and every
file named as month-year ex.nov-11,dec-11.
suppose in nov-11 sheet11 named as abc the same name will continue in
dec-11.In cumulative totals in abc sh
Dear Group,
If I have some names & I want to create the unique codes how do I? I am
using code function but it creates some duplicates. Please see the attached
file & suggest.
Regards,
--
Regards,
Aamir Shahzad
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accu
plz see the attachemnt
-- Forwarded message --
From: Ansar Ellahi
Date: Tue, Dec 27, 2011 at 2:01 PM
Subject: $$Excel-Macros$$ Fwd: date of birth
To: excel-macros@googlegroups.com
-- Forwarded message --
From: Ansar Ellahi
Date: Tue, Dec 27, 2011 at 1:29 PM
Su
How do we identify the Month. Is 20 sheets are with Month Name
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of excel lerner
Sent: Dec/Tue/2011 03:50
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
thanks for ur quick rely Mr.Rajan Verma
thanks for ur quick rely Mr.Rajan Verma
Please find the attachment
--
FORUM RULES (934+ 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 atte
No attachement
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of excel lerner
Sent: Dec/Tue/2011 03:45
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ how to update sheets from other sheets
hi experts
Please find the attachme
hi experts
Please find the attachment and help me
I have 20 sheets in my monthly report.sheet 1 is main data source.from
that i want to copy totals to all these sheets.Some sheets has
cumulative totals which was add to previous month total to get
cumulative total.
At the same time some sheets ge
Lot of thanks sir
chandru
On Tue, Dec 27, 2011 at 3:06 PM, Maries wrote:
> Find the attachment..
>
>
> On Tue, Dec 27, 2011 at 1:29 PM, Rajan_Verma wrote:
>
>> See if it helps
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf
Find the attachment..
On Tue, Dec 27, 2011 at 1:29 PM, Rajan_Verma wrote:
> See if it helps
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran
> *Sent:* Dec/Tue/2011 02:13
> *To:* excel-macros@googlegroups.com
> *Subjec
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Dec/Tue/2011 02:13
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Max Value Min Value
Dear all
Pleae help Max value of S.No. based Min Val
Dear all
Pleae help Max value of S.No. based Min Value based on S.no. what
is formula
S.No Amount Max Min 10 25 10 -2 -2 10 75 10 165 16520 165 20 175
175 20 90 20 65 20 50 20 27 2730 -425 -425 30 665 30 1065 1065
if S.No. 10 containing 4 values what is max v
-- Forwarded message --
From: Ansar Ellahi
Date: Tue, Dec 27, 2011 at 1:29 PM
Subject: date of birth
To: rajanverma1...@gmail.com
came out actual date of birth
as below
december 27, 2011 minus march 16, 1986
with best regards
Ansar Ellahi
Management Office
*SML-Bhone (Jhang)
See the attached sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sent: 27 December 2011 02:03
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on chart
Is this the way you want
On Tue, Dec 27, 2011 at 1:39
Is this the way you want
On Tue, Dec 27, 2011 at 1:39 PM, lucky singh wrote:
>
> Hi Team,
>
> Request you to kindly help
>
> I want is a grid on the right & the red line to be highlighted properly
> with the blue lines
>
> Regards,
> Lucky S
>
> --
> FORUM RULES (934+ members already BANNED for
Try This...
Thanks and Regards,
Somnath C Pardeshi
From: lucky singh
To: excel-macros@googlegroups.com
Sent: Tuesday, 27 December 2011 1:39 PM
Subject: $$Excel-Macros$$ Help on chart
Hi Team,
Request you to kindly help
I want is a grid on the right & t
Hi Team,
Request you to kindly help
I want is a grid on the right & the red line to be highlighted properly
with the blue lines
Regards,
Lucky S
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
34 matches
Mail list logo
