You are doing a good job with a good forum.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Wednesday, March 21, 2012 5:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ** FIVE YEARS COMPLETION**THANK YOU**
Dear
In the absence of a better explanation you might try sitting on them
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Sent: Thursday, March 22, 2012 12:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compress of images
Dear Group
I already posted a reply
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range(a2:a10)
c = Application.Trim(c)
fs = InStr(c, )
ls = InStrRev(c, )
c.Offset(, 1) = Mid(c, fs, ls - fs)
Next c
Columns(b).AutoFit
End Sub
Don Guillett
Microsoft MVP Excel
...@gmail.com
From: Indrajit $nai
Sent: Thursday, March 22, 2012 1:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.
@ dguillett1, PFA for your reference.
On Thu, Mar 22, 2012 at 4:28 AM, dguillett1 dguille
good to see this resolution but can anyone explain this in simple way
Regards
Modi
On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 dguille...@gmail.com wrote:
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range(a2:a10)
c
And what if both?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vinod rao
Sent: Thursday, March 22, 2012 9:35 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel conditional formatting-Urgent plz
Hello Experts,
I need a conditional cell color
I would suggest a table such as with numbers in col 1 and d in col2 I col 3,
etc (easier to change in future)
then use match index
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: LAKSHMAN PRASAD
Sent: Friday, March 23, 2012 2:25 AM
To:
From the comments, I only wish I could read it.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, March 22, 2012 1:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो
http://contextures.com/xlDataEntry02.html#Fill
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Jim Schug
Sent: Thursday, March 22, 2012 8:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Simple VBA to Fill in blanks
Hi,
I'm nearly brain dead
Glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Thursday, March 22, 2012 5:59 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time
macro.
Thanks @ dguillett1
friends, is now 5 years old..
Sorry for terrible translationits not easy to reproduce a masterpiece
2012/3/23 dguillett1 dguille...@gmail.com
From the comments, I only wish I could read it.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN
Makes me wonder what this is for. Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Pascal Baro
Sent: Friday, March 23, 2012 8:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Cash allocation - your advice
Hi Cyberspace,
Please find a
I haven’t followed this but I think Charlie has a older version ( if that makes
a difference) ??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Saturday, March 24, 2012 2:27 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$
try
=IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$B$9,B6)=1,COUNTIF($E$12:$E$15,F9)),1,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, March 24, 2012 5:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
try this simpler version where I rewrote the formulas in the c:e and then
copied that block to each of the other blocks
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Lokesh Loki
Sent: Saturday, March 24, 2012 11:25 AM
To: excel-macros@googlegroups.com
Subject:
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Saturday, March 24, 2012 11:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Is there a way to tell excel the first row is
definitely data and not column names?
Excel keeps
Are you saying that you start with the final amount, ie 309.84 then use the
required values @ 66 to find the amount of each various amount needed to get to
the difference to come up with (bottom row shown here)
66
20 10 5 1 50p 20p 10p 5p 2p 1p total
20.00 10.00
Show us your before/after data and/or send a file with explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: karunanithi ramaswamy
Sent: Tuesday, March 27, 2012 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REG:$$Column to table
Sub InitRefs()
dim fv As long
dim lv As long
With Sheets(“ChartData”)
fv= .Application.Match(Stopval, .Rows(1), 0) ‘notice the dot (.) before rows
End With
With Sheets(“Results”)
lv = .Application..Match(ReverseDate, .Rows(1), 0) ‘dot NOT needed on
ACTIVE sheet but needed here.
End With
May be useful to test LEN of cell (1051)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Tuesday, March 27, 2012 1:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
See if attached sheet is useful by formula
Why not just use datafilterautofilter
see att
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Wednesday, March 28, 2012 1:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula for Unique Values with Condition
Hi All,
more info on the AFTER look.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ram
Sent: Wednesday, March 28, 2012 12:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd:
Can you help on below. I want to convert
the data in the big table
on my BlackBerry® from Vodafone
Thanks Regards.
Kiran
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Mar 2012 14:07:13 -0500
To: excel-macros@googlegroups.com
ReplyTo
sub findd()
dim c as range
for each c in range(“a2:a22”)
if ucase(left(c,1))=”D” then msgbox c
next c
end sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Preston Moore
Sent: Wednesday, March 28, 2012 12:52 PM
To: excel-macros@googlegroups.com
Subject:
what about
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, March 28, 2012 3:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
Hi All,
thanks a lot for everyone, special to Aamir yes this
'Assumes this in DV list
'DC36U
'DC44U
'AC42U
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DC36U As String
Dim DC44U As String
Dim AC42U As String
'??DC36U = Tekelec Eagle XG 870-3040-06 (DC)
'??DC44U = Tekelec Eagle XG 870-3068-06 (DC)
'??AC42U = Tekelec
Do you mean values 0 such as 2 for the last example?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ravi Kumar Vandavasi
Sent: Tuesday, March 27, 2012 10:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Reading custom format as it appears in a
https://www.google.com/#hl=ensugexp=epsugrstmags_nf=1tok=yQU8bSdwbrVg0d2-9kIpdgcp=17gs_id=25xhr=tq=excel:+dbf+to+csvpf=poutput=searchsclient=psy-aboq=excel:+dbf+to+csvaq=aqi=aql=gs_l=pbx=1bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osbfp=7fb1484f2d5d4b11biw=1066bih=670
Don Guillett
Microsoft MVP Excel
http://x61.ch/ee9a3f
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Garcia
Sent: Thursday, March 29, 2012 3:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA
Hi,expert,
can you help me to read sap
BTW. You could use data validation to guide them to ONLY input as desired. Or,
an input box macro.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Thursday, March 29, 2012 7:18 AM
To: excel-macros@googlegroups.com
Subject: Re:
Maybe you could just change the format for all
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ravi Kumar Vandavasi
Sent: Thursday, March 29, 2012 7:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reading custom format as it appears in a
Read the forum rules at the bottom of each msg.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: vikin...@gmail.com
Sent: Thursday, March 29, 2012 10:50 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Thanks in advance
Send ME to MY email your file with my macro and this msg
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anil Pandit
Sent: Friday, March 30, 2012 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of
Show AFTER examples and why
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Friday, March 30, 2012 6:45 AM
To: excel-macros@googlegroups.com
Cc: LAKSHMAN PRASAD
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
sir,
Here i attach an
Start over by telling us what you are trying to do... Code can be greatly
simplified. Pls do not use “urgent” in your request. It is rude.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Zibraan
Sent: Friday, March 30, 2012 7:00 AM
To:
20 still sounds like a lot to me. I suggest a TOC on a menu sheet with a
doubleclick macro to goto the sheet desired.In fact, you may even want the
sheets to be named 1,2, etc.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, March 30,
Dis you NOT read what Sam said about what you just did???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ChilExcel
Sent: Friday, March 30, 2012 3:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unprotect - VBA Password
Please see
glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Preston Moore
Sent: Friday, March 30, 2012 1:58 PM
To: excel group ; dguille...@hmail.com
Subject: RE: $$Excel-Macros$$ Test to see if cell value starts with a D
Don,
Thank you for your help; it works
Copy/paste this into a module in an file saved as .xlsM
Sub deleterowsif()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Len(Application.Trim(Cells(i, 2))) 1 _
Or Cells(i, 1) = Cells(1, 1) Then Rows(i).Delete
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finos
Sent: Saturday, March 31, 2012 12:53 PM
To: excel-macros@googlegroups.com
Cc: dguille...@gmail.com
Subject: sumproduct.xlsx
Thanks for ur
for January use 1 in cell a1
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ASHOK PHALKE
Sent: Monday, April 02, 2012 2:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ CONDITIONAL SUM
One way to learn is to record a macro while doing manually
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kremstep
Sent: Sunday, April 01, 2012 11:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816
If desired, reply directly to me with your file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Monday, April 02, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
I am sending you excel
Option Explicit
Sub InsertRowsSAS()
Dim lr As Long
Dim r As Range
Application.ScreenUpdating = False
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range(a2).Resize(lr)
.AutoFilter Field:=1, Criteria1:==category*
For Each r In .SpecialCells(xlVisible)
Rows(r.Row + 1).Insert
Next r
.AutoFilter
End
Use cell instead due to text box limit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Thursday, April 05, 2012 6:51 AM
To: excel-macros
Subject: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Good Afternoon Experts
In
How?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Thursday, April 05, 2012 8:03 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Hi please find the attached sheet
Rajan
Not much info but you can probably change the format.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, April 05, 2012 10:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ to remove time
Hi ,
12/2/2001 12:00 PM
of words in Rectangular Shape box problem
I have seen the code he used, i think its
Sub ListBox1_Change()
Sheet2.Shapes(shpMyShape).TextFrame.Characters.Text = Sheet1.Range(A24)
End Sub
On Thu, Apr 5, 2012 at 3:20 PM, dguillett1 dguille...@gmail.com wrote:
How?
Don Guillett
Microsoft MVP
Should do it
sub clearallbuttoprow()
Sheets(Results).UsedRange.Offset(1).Clear
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Thursday, April 05, 2012 6:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ how to clear all
And would offset(0,1) mean skip the first column?
On Thu, Apr 5, 2012 at 5:01 PM, Domain Admin domainqu...@gmail.com wrote:
That works, thanks. How do you find out all the properties or
functions or whatever of usedrange etc.?
On Thu, Apr 5, 2012 at 4:47 PM, dguillett1 dguille...@gmail.com wrote
Try either of these. If you want more than one incorporate AND
Sub DeleteFilteredRowsSAS()
With Range(B5:B Cells(Rows.Count, 2).End(xlUp).Row)
.AutoFilter field:=1, Criteria1:=*SETOUTS*
.Offset(1).SpecialCells(xlVisible).EntireRow.Delete
' MsgBox hi
.AutoFilter
End With
End Sub
Or automatic by simply entering the number and using a change_event macro
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Friday, April 06, 2012 8:52 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ need excel dyanmic web query
, Apr 7, 2012 at 1:02 AM, dguillett1 dguille...@gmail.com wrote:
Try either of these. If you want more than one incorporate AND
Sub DeleteFilteredRowsSAS()
With Range(B5:B Cells(Rows.Count, 2).End(xlUp).Row)
.AutoFilter field:=1, Criteria1:=*SETOUTS*
.Offset(1).SpecialCells
Did you delete rows using the row indicator at the left of the sheet?
Did you SAVE the file after so doing?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Saturday, April 07, 2012 4:24 PM
To: excel-macros@googlegroups.com
Subject:
I would probably design the project differently but
Put this is c2 and copy across and down
=SUMPRODUCT((Data!$A$2:$A$270=$A2)*(Data!$B$2:$B$270=$B2)*(Data!$C$2:$C$270=C$1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, April 07,
If you mean { } this is because it is an array formula where you do NOT put
in the brackets. You save or change the formula using ctrl+shift+enter instead
of just enter.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, April 07,
Provide a file with examples
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Domain Admin
Sent: Saturday, April 07, 2012 3:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ runtime error on assignment trying to find
only goes to 32768 - use long
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Saturday, April 07, 2012 2:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ runtime error on assignment trying
Sub roundvalues()
Dim c As Range
For Each c In Range(a2:z22).SpecialCells(xlConstants, xlNumbers)
c.Value = Application.Round(c, 2)
‘OR vba round which may round down instead of rounding OFF
‘ c = Round(c, 2)
Next c
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
way to create a used range on each column?
On Mon, Apr 9, 2012 at 9:42 AM, dguillett1 dguille...@gmail.com wrote:
read this
http://support.microsoft.com/kb/194983f
simple change. Keep the special cells just in case or try without
For Each c In activesheet.usedrange
but blanks will now be 0
. The
separate files so created will be saving lot of our SPACE .Currently
anyway I am doing it MANUALLY [ rathersorry state!! ] Print out of
the repo, we do at our HdOfice. and w/o a macro it takes too much of
time...[ over five hundred LEFT clicks alone!! ]
=mangal ho
On 4/9/12, dguillett1
this loop be replaced by some range
method?
No need. I figured out my last question and your method works fine, thanks.
On Mon, Apr 9, 2012 at 11:40 AM, dguillett1 dguille...@gmail.com wrote:
Send your file to ME with an explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille
This is an excel forum. Pls post excel files.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Patil MG
Sent: Friday, April 13, 2012 1:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed
Hi Kumar /
You may send you file to ME with a complete explanation
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Bhalara
Sent: Friday, April 13, 2012 7:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Error while inserting raw
Dear expert
Please
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mr Excellent
Sent: Friday, April 13, 2012 5:22 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Index function help needed
Hi All,
Need a simple index function with a drop given to auto publish the
You need to provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nikhil Shah
Sent: Saturday, April 14, 2012 2:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Quarter Classification
Dear Friends,
I want to make the whole year
Provide your file with examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ITP Abdulgani Shaikh
Sent: Saturday, April 14, 2012 1:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If date in One then another cell to be unlock
Dear Freinds,
On your protection, why not just leave unprotected...
On your macros, see attached (Sent direct to OP)
‘---
Option Explicit
Sub AddSheetSAS()
ActiveWorkbook.Save
Dim i As Long
Dim s, k As String
s = InputBox(Please Enter INITIALs of Employee as Sheet Name to be added)
For i = 1 To
Thanks to all who have responded or will.
Someone must have know that it is my 76 th birthday today.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Saturday, April 14, 2012 3:36 AM
To: excel-macros
Subject: $$Excel-Macros$$ Most helpful Member -
).ClearContents
Please guide
Thanks a lot for everything, that's what I want really.
Regards
On Sat, Apr 14, 2012 at 8:34 PM, dguillett1 dguille...@gmail.com wrote:
On your protection, why not just leave unprotected...
On your macros, see attached (Sent direct to OP)
‘---
Option
I haven't paid much attention to this so..
If you are still having a problem with this you might consider using the
FIND method to get the last value you want
Send your file direct to me if desired with a complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
If your request is for a reply, I did reply.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Abdulgani Shaikh
Sent: Saturday, April 14, 2012 5:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Provide file(s) and complete explanation and examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mr excel
Sent: Sunday, April 15, 2012 9:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find differences in two worksheets.
hi group,
I had
Did you NOT get this
Private Sub Worksheet_Change(ByVal Target As Range)
'SalesAidSoftware dguille...@gmail.com
Application.EnableEvents = True
If Target.Address = $C$3 Then
Me.Unprotect
With Range(E3)
If Target = 0 Or Len(Application.Trim(Target)) = 0 Then
.Locked =
or UN tested
Sub Macro1()’adjust your destination range azz1
dim I as long
For i = 9 To Range(azz1).Column step 7
Range(A1).Copy Cells(1, i)
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Monday, April 16, 2012 11:26 AM
To:
You did not provide an example but I would suggest you only use ONE sheet and
simply use
datafilterautofilter
to filter the data you want and hide the columns you don’t want to show.
A macro can be used to do this for you
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
http://www.contextures.com/xlDataVal13.html
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: chhajersandeep.s...@gmail.com
Sent: Wednesday, April 18, 2012 4:50 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Dynamic data
How about a nice macro instead
Sub incrementnumbersSAS()
fn = 1
Ln = 3 ‘last number to increment
fr = 11
For i = 1 To Ln * fr Step fr
Cells(i, b).Resize(fr) = fn
'MsgBox i
fn = fn + 1
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Krishnaraddi
Sent:
Try this
option explicit
Sub printifSAS()
Dim x As String
If Range(a2) Range(b2) Then x = file1: Call printitSAS(x)
If Range(c2) Range(d2) Then x = file2: Call printitSAS(x)
‘etc
End Sub
Sub printitSAS(x As String)
Dim strPath As String
Dim wb As Workbook
strPath = c:\sheets\ x .xls
Set wb =
Why create a workbook for each user when all you have to do is filter
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Vijay Mane
Sent: Wednesday, April 18, 2012 12:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help--macro
Hi Experts,
This will do for one. Adapt for the other. See attached
Option Explicit
Sub FindAccountInTallySAS()
Dim i As Long
Dim mf As Range
For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
With Sheets(Tally)
Set mf = .Columns(e).Find(What:=Cells(i, c), LookIn:=xlValues, _
LookAt:=xlWhole,
Provide a file with a complete explanation and before/after examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: tangledweb
Sent: Wednesday, April 18, 2012 6:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ What is left behind when you clear
Why? Anyway, right click sheet tabview code insert thismodify ranges to suit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range(a2).Address Then _
Range(a3) = Range(a3) + 1
If Range(a3) 2 Then MsgBox Edited more than twice
End Sub
Don Guillett
Microsoft MVP Excel
=SUMPRODUCT(--ISNA(A1:Z1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Divaker Pandey
Sent: Friday, April 20, 2012 7:28 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel function
thank for
Look at the source data of the chart to see that it is hidden under the
chart
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh Janardanan
Sent: Saturday, April 21, 2012 1:37 PM
To: excel-macros@googlegroups.com
Subject: Re:
More info:
more than one?
show layout example
are they text or formulas
etc.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: pavan Kumar
Sent: Thursday, April 26, 2012 4:34 AM
To: excel-macros
Subject: $$Excel-Macros$$ Highlight the
Also, Happy birthday from Texas
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, April 26, 2012 7:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Happy Birth Day Ayush.
Happy Birthday Ayush. Have a great new
You finish
Option Explicit
Sub transposeqmSAS()
'fire from qmform sheet
Dim dlr As Long
With Sheets(raw)
dlr = .Cells(Rows.Count, b).End(xlUp).Row + 1
Range(C4:C40).Copy
Sheets(Raw).Cells(dlr, b).PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Use this macro in a macro enabled workbook
Sub insertrows()
Dim i As Long
On Error Resume Next
For i = Cells(Rows.Count, c).End(xlUp).Row To 2 Step -1
If Cells(i, c) Cells(i - 1, c) Then Rows(i).Insert
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From:
Nicely done...!!
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Your Help
Hi karthik
PFA
Regards,
Lalit Mohan
On Sun, Apr 29,
Really good
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ data needed in this format
Hi Sara
PFA
Regards,
Lalit Mohan
On Sun, Apr 29,
Can you just use datafilterautofilter on the data sheet.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Karan Singh
Sent: Monday, April 30, 2012 7:21 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help to make good format of report
Dear All,
If you don't want a macro and you don't want to open suggest a LOT of
linking formulas. You could then use editreplace to change the name of the
source workbook (if needed)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: anil kumar
=IF(SUMPRODUCT(--(LEFT(Sheet1!$A$1:$P$21,5)=Sheet2!A1)),Found,Not Found)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: prabhat.shrivasta...@gmail.com
Sent: Sunday, April 29, 2012 9:34 PM
To: excel-macros@googlegroups.com
Subject: RE:
Sub checkmatchwithblanks()
Dim c As Range
For Each c In Range(b4:b24).SpecialCells(xlCellTypeConstants)
If c c.Offset(-1) Then c.Offset(, 3) = 30
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shaik Waheed
Sent: Monday, April 30, 2012 3:31 AM
To:
And, if you really want only change from red to green, add And LCase(c) =
green
Sub checkmatchwithblanks()
Dim c As Range
For Each c In Range(b4:b24).SpecialCells(xlCellTypeConstants)
If c c.Offset(-1) And LCase(c) = green Then c.Offset(, 4) = 30
Next
End Sub
Don Guillett
Microsoft MVP Excel
DVD http://en.wikipedia.org/wiki/Optical_disc_drive
A optical drive is essentially what you put CD's DVD's and install discs into
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Monday, April 30, 2012 8:44 PM
To: excel-macros@googlegroups.com
IF(SUMPRODUCT((B8:AE81)*B8:AE8)1,down,up)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Filip Houdek
Sent: Monday, April 30, 2012 10:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Find column # of first value greater than
specified value?
No you would not like this
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Chandra Shekar
Sent: Tuesday, May 01, 2012 8:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Multi Combo Box
Hello,
I would like to have multi combo box on every row
Or, a double click macro
if not intersect((..
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Tuesday, May 01, 2012 8:39 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Multi Combo Box
HI Chandru,
File size will be very
101 - 200 of 1000 matches
Mail list logo