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
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
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
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
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
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
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
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
, 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
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
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...@
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
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
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
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
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
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,
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
: $$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
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
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:
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
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
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
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
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
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
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
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
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
=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
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
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
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, "
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
-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
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
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
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
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
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
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
,
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
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
-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
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
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
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
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
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
Try this
Sub MakeCenterHeaderSAS()
mc = 1
For Each objFilterPart In ActiveSheet.AutoFilter.Filters
If objFilterPart.On Then
ms = ms & " " & ActiveSheet.AutoFilter.Range.Columns(lngcount).Column
End If
mc = mc + 1
Next
With ActiveSheet.Range("$A$2:$A" & Range("A" & Rows.Count).End(xlUp).Row)
Try this without selections
Option Explicit
Sub consolidateSAS()
Dim ns As Long
Dim slr As Long
Dim dlr As Long
Dim i As Long
Application.ScreenUpdating = False
ns = Sheets.Count
Sheets.Add After:=Sheets(ns)
With ActiveSheet
.Name = "Consolidated Sheet"
.Range("A1") = "Name"
.Range("B1") = "Resu
Or, if you just want to remove, try
Sub unmergecells()
Cells.MergeCells = False
End Sub
From: NOORAIN ANSARI
Sent: Thursday, September 15, 2011 6:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Finding Merged cells in excel
Dear Amit,
Please try it.
Sub f
’makes a list, in column 1 of all sheets>names the range>sets up data validation
option explicit
Sub makesheetlistSAS()
Dim i As Long
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
Cells(1).Resize(Cells(Rows.Count, 1).End(xlUp).Row) _
.Name = "SheetList"
Range("b1").Validation.Ad
You may?? not find too many anxious to help telemarketers
-Original Message-
From: Mayank
Sent: Sunday, September 18, 2011 12:03 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Anyone like to take a project and challenge in
excel
Need urgent help in excel project
Process
A very easy way is to put your formula in cell c2 and then DOUBLE click the
fill handle (lower right corner)
From: Prabhu
Sent: Tuesday, September 20, 2011 12:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ *Macro Code Request*
Hi Friends,
Column A & B contains some values
If you want a macro just use this
Sub FillDownSAS()
With Range("c2")
.Formula = "=a2+b2"
.AutoFill Destination:=Range("C2:c" & Cells(Rows.Count, "a").End(xlUp).Row)
End With
End Sub
if you already have the formula in c2
Sub FillDownSAS()
range(“c2”).AutoFill Destination:=Range("C2:
Can you provide an AFTER example
-Original Message-
From: Rohan Young
Sent: Thursday, September 22, 2011 2:30 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
-- Forwarded message --
From: Rohan Young
Date: Tue,
I would copy the sheet to the desktop and save as and close
Sub CopyDetailsToDesktopSAS()
mydesktop = Environ("userprofile") & _
Application.PathSeparator & "Desktop" & _
Application.PathSeparator
mypath = ActiveWorkbook.Path
With Sheets("Details")
.Copy
newname = .Name & " - " & Format(Date,
How about a nice macro to populate col K and color the month within the row.
Option Explicit
Sub crossmonthSAS()
Dim i As Long
Dim j As Double
Dim ms As Long
For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
ms = 0
For j = 2 To 8
ms = ms + Cells(i, j)
If ms < 100 Then
Cells(i, "k") = "Not Qualified
Try in a macro enabled workbook (.xls or .xlsm)
Sub CustomSortSAS() 'converts to values
Rows(3).Clear
x = Application.Match(Application.Min(Rows(2)), Rows(2))
y = Application.Match(Application.Max(Rows(2)), Rows(2))
Cells(3, y - x + 2).Resize(, x - 1).Value = _
Cells(2, 1).Resize(, x - 1).Value
To me, all non customer requests are treated the same and I even sometimes
ignore those who say it is “URGENT”
From: Brajesh Kumar Porwal
Sent: Friday, September 23, 2011 5:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent--Fill in 1 column
Hi Expert,
Find attached
Assuming data in columns b:d and requests in cols f&g, This is an ARRAY
formula that must be entered using ctrl+shift+enter
=DAY(G2) & "
("&TEXT(MIN(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")& " | "
&TEXT(MAX(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss
If you are actually looking the highest value within the time frame, use
this array formula that must be entered using ctrl+shift+enter
=MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Ex
do it for
me pleas.
Regards
Ahmed Bawazir
On Sun, Sep 25, 2011 at 5:12 PM, dguillett1 wrote:
If you are actually looking the highest value within the time frame,
use this array formula that must be entered using ctrl+shift+enter
=MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000h
I sent a solution to what I thought was your request. Now, you have an
entirely different question. Please give examples and clear logic on how to get
the result.
From: vickey
Sent: Sunday, September 25, 2011 9:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup for
:36 PM, dguillett1 wrote:
I sent a solution to what I thought was your request. Now, you have an
entirely different question. Please give examples and clear logic on how to get
the result.
From: vickey
Sent: Sunday, September 25, 2011 9:40 AM
To: excel-macros@googlegroups.com
Another way without the need for the start/stop column. ARRAY formula entered
with ctrl+shift+enter
=MIN(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000))
=Max(IF(($A$2:$A$5000=$H$11)*($B$2:$B$5000=H$13),$C$2:$C$5000))
From: Deep
t rngCell
End Sub
OR, you could use a formula to reverse it too
Use =INDEX($A$2:$M$2,COUNTA(A2:$M$2)) and drag to the right
Regards
Sam Mathai Chacko (GL)
On Sep 23, 8:54 pm, "dguillett1" wrote:
> Try in a macro enabled workbook (.xls or .xlsm)
>
Simply deleting the un-needed rows and columns reduced the file by one half.
Combining like sheets with an extra column and using autofilter would help. Etc.
From: syed aliya raza hashim
Sent: Sunday, September 25, 2011 1:32 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Hel
:04 PM, dguillett1 wrote:
Can you provide an AFTER example
-Original Message- From: Rohan Young
Sent: Thursday, September 22, 2011 2:30 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
-- Forwarded message --
From
See attached to do as desired
From: vickey
Sent: Monday, September 26, 2011 10:14 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with
two Criteria
Thanks,
It worked, but there is one argument, if there are more then three entrie
Attach your file
-Original Message-
From: JMac
Sent: Monday, September 26, 2011 7:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that
I didn’t see a “like the above” and I answer many emails so please refresh my
memory and attach the file.
From: Mr excel
Sent: Monday, September 26, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Mr.guillet..thanks for that great macro.
you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "$$Excel-Macros$$ Create
report & print based on cell va
This macro will do it
option explicit
Sub TransposeEmSAS()
Dim r As Long
Application.ScreenUpdating = False
Columns("J").Resize(, 2).Insert
r = 2
doit:
If Cells(r + 1, 1) = "" Then GoTo deletecolumns
Rows(r + 2).Resize(4).Insert
'copy colors
Range("L2:P2").Copy
Cells(r + 1, "j").PasteSpecial Paste
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
-Original Message-
From: Ken
Sent: Wednesday, September 28, 2011 1:03 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Computer moving average hrs of play per day
I have a spreadsheet
This will remove the duplicates. If you have xl2007 you could use the remove
duplicates
Sub advancedfilterunique()
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1:A49")
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("b1"), Unique:=True
.Delete Shift:=xlUp
End With
Columns(1).De
Save file as an xlsM file and enable macros and use
Option Explicit
Sub nodupesperitemSAS()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i, "d") = Cells(i - 1, "d") Then Rows(i - 1).Delete
Next i
End Sub
From: Neeraj Chauhan
Sent: Thursday, September 29, 2011 2
Haven’t followed this so
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
From: Mr excel
Sent: Thursday, September 29, 2011 4:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Macro 1:
Option E
=(D2-C2)*24
From: John A. Smith
Sent: Thursday, September 29, 2011 2:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time
Format
Excel Experts,
I need to calculate the time differences between 11:30:00 AM and 11:37:00 A
If ??? I understand, simply CUSTOM format the cell as "dd-mm-
From: Sanjib Chatterjee
Sent: Friday, September 30, 2011 12:33 AM
To: excel-macros
Subject: $$Excel-Macros$$ date format in Excel
Dear
I like to put the date format in Excel as "dd/mm/", and like to get the
output as "dd-mm
I don't see all of my original code here but
also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
Excel is looking in col J for the bottom most cell, ie 22
Range("J2:J" & r) in above code.
Excel is using range("j2:j22")
makes little difference what r is called. could be lastrow or x
Just modify my code to this. You could also sort by site ascending with
descending date>advance filter to unique>copy but this is easier.
Option Explicit
Sub CopyLastDatetoothersheeetSAS()
'run from source sheet
Dim i As Long
Dim dlr As Long
On Error Resume Next
For i = 3 To Cells(Rows.Count, 1).E
I can do it from Texas at $75 hourly
-Original Message-
From: Jattin Agarwal
Sent: Friday, September 30, 2011 3:35 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel expert required .
Dear Excel experts
I would request that if any VBA expert can help in automati
=SUBSTITUTE(F9," ","")
From: big smile
Sent: Friday, September 30, 2011 6:54 AM
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ TRIM FUNCTION
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as
This is easy enough to do with a macro. However, please consider leaving all
in one file and simply use
data>filter>autofilter.
-Original Message-
From: Chidurala, Shrinivas
Sent: Saturday, October 01, 2011 6:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Splitting o
As an M$ Excel MVP, I also welcome him to the group
From: NOORAIN ANSARI
Sent: Sunday, October 02, 2011 10:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsof
Suggest you try this instead as the formula for currsheet. It will work for
all. Notice there is NO sheet name in the formula, just the !
=OFFSET(!$A$1,1,0,COUNT(!$A:$A),5)
From: Haseeb Avarakkan
Sent: Sunday, October 02, 2011 6:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I suggest, instead that you use ONLY one sheet and filter as desired. See
attached and filter by region and then by date. to clear filters use
data>filter>show all
From: Mr excel
Sent: Monday, October 03, 2011 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Update sheets on
I don’t understand what you need There is a master sheet and no
sample sheet for your desires. My macro and the other do essentially the same
thing.
From: Mr excel
Sent: Monday, October 03, 2011 10:54 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update sheet
OK. I now see what you wanted which means a slight modification to my macro.
However, I also posted a STRONG suggestion to just use filters.
From: Mr excel
Sent: Monday, October 03, 2011 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Update sheets on Enter
Hi group,
I, or some of the others can amend my code to do as desired. However, again, I
suggest you try this where you simply use filters on ONE sheet.
From: Mr excel
Sent: Monday, October 03, 2011 11:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update sheets on Enter
huhh.
It would be helpful if you would post examples of what you want
From: shaneallen
Sent: Tuesday, October 04, 2011 7:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT
solution needed!
Hi
Good Day
I trust someone will be able to
What is the reason that you do not like my idea of filtering?
From: Mr excel
Sent: Tuesday, October 04, 2011 8:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update sheets on Enter
any help from anybody please?
On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote
Not clear as to what you want. Pls provide sample sheet and urls and what you
need.
From: syed aliya raza hashim
Sent: Monday, October 03, 2011 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help
Can excel file such as reports be access from web or can be acccess as
Can you attach your file?
From: shaneallen
Sent: Tuesday, October 04, 2011 1:11 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT
solution needed!
https://docs.google.com/viewer?a=v&pid=forums&srcid=MTI3OTgyMTkwNDM5NTM5NjQ5MzEBM
Can you simply use
data>validation
as shown in the attached
From: Ahmed Emam
Sent: Tuesday, October 04, 2011 1:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I need help
Here it's attached
On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote:
Dear Ahmed,
if poss
You should never “hijack” a thread to ask a question. Instead, start your own
with a new subject line. However, can you not use data>autofilter>custom>ends
with DR?
From: P.VIJAYKUMAR
Sent: Tuesday, October 04, 2011 8:22 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Thanks
601 - 700 of 1086 matches
Mail list logo