http://www.rondebruin.nl/sendmail.htm
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Amit Desai (MERU)"
Sender: excel-macros@googlegroups.com
Date: Sun, 26 Aug 2012 11:41:06
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro for mail from exce
Dear Masters,
Please help me to with a macro which can send mail to recipient as mentioned in
different sheet.
For your reference I have attached a file containing 4 sheet. Sheet "All"
contains global data. Other 3 sheets covers sorted data with Vendor's name. In
each last 3 sheet, column X co
see if it helps
On Sun, Aug 26, 2012 at 9:40 AM, hemant shah wrote:
> Dear Experts,
>
> I haven't yet received solution for my query below.
>
> Please help.
>
> Regards,
>
> -- Forwarded message --
> From: hemant shah
> Date: Sun, Aug 19, 2012 at 12:56 PM
> Subject: Need help
Dear Experts,
I haven't yet received solution for my query below.
Please help.
Regards,
-- Forwarded message --
From: hemant shah
Date: Sun, Aug 19, 2012 at 12:56 PM
Subject: Need help on a formula
To: excel-macros
Dear Experts,
I am stuck up which my work in an excel. I n
I don’t understand what you are saying but I’m sure you can think of how to
adapt it.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dick
Sent: Saturday, August 25, 2012 7:15 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If number match
I'm so sorry. I forgot to mention Column B. Can that also be added in the
results as well. Same results as now but include Column B. Thanks so much
for your help!!!
On Saturday, August 25, 2012 7:18:03 PM UTC-4, Don Guillett wrote:
>
> Right click sheet tab>view code>insert this
>
> Private
Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Count > 1 Or Target.Column <> 3 Then Exit Sub
Set mf = Range("c1:c" & Target.Row - 1).Find(What:=Target, _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDir
Hi Rashid Khan.
You try this Macro stars. For column A.
Sub Permutation()
'Be Tran Van (be09)
Range("A:A").Select
Selection.NumberFormat = "/mm/dd"
End Sub
Want to go back to the original use Macro.
Sub Returns()
'Be Tran Van (be09)
Range("A:A").Select
Selection.NumberFormat
Need help in creating a macro to or formula:
Trying to stop repetative typing.
In column "C" I have a list of different numbers/letters
I would like to when the user types in that SAME number again, which would
also be in column "C"
Copy, the contents that are next the origional which would be col
And, it is a bit much to come to a forum like this and ask for an entire
project to be done for you. This is what some of us get paid for.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: ITP Abdulgani Shaikh
Sent: Saturday, August 25, 2012 2:48 PM
To: excel-m
Send your file direct to ME
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: prkhan56
Sent: Saturday, August 25, 2012 1:46 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to convert date at the time of entry
Hello Don Sir,
I tried the
also you will find people doing job like this on
www.incometaxindia.gov.inLOCATE TRP section and
www.trpscheme.com
On Fri, Jun 1, 2012 at 2:32 PM, Abdulgani Shaikh wrote:
> Dear Mr Tarun,
>
> This is already discussed in this forum. You will find free utilities
> available on NSDL website on fol
Hello Don Sir,
I tried the code
when I entered 30062012 - it changed to 12201632 instead of 20120630
I entered 08122012 it changed to 12208122 instead of 20121208
Can you please check
Thanks
On Saturday, August 25, 2012 5:55:22 PM UTC+4, Don Guillett wrote:
> Right click sheet tab>copy/past
eg -if its usa it should change to india..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, August 25, 2012 9:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code
Sorry Don. Thanks..for yo
Sorry Don. Thanks..for your reply
If i filter 15 country should change to india
eg -if its usa it should change to india..
On Sat, Aug 25, 2012 at 8:08 PM, dguillett1 wrote:
> You should use a MEANINGFUL subject line
> You should explain your problem in the body of the email
> If you attac
You should use a MEANINGFUL subject line
You should explain your problem in the body of the email
If you attach a file (good) then fully explain with examples
If you want a macro send a macro enabled file (xlsM)
You don’t say how you want your macro to fire. Why not just filter
Don Guillett
Hi all,
Please help me on attached file. Thanks
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formu
http://chandoo.org/wp/2008/07/21/dashboard-bullet-graphs-excel/
http://www.exceluser.com/explore/bullet.htm
On Sat, Aug 25, 2012 at 4:21 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi,
>
> What are bullet graphs,would request to share some examples with me.
> --
> Regards
> Sa
Right click sheet tab>copy/paste this>change column 8 to suit.
Now when you enter the number it will be fixed.
You may delete
my = "2012"
If Right(Target, 4) = my Then _
lines if desired
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 8 Then Exit Sub
my
Or, a regular sub
Option Explicit
Sub SAS()
Dim i As Long
Dim c As Range
Dim ms As String
Columns("N").Clear
On Error Resume Next
For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
ms = ""
For Each c In Rows(i).SpecialCells(xlCellTypeConstants, xlNumbers)
If c = 1 Then ms = ms & ", " & c.Offset(-c.R
In the future, please use a MEANINGFUL subject line.
Use this array formula and copy down.
=MAX(IF($C$2:$C$222=C2,$D$2:$D$222))-MIN(IF($C$2:$C$222=$C$2,$D$2:$D$222))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Neeraj
Sent: Saturday, August 25, 2012 1:11 A
Hello All,
I found the following function from ozgrid
which reverses a text string
Option Explicit
Public Function ReverseString(Text As String)
ReverseString = StrReverse(Text)
End Function
I want a macro which should reverse a date entered eg 30062012 to 20120630
as soon as *data is ente
Hi,
What are bullet graphs,would request to share some examples with me.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate th
check the attachment
On Thu, Aug 23, 2012 at 4:23 PM, sharad jain wrote:
> Hi All,
>
> Can you someone help us in putting the attached data in four quadrants
> chart in excel? We need name of the company against its dot.
>
> We have tried the following url, however it does not allows us to put
>
Hi Hilary
I used Excel 2003 So I tell you it is possible to see excel 2003. No
problem I will see it 2007.
Thanks
On Sat, Aug 25, 2012 at 1:40 PM, wrote:
> **
> Hi Amar
>
> I built the dashboard in 2007 and 2010 environment. Am not sure why you
> can't view in 2003. Maybe Most of the functions I
Hi Amar
I built the dashboard in 2007 and 2010 environment. Am not sure why you can't
view in 2003. Maybe Most of the functions I used are not in 2003 so Ʊ may
probably get an error.
Ʊ can upgrade your 2003 to 2007 or 10. 2010 also has 2003 environment so if Ʊ
prefer that you can stick to that
Hi All VBA Experts,
This is very Challenging work for me also you & Our other Excel users in
group.I required VBA code when our research report published on outlook
(Outlook 2003) then that report automatic save on give folder Path
(H:\Published Reports\India Reports).
So anyone put this challenge
27 matches
Mail list logo