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:
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 20 Sep 2012 17:01:21 -0500
To: excel-macros@googlegroups.com
ReplyTo: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time
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
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:
,
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
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,
-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 dguille...@gmail.com
Sender
AM, dguillett1 dguille...@gmail.com 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 = ss.Rows(1).Find(What
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 20 Sep 2012 15:04:40 -0500
To: excel-macros@googlegroups.com
ReplyTo: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ All time high Price *
Why use a complicated formula that can
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,
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:=xlByRows,
: 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
Sub
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:
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
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:
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, f) =
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 =
-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
=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
Unlock ALL cells and use a worksheet_selectionchange event to lock itthen
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
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
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
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
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
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:
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
-
From: dguillett1 dguille...@gmail.com
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 unnecessary and undesirable
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
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 Date
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:
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 dguille...@gmail.com wrote:
Why clutter it up by using UN necessary formulas
: $$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
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
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-macros
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,
, Rajan_Verma rajanverma1...@gmail.com 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
Subject
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
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
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
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
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
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
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
the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, September 6, 2012 8:37:44 AM
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
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
One way using this array formula (entered using ctrl+shift+enter CSE)
INDEX($C:$C,MATCH(LARGE(IF($F$5:$F$15fail,$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:
Put in H5 and copy down
=SUMPRODUCT(--($F$5:$F$14fail),--(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 Formula
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
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$$ Combining
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
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,
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 ?
=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$$
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
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
This is an array formula that must be entered using ctrl+shift+enter
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,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:
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
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
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
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 dguille...@gmail.com wrote:
See attached using this macro for the CORRECT answer
Option Explicit
Sub sumcollectionSAS()
Dim mf As Range
Dim cr
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
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
=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$$
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
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
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
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
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
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 macro
I thought I answered this
Right click sheet tabview codeinsert 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,
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
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
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.Row + 1)
Right click sheet tabcopy/paste thischange 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 =
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
..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 dguille...@gmail.com wrote:
You should use a MEANINGFUL subject line
You should explain your problem in the body of the email
If you attach
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
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:
Right click sheet tabview codeinsert 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, _
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
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:
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)
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 dguille...@gmail.com wrote:
My guess is that you
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
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 =
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
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)
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,
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:27
To: excel
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
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:
Just use datafilterautofilter
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
, 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 dguille...@gmail.com wrote:
Just use datafilterautofilter
Don
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
(--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 dguille...@gmail.com wrote:
Looks like homework to me also but this should do it AFTER rounding your
column B into column
Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kuldeep Singh
Sent: Thursday, August 16, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF AVERAGEIFS★▂ ▃ ▅ ▆ █]
Hi Experts,
What is the correct use of
file Pls see attached file.
On Tue, Aug 14, 2012 at 10:06 PM, dguillett1 dguille...@gmail.com wrote:
The macro I gave you answers the question in the post of being able to change
the chart NAME.
If you want something else, send me the file again and a complete
explanation.
Don Guillett
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 dguille...@gmail.com wrote:
The macro I gave you answers the question
You did not elaborate on your formulas but I’ll bet you are using entire
columns instead of limiting to needed area.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Wednesday, August 15, 2012 8:48 AM
To: excel-macros@googlegroups.com
1 - 100 of 1000 matches
Mail list logo