And my question is why have 200 files. Provide a sample master file and a
sample slave file.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Saturday, September 22, 2012 9:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
saving file will CALCULATE
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: johnson john
Sent: Friday, September 21, 2012 7:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula not being copied down
Hellow Guys,
While copying formula in
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 20 Sep 2012 17:01:21 -0500
To:
ReplyTo: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time high Price * *
This message is el
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 20 Sep 2012 15:04:40 -0500
To:
ReplyTo: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time high Price *
Why use a complicated formula that can inadvertently be deleted when the
AM, "dguillett1" wrote:
Put this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("b1")) Is Nothing Then Exit Sub
Dim ss As Worksheet
Dim mf As Range
Set ss = Sheets("Monthly End Prices")
Set mf
-Macros$$ All time high Price *
Thanks Don. Really appreciate. Pls can you assist with an excel formula as
well?
Sent from my BlackBerry® smartphone from Airtel Ghana
From: "dguillett1"
Sender: ex
Put this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("b1")) Is Nothing Then Exit Sub
Dim ss As Worksheet
Dim mf As Range
Set ss = Sheets("Monthly End Prices")
Set mf = ss.Rows(1).Find(What:=Target, LookIn:=xlFormulas, _
LookAt:=xlWhole, S
,
Jaideep
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Thursday, September 20, 2012 12:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not
Are you saying that you want to HIDE COLUMNS??? Please define your problem with
examples if possible.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, September 20, 2012 1:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Wednesday, September 19, 2012 8:20 PM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Use this INSTEAD
Use this INSTEAD
Sub GetSumsSAS()
dim lr as long
Dim c As Range
Dim ms As String
Application.ScreenUpdating = False
lr=cells.specialcells(xlcelltypelastcell).row
With Worksheets(1).Range("f10:f" & lr)
Set c = .Find("site charge", LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRo
Option Explicit
‘puts all as 8000 and then changes for marrieds.
Sub FilterforMarriedSAS()
Dim lr As Long
Dim c As Range
lr = Cells(Rows.Count, "e").End(xlUp).Row
Cells(3, "f").Resize(lr - 2).Value = 8000
Range("$B$2:$F$" & lr).AutoFilter Field:=4, Criteria1:="Married"
lr = Cells(Rows.Count, "e").E
looks a lot like one of mine..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, September 17, 2012 10:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fw : Search tool in Excel sheet
In attached file you can
And then send the file to some of us to break the password.
I would suggest different workbooks with the workbook protected. Safer.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Monday, September 17, 2012 7:17 AM
To: excel-macros@googleg
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Sunday, September 16, 2012 6:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN
E AND G AND UPDATE THE VALUES.
Does this give the same
Put this function in a REGULAR module. Then =myfunc(a1)
Function myfunc(xx)
Dim nodupes As New Collection
arr = Split(xx, "|")
For i = LBound(arr) To UBound(arr)
On Error Resume Next
nodupes.Add arr(i), arr(i)
On Error GoTo 0
Next i
For i = 1 To nodupes.Count
holder = hol
Does this give the same result? In the data provided, a NEVER matches e
Option Explicit
Sub checksyssystemsas()
Dim r As Long
For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row
If Cells(r, "a") = Cells(r, "e") And Cells(r, "c") = Cells(r, "g") Then
‘msgbox r ONLY one match at row 1129
Cells(r, "
or one line
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then columns(i).Hidden = True
next i
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Sunday, September 16, 2012 5:48 AM
To: excel-macros@googlegroups.com
Unlock ALL cells and use a worksheet_selectionchange event to lock it>then
protect sheet
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: sharad jain
Sent: Friday, September 14, 2012 6:37 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Locking
=SUMPRODUCT(MAX((A2:A10=g2)*(E2:E10)))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Sundarvelan N
Sent: Friday, September 14, 2012 6:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ find the latest date
Dear Friends,
Please help me to f
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three par
All I had to do was unhide the sheet. and the code was not protected
(easily defeated)
. Even if you had hidden with xlVERYHIDDEN code could unhide.
Although more trouble, you may want to use separate protected workbooks where
security is higher for most users.
Don Guillett
Microsoft Excel
As Paul said, there is a better way. Provide a file.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SridharBL
Sent: Wednesday, September 12, 2012 4:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Work
Looks like the best solution which also should sort
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Tuesday, September 11, 2012 9:14 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Unique from Multiple sheet
Su
ong as ever you can.” - John Wesley
-
----
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Tue, September 11, 2012 9:32:59 AM
Subject: Re: $$Excel-Macros$$ Re: Unique from Multiple sheet
Since op did not indicate version your solution would not work prior to xl2007
and you have unn
I suggest NOT receiving in PDF format
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SAGAR KASANGOTTUWAR
Sent: Tuesday, September 11, 2012 12:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: PDF to excel table
Dear Chethan,
You ca
Since op did not indicate version your solution would not work prior to xl2007
and you have unnecessary and undesirable SELECTIONS.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Vabz
Sent: Tuesday, September 11, 2012 2:14 AM
To: excel-macros@googlegroups.c
Homework done...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Tuesday, September 11, 2012 4:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help A
Guillett,
I would like to know all possible ways of cutting the string into three parts.
So please do needful by suggesting very simple formula for same.
Thanks !!!
On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 wrote:
Why clutter it up by using UN necessary formulas to clutter up the file
Why clutter it up by using UN necessary formulas to clutter up the file?
Unless, of course, this is HOMEWORK
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Monday, September 10, 2012 6:11 AM
To: excel-macros@googlegroups.com
Subject: Re:
nil Bhange
IP Phone – 800105 | Mobile - +31 6 1192 3971
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Friday, August 31, 2012 03:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required Revenue started from D
: $$Excel-Macros$$ Re:
Hi Don
The question said the colours are set by conditional formatting. This does not
affect interior.ColorIndex. AFAIK the only way to do it is to apply the same
test for the condition as you used in the conditional formatting.
On 10 September 2012 02:18, dguillett1
Or this to look in column A for the colors in column C
Sub sumcolormatchSAS()
Dim c As Range
Dim i As Long
Dim csum As Long
For Each c In Range("c2:c3")
c.Offset(, 1) = 0
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(i, 1).Interior.ColorIndex = c.Interior.ColorIndex Then _
c.Offset
Your excel version is _)___
How did the cells become colored__
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: harshad shukla
Sent: Sunday, September 09, 2012 1:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
dear all,
See attached for desired solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent: Monday, August 27, 2012 11:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Required a search option in excel file
Hi Praveen,
Pleas
you please share the formula in excel file, to understand better.
Regards,Anil Bhange
IP Phone – 800105 | Mobile - +31 6 1192 3971
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Friday, August 31, 2012 03:10 PM
To: excel-mac
YES
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anjali .
Sent: Saturday, September 08, 2012 5:57 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Merged Cell
Mr. David,
Is it the rule of this group???
if it is, then definitely i will d
Why is your request more URGENT than any other request??
When all else fails, "read the f___ing instructions"
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 attention or may not b
Is there some reason you cannot “google” it yourself
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: maksood alam
Sent: Friday, September 07, 2012 12:50 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas
Hi
me too..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Friday, September 07, 2012 11:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here)
Is it me? or does the
Please do not RE post at a later time. RUDE! And, VERY RUDE to use URGENT. Your
request is NOT more urgent than anyone else.
Since not all students would always have all years I would suggest a vba macro
to do this. Is that OK.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@
Please give a complete explanation of the logic
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: LAKSHMAN PRASAD
Sent: Friday, September 07, 2012 1:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Collecting interest details only at the time o
, Sep 6, 2012 at 7:49 PM, Rajan_Verma wrote:
Same as don
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: 06 September 2012 6:08
To: excel-macros@googlegroups.com
Sub
Put in a workbook module to find another file to unlock vba
Option Explicit
'Your password goes here
Const gszProjPassword As String = "hello"
Public Sub UnlockMe()
Dim wbName As Variant
Dim wbBook As Workbook
Dim vbaProj As Object
Dim oWin As Object
Dim X As Integer
On Error GoTo ErrorHand
6) Jobs posting is not allowed,
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Vinay Kumar
Sent: Thursday, September 06, 2012 8:58 AM
To: Vinay Kumar
Subject: $$Excel-Macros$$ Sun IDM Developer in NY
Req: Sun IDM Developer
Location: NY
Duration 12 mon
t all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
----
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, September 6, 2
ditto
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, September 06, 2012 6:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Please Help
Have you read the "Forum Rules"?
(Well, SOME are more of a "guide
I did NOT look at your attachment because you did not provide a meaningful
subject line in your post and you did not explain your problem in the body of
the email. I hope you explained, with examples, in the file. But, I didn’t look
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguill
I did NOT look at your attachment because you did not provide a meaningful
subject line in your post and you did not explain your problem in the body of
the email. I hope you explained, with examples, in the file. But, I didn’t look.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dgui
Put in H5 and copy down
=SUMPRODUCT(--($F$5:$F$14<>"fail"),--(D5<$D$5:$D$14))+1
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: kumar Kishore
Sent: Tuesday, September 04, 2012 7:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rank Formul
One way using this array formula (entered using ctrl+shift+enter CSE)
INDEX($C:$C,MATCH(LARGE(IF($F$5:$F$15<>"fail",$D$5:$D$15),ROW(A1)),$D:$D,0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Tuesday, September 04, 2012 6:41 AM
To: excel-m
Good job
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@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 thread titles. Poor thread titles, l
Thanks Don.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: 01 September 2012 19:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need update on the attached Macro
I think you will need to use some if’s or selectcase
try this idea for ONE line
ActiveCell = ActiveCell & Application.CountIf(Range("c3:c33"), "ccc")
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: mburkett
Sent: Friday, August 31, 2012 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Combi
Provide a file and a complete explanation and examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Muralidhar E
Sent: Monday, September 03, 2012 3:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count when po is greater than zero
H
=SUM('2012 Actual'!C3:OFFSET('2012 Actual'!C3,0,MATCH($H$3,'2012
Actual'!$1:$1,0)-3))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Steve Weaver
Sent: Wednesday, August 29, 2012 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Returning
a public variable, perhaps.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kanwaljit Singh
Sent: Sunday, September 02, 2012 1:49 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ EXCELLENT MIND READING
Hi,
Someone Noted how it works ?
On
Sheet was VERYHIDDEN by code
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Bé Trần Văn
Sent: Saturday, September 01, 2012 1:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Trawets
I help you complete File Obse
I think you will need to use some if’s or selectcase. Test using this
Sub selectcase()
Select Case ActiveCell.Column
Case Is = 14: x = "column 14"
Case Is = 15: x = "column 15"
Case Else
End Select
MsgBox x
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
F
The "team" will be happier to help if you use a meaningful subject line and
lose the URGENT!!!
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: PRAVESH KUMAR
Sent: Friday, August 31, 2012 1:09 PM
To: excel-macros@googlegroups.com
This is an array formula that must be entered using ctrl+shift+enter
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kuldeep Singh
Sent: Friday, August 31, 2012 7:35 AM
To: excel-macros@googlegroups.com
Subject: $$Ex
If they're in one column...
Select the range
data|text to columns
choose fixed width and remove any lines that excel guessed
choose Date (ymd)
and plop it in the same range as where you picked it up.
And format those (now real) dates the way you want.
Or, a nice ONE liner
Sub ConvertStringToDa
Cells(r, "G") = "=sum(G1:G&r)"
' For an example if r=50 then Cells(50,"G")=Sum(G50:G1)
End If
Next
End Sub
-
Regards,
Dilan
On Thu, Aug 30, 2012 at 4:31 PM, dguillett1 wrote:
See attached using this macro for the CORRECT answer
Op
WithOUT looking at your file(s) something like this pseudo code
‘open each file
for i=1 to 3
sheets(i).usedrange copy
workbooks(“masterfile.xls”).sheets(i).cells(rows.count,1).end(xlup)(2)
next i
‘close each file
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From
I see you have answers but why is YOUR request more URGENT than any other?
Also, use a meaningful subject line and explain your question in the email
and in the file.
etc.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: PRAVESH K
Provide examples and logic
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Steve Weaver
Sent: Wednesday, August 29, 2012 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Returning a cumulative value based on the contents of
a given cell
=IF(ISNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1)))
copy down
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: mailto:in.vaib...@gmail.com
Sent: Tuesday, August 28, 2012 11:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
http://www.ofx.net/DownloadPage/Downloads.aspx
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: RAJA SEKAR
Sent: Wednesday, August 29, 2012 12:01 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ OFX to Excel-Reg
Dear All,
Is it Possible to get
I would do this with a macro. Provide a file to ME along with this msg and
examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: in.vaib...@gmail.com
Sent: Tuesday, August 28, 2012 1:04 PM
To: excel-macros@googlegroups.com
Su
Didn’t anyone see my solution???
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent: Monday, August 27, 2012 11:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Required a search option in excel file
Hi Praveen,
Please
Please don't ban me (I won't do it again) but I have this that someone may
want badly.
If you don't know what it is you probably wouldn't be interested.
Contact off list ONLY
Baler xe ver 1.0 ser 741095 complete
Baler Ice 1.0 960455
Visual Baler
Baler xe 2.0 books
Don Guillett
Microsoft Excel De
Change the lookin:XLvalues to xlFORMULAS
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dick
Sent: Sunday, August 26, 2012 8:18 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Run code to also include hidden rows
Is there a way to also includ
I thought I answered this
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, SearchOr
Put this in the sheet module and PRE format your column as TEXT
Private Sub Worksheet_Change(ByVal Target As Range)
Dim s As String
s = Target
Application.EnableEvents = False
Target = Right(s, 4) & Mid(s, 3, 2) & Left(s, 2)
Application.EnableEvents = True
End Sub
Sub FixIt()’in case event macr
The macro I sent you was designed to do EXACTLY that. When you enter the 8
digits they will be changed automatically to your desire. I asked you to send
me the file you TESTED and you did not do so... When you do as I requested and
tell me exactly what happens I will help you.
Don Guillett
Mi
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
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
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
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 attach a file (good) then
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
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
Why is YOUR request more URGENT than the request of anyone else?
And, it appears that instead of asking a question to help yourself you are
asking for a project to be done for free. Really!
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: jocky Beta
Sent: Frid
& Highlight name in list (1000 name list)
Don Guillett Sir,
Actually I cant understand this code,I put this code but not show result. Can
you explain me or put code in this sheet & send me.
Thanks
Amar
On Wed, Aug 22, 2012 at 5:59 PM, dguillett1 wrote:
My guess is that you didn’t
My guess is that you didn’t like my solution.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Wednesday, August 22, 2012 1:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cel
Move your destination sheet to be the FIRST SHEET and use this
Sub combineem()
For i = 2 To Sheets.Count
Sheets(i).UsedRange.Copy Sheets(1).Cells(Rows.Count, 1).End(xlUp)(2)
Next i
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rakesh Kumar Sharma
Se
I would use a worksheet_change macro to do an autofilter for you. To show all
select c5 and touch space bar
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("b5:d5")) Is Nothing Then Exit Sub
If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData
tc = Target.C
There are many ways...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rakesh Kumar Sharma
Sent: Tuesday, August 21, 2012 6:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Merging Two excel sheets on single sheet
Dear Experts,
Is there an
August 20, 2012 1:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MS Excel Vlookup query
Hi,
I need a formula plz.
My data base is very huge. i cannot use autofilter.
On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote:
Just use data>filter>autofilter
Don Guil
Just use data>filter>autofilter
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: vinod rao
Sent: Monday, August 20, 2012 12:35 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MS Excel Vlookup query
Hi Team,
I want to put vlookup or any other f
something like this to lock b if a=b
for each c in range(“a4:a10”)
if c.value=c.offset(,1).value then c.offset(,1).locked=true
next c
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Santosh Singh
Sent: Monday, August 20, 2012 10:47 AM
To: excel-macros@goog
Your first sample showed a blank col B. Try this
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cel
s is never permanent, Failure is never final, so always do not stop
effort until your victory makes a history.
Please consider the environment before printing this message
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: 08/20/2012 18:2
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 3 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 3).Resize(l
(--SUBSTITUTE(ROUND(B3:B21,2),MODE(ROUND(B3:B21,2)),MAX(B3:B21)+ROW(INDIRECT("1:"&ROWS(B3:B21)
Regards,
Sam Mathai Chacko
On Fri, Aug 17, 2012 at 7:07 PM, dguillett1 wrote:
Looks like homework to me also but this should do it AFTER rounding your
column B into column A
=IN
Looks like homework to me also but this should do it AFTER rounding your column
B into column A
=INDEX($A$3:$A$21,MATCH(LARGE(FREQUENCY($A$3:$A$21,$A$3:$A$21),ROW(A1)),FREQUENCY($A$3:$A$21,$A$3:$A$21),0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit G
16, 2012 3:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range
Hi dguillett Sir,
I will send file Pls see attached file.
On Tue, Aug 14, 2012 at 10:06 PM, dguillett1 wrote:
The macro I gave you answers the question in the post of being
1 - 100 of 1086 matches
Mail list logo
