Post your macro code and/or attach your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: zp18
Sent: Tuesday, November 22, 2011 5:52 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Conditional Formatting using named ranges
Excel 2007-
I
Right click sheet tabview codeinsert thischange column 3 to suit
Now IF the length of the string is 4 and it’s a number, it will be
automatic.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column 3 Then Exit Sub
If IsNumeric(Target) And
I don't think your sample matches what you said.
Array formula that must be entered using ctrl+shift+enter
=MAX(IF(($A$2:$A$5000=A10)*($D$2:$D$5000=1),$C$2:$C$5000))
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: RockyFontane
Sent: Tuesday, November 22,
21, 2011 at 2:09 AM, dguillett1 dguille...@gmail.com wrote:
Did you eever get an answer to this.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Manhar Kisan
Sent: Thursday, November 17, 2011 3:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sales
3) Don't post questions regarding breaking or bypassing any security measure.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
Sent: Thursday, November 24, 2011 10:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Seeking MS
if you are saying that g3 should be between d3 and e3 then this formula does it
for the CLOSE.
=IF(AND(G3=D3,G3E3),Low True,False)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kenil Gala
Sent: Friday, November 25, 2011 7:32 AM
To: excel macros ; excel yahoo groups
Subject:
Reply to this and attach file,if allowed, or send directly to me.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: NewToThisGroup
Sent: Saturday, November 26, 2011 12:18 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ IRR Cash Flows
Hello.
Column
=IF(C4=,,VLOOKUP(C4,$F$9:$G$15,2))
and copy down
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Sunday, November 27, 2011 1:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Other possibility
Dear Experts,
I have already write formula to get
Buckets
0 upto 50 M
51,000,000 51- to 100M
101,000,000 101 to 300M
301,000,000 301 to 500M
501,000,000 501M to 1 Bn
1,000,000,001 1 Bn +
add to your table as above and use this
=IF(C4=,,VLOOKUP(C4,$F$9:$G$15,2))
Don
Sub listwbnames()
With ActiveWorkbook
dim I as long
For i = 1 To .Names.Count
Cells(i, 1) = .Names(i).Name
Next i
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: bpascal123
Sent: Sunday, November 27, 2011 2:45 PM
To: MS EXCEL AND VBA
Even when presented with a problem for xl2007+, I usually write in 2003 .xls
and tell user to convert to .xlsm if desired. Prevents these problems. However,
sometimes there ARE things later versions can do or do better.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai
How about AFTER example using your data.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: shashank bhosle
Sent: Monday, November 28, 2011 1:14 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Criterria based copy DATA FROM THIS Summary AND PASTE
IT ON SHEET 2 TRANSPOSED
One way would be to select all sheets and put 1 in cella1 (or any cell
desired). Assuming sheet1 names shf and last sheet named shl
=sum(shfhl!A1)There are other ways
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Monday, November 28, 2011 3:36 PM
To:
Save the file to your desktop and right mouse click and select open with.
This should give you an option to open it with xlm converter. Try that first to
see if it converts the file. If this opens the file and converts it for you,
you will need to select the open with and select choose program.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Tuesday, November 29, 2011 3:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Returning a Value Based on a String Containing
Specific Characters
Excel Teachers,
I need to look at a cell and if it
You need to explain a bit more with examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: manhar prajapati
Sent: Tuesday, November 29, 2011 4:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help for stock file
Dear All HI
Please Find attach file for my quary.
Regards
Chethan Kumar BN
On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:
Here is a file that should help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: B.N.Chethan Kumar
Sent: Tuesday, November 29, 2011 4:04 PM
To: excel-macros@googlegroups.com
=LARGE($I$3:$I$23,ROW(A1))
copy down to give 5,4,4,3,3,2
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aindril De
Sent: Thursday, December 01, 2011 4:21 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to Extract the Second Biggest number from a list
of numbers
or this copied down
=SMALL(I:I,FREQUENCY(I:I,MAX(I:I)-(ROW(A1)-1)))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Haseeb Avarakkan
Sent: Thursday, December 01, 2011 1:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from
(Even more values than were in the original list)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Thursday, December 01, 2011 11:45 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to Extract the Second
Option Explicit
Sub ShowNegativesInColumnsI_L_SAS()
Dim i As Long
Application.ScreenUpdating = False
On Error Resume Next
For i = Cells(Rows.Count, b).End(xlUp).Row - 1 To 1 Step -1
If Cells(i, I) = 0 Or Cells(i, L) = 0 Then _
Rows(i).Hidden = True
Next
Application.ScreenUpdating = True
End
sample formula
=AND($D$43,$D$215)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Friday, December 02, 2011 2:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Condition Formatting
Dear Group,
I am using the condition (if Khi3days Upcountry15
Try removing blank cells in your defined name list or ' ' '
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: B Sharma
Sent: Friday, December 02, 2011 10:52 PM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Data
This assumes you have a list of files entered in cells and have used ctrl to
select the file(s) to close
You can use another macro to make the list if not there
Sub CloseSelectedWorkbooks()
On Error Resume Next
Application.DisplayAlerts = False
For Each wb In Selection
workbookname = wb.Value
http://tinyurl.com/72uneme
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Saturday, December 03, 2011 8:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Expert Advice Needed - in VBA.
Hay Guy,,
Can any one please Help me in this, this is
to update so i want the process bar which can show me the
status like in % or how many columns are remaining.
Hope i understood u properly
Thanks in advance sorry once again for late replyawaiting for your reply
with updated code..
On Mon, Nov 21, 2011 at 10:41 PM, dguillett1 dguille
From the ss it appears that you did not bring up the next line. Bring it up or
insert a continuation character _
Don Guillett
SalesAid Software
dguille...@gmail.com
From: rekha siri
Sent: Sunday, December 04, 2011 9:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re:
Haven't followed this but have you tried
edit/replace
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: debasish
Sent: Sunday, December 04, 2011 11:38 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ update link automatically in excel sheet
When communicating with me, please REPLY to message with previous msg
The macro is using a vlookup to lookup the value above in the 1st column of the
table and returning the 3rd column. You do not have a table value for 14000 in
the first column. I added here ??? You did not comment on my
This macro will copy the template and name each sheet with the start of the
week (short names better)
If you want the first MONDAY then change ,7 to ,8
Option Explicit
Sub addsheets()
Dim i As Long
For i = Day(DateSerial(Year(Date), 1, 7) - _
WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7
A macro to populate column B
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: hemant
Sent: Wednesday, December 07, 2011 2:30 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula Help
Hi all
I need help on the following in EXCEL 2007:
Compare
$$ Formula or macro to add names to sheets in one
workbook
I copied and pasted your code from below in a blank spreadsheet and when I run
it I received the following error: Script out of range.
Please advise.
Thanks!
On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 dguille...@gmail.com wrote
workbook
I believe then I'll need to make a template sheet :-)... okay thanks
for clarifying it! :-)
Appreciated!!
On 12/7/11, dguillett1 dguille...@gmail.com wrote:
The macro assumes that you do, indeed, have a sheet named Template that
you
want to copy and name jan 03, jan 10, etc.
Don Guillett
to the week dates,
starting like this
Jan 01-Jan 07, 2012 all the way down to Dec 30-Jan 05, 2013
Can you fix the code for me...
Thanks again!
On 12/7/11, dguillett1 dguille...@gmail.com wrote:
Attach your final result for comments
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original
reply to me with your file.
dguillett1 @gmail.com
Don Guillett
SalesAid Software
dguille...@gmail.com
From: ajinkya natu
Sent: Wednesday, December 07, 2011 8:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a
cell
Hello All
really appreciate your
assistance with this and you were also very fast at responding.
You are awesome :-)
Sunnie
On Wed, Dec 7, 2011 at 4:51 PM, dguillett1 dguille...@gmail.com wrote:
Not really. It was using the first Sunday of the current year and adding a 7
days so you would have 52 sheets
Easy enough but let's try to fully automate. Why skip a21??
Are you saying you want to copy/paste values to B if there is nothing in B
or to C if there are values in B, to D if values in C???
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: trawets
Sent:
1.. Sub Macro1()
Dim sFile As String
sFile = S:\Office Documents\Purchase Orders\
ActiveSheet.Range(F5).Text .pdf
If Len(Dir(sFile)) Then
If MsgBox(Purchase order number already used, Verify and correct
purchase order number, vbOKOnly) = vbOK Then Exit Sub
It would be helpful to post your code and/or file (if allowed)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: gargee singh
Sent: Thursday, December 08, 2011 10:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ $$ excel - macro $$
Hi experts
I urgently need help
Try this
Sub UpdateMasterFileSAS()
Set ss = Sheets(source sheet)
Set ds = Sheets(destination sheet)
dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row
sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1)
ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1)
End Sub
Don Guillett
SalesAid
Minor correction to mine
Sub UpdateMasterFileSAS()
Set ss = Sheets(source sheet)
Set ds = Sheets(destination sheet)
slr = ss.Cells(Rows.Count, 1).End(xlUp).Row
dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row
sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1)
ss.Cells(sr + 1, 1).Resize(slr,
a set budget for each
activity
and then alert by some condition formatting in case of overspend
Hope I've explained enough (file available if required)
Thanks
On Dec 8, 1:17 pm, dguillett1 dguille...@gmail.com wrote:
Easy enough but let's try to fully automate. Why skip a21??
Are you saying you
http://www.youtube.com/watch?v=9bat12gH3Qs
http://www.cometdocs.com/
third party converters google xls to xlm
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Iqbal Merchant
Sent: Friday, December 09, 2011 1:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert
You need to give examples
col b. could/should be from data validation list
col a. incremented automatically when you enter col B. Example of next number
col c. same as col B using DV
col I. “agreement sheet” ?
col J. populated on what__occurring.
Don Guillett
SalesAid Software
Just select the columns ( D E ) desired and use
editreplace ~* with (leave BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: tan dennis
Sent: Friday, December 09, 2011 5:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ To remove the character *
=IF(COUNTIF(A3:D3,5)1,good,bad)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 4:59 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting formula
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and)
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 8:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting formula
thankq very much
On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 dguille
You need to tell us what you want and why
This cell _on this sheet___in this file_
needs to come from
This cell _on this sheet___in this file_
and WHY
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Chandra Singh Bora
Sent: Friday, December 09, 2011
out how it works
beats me though,
I really aprieciate your efforts
Regards
Stewart
On 10 December 2011 15:54, dguillett1 dguille...@gmail.com wrote:
I have created a macro to do as desired. See attached
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message
Google is your friend. I typed excel:attendance tracker and got this url
http://tinyurl.com/79rzajm
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Sunday, December 11, 2011 9:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Attendance
This ONE line formula should go in table!b2 and be copied across. Hope this
gets you started.
=SUMPRODUCT((Calculation!$A$2:$A$6000=$A$1)*(Calculation!$C$2:$C$6000={incident,Service
Request})*(Calculation!$D$2:$D$6000=B$1))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Atul
query is that I need SOW approved date is date of issuing
the No. but when I use (TODAY) function it change on daily basis
Suppose I put this formula =IF(I17=,,TODAY()) then it will change
on daily basis.
Regards,
Ankit
On 12/10/11, dguillett1 dguille...@gmail.com wrote:
I have developed columns
2) Don't post a question in the thread of another member.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Tuesday, December 13, 2011 1:45 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string
hai all :i form
http://tinyurl.com/7yt37xy
https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US
You don’t say what you are to do with the SECOND drop down. Seems that it
should not be a drop down.
Anyway, a macro can:
1. make a list from your existing full list
2. As each name is selected, remove it from the created list. Or, if no longer
needed, the original list.
etc
Don Guillett
I do not understand what you want. Send a file with a full explanation and
examples.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aju Chacko
Sent: Wednesday, December 14, 2011 12:24 AM
To: excel macro forum
Subject: $$Excel-Macros$$ How to create a double click using VBA CODE
Attach your file as a reply to this message with a complete explanation or
send to me
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Ronak Hindocha
Sent: Wednesday, December 14, 2011 3:17 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Macro
right click sheet tabview codecopy/paste thissave file as .xls or .xlsm to
allow macros.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column 2 Then Exit Sub
Target.Offset(, 3).Select
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hemal
One way
Option Explicit
Sub foreachcoSAS()
Dim lr As Long
Dim i As Long
Dim ph As Long
Dim em As Long
Dim c As Range
Dim ms As String
i = 1
lr = Cells(Rows.Count, g).End(xlUp).Row
For Each c In Range(g1:g lr)
If c.Font.Bold Then
'MsgBox c
ph = Columns(g).Find(What:=ph, After:=Cells(i, G),
it with code
Thanks
Charlie
On Fri, Dec 16, 2011 at 1:56 PM, dguillett1 dguille...@gmail.com wrote:
One way
Option Explicit
Sub foreachcoSAS()
Dim lr As Long
Dim i As Long
Dim ph As Long
Dim em As Long
Dim c As Range
Dim ms As String
i = 1
lr = Cells(Rows.Count, g).End
email in G ?
See attached.
Thanks and regards
Charlie
On Sat, Dec 17, 2011 at 3:29 AM, dguillett1 dguille...@gmail.com wrote:
should do it
Option Explicit
Sub foreachcoSAS()
Dim lr As Long
Dim dlr As Long
Dim i As Long
Dim ph As Long
Dim em As Long
Dim c As Range
i = 1
attach or send me your file with a better explanation and examples.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shrinivas Shevde
Sent: Friday, December 16, 2011 10:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Help On Print
Dear Rohan
Thanks for the
Please explain your need
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Atul vishwakarma
Sent: Thursday, December 15, 2011 8:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update charts automatically
Hi Friends,
I need a macro to update charts
=IF(A3=,,IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),not recieved))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Vijayendra Rao
Sent: Friday, December 16, 2011 6:44 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help on isblank iferror
Hi All,
I want to put isblank and
-Macros$$ VBA select data in BOLD
On Sun, Dec 18, 2011 at 9:18 AM, dguillett1 dguille...@gmail.com wrote:
Attached wbook
Hi Don
This happens when I run the code-
Highlights SearchFormat:=
with msg: Compile error
Named argument not found
r1 = Range(Cells(1, g), Cells(lr, g)).Find(What
The question is what do you intend to do with it afterwards.
Perhaps a looping macro would serve your needs???
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Sunday, December 18, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ pls fill up
Send file
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Ometoon
Sent: Monday, December 19, 2011 8:40 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Lookup and summarize multiple values from another
worksheet
Hello,
What I want the
2) Don't post a question in the thread of another member.
A complete explanation with examples?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mishra, Kailash (GE Capital, Non-GE)
Sent: Monday, December 19, 2011 6:08 AM
To: excel-macros ; rajanverma1...@gmail.com
Subject: RE:
was very good and very quick.
Regards,
Vijayendra
2011/12/18 dguillett1 dguille...@gmail.com
=IF(A3=,,IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),not recieved))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Vijayendra Rao
Sent: Friday, December 16, 2011 6:44 AM
To: excel-macros
Assumes xl2010. =WORKDAY.INTL(B6,A6,6,D1:D2) d1etc for holidays
WORKDAY.INTL function
Show AllHide AllReturns the serial number of the date before or after a
specified number of workdays with custom weekend parameters. Weekend parameters
indicate which and how many days are weekend days.
What you want can be done but why not just goto the db sheet and filter???
Don Guillett
SalesAid Software
dguille...@gmail.com
From: SAJID MEMON
Sent: Tuesday, December 20, 2011 10:15 AM
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ Searching Query
Dear Expert
I want to make some
Send your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: 0 1
Sent: Tuesday, December 20, 2011 4:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Copy multiples tables from one worksheet to
separate worksheets
I should add that these tables are not
-Macros$$ How to create Form for storing data
Thanks Sir, for your prompt reply.
Can you please tell me how you have created the button/shape ?
I will be back to you after completing whole macro.
Regards
On Wed, Dec 21, 2011 at 7:29 PM, dguillett1 dguille...@gmail.com wrote:
1. You would want
homework??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hanumant shinde
Sent: Wednesday, December 21, 2011 3:08 PM
To: Excel Group
Subject: $$Excel-Macros$$ Return More than 1 value from Function
Hi,
How can we return more than 1 value from 1 function.
1. using array
2. using
You shouldn't need code here. Look in the HELP index for INDIRECT and apply
to your vlookup formula
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Selva
Sent: Wednesday, December 21, 2011 6:02 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$
File attached
Don Guillett
SalesAid Software
dguille...@gmail.com
From: SAJID MEMON
Sent: Thursday, December 22, 2011 1:10 AM
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ Searching DOUBT
Dear
but should be upgrading to
2003 in a few days.
Regards
Charlie Harris
On Sat, Dec 24, 2011 at 2:40 AM, dguillett1 dguille...@gmail.com wrote:
Charlie, what is your excel version. I have one for xl2003 not updated for
xl2007, that searches all of my c drive and makes a list of 4000+ files
Send file with complete explanation and examples
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: SwadheenJain
Sent: Saturday, December 24, 2011 2:24 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Excel Macro How to retrive selected values
based
This will extract any Letter and number such as B2004 from your string. Place
in a REGULAR module and use
=xtract(a1)
and copy down to get A89, etc
Function Xtract(ByVal ref As String) As String
Dim rx As Object, arr As Object, i As Integer
Set rx = CreateObject(VBscript.Regexp)
With rx
To find the last row in a range, array enter this formula (ctrl +shift+enter)
to get 21
=MAX(ROW(1:50)*(A1:H50))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Monday, December 26, 2011 6:35 AM
To: excel-macros@googlegroups.com
Subject: RE:
Recorded a macro and then cleaned it up. Use the second macro. Sub
MakeUniqueNumbers(). Save file as .xlsM
Sub Macro2() 'recorded
'
' Macro2 Macro
'
'
Range(D1).Select
Range(C1:D26).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
H1), Unique:=True
Have you looked at Office templates?
http://office.microsoft.com/en-us/templates/templates-presentations-spreadsheets-documents-calendars-more-FX101741961.aspx
Don Guillett
SalesAid Software
dguille...@gmail.com
From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
Sent: Tuesday, December 27,
You are including more than the current month.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Wednesday, December 28, 2011 7:39 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ cashflow statement
See the attached Sheet, Press Create Cash Flow
I’m afraid I' have forgotten which file. Send to me along with a complete
explanation of what you want.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: excel lerner
Sent: Wednesday, December 28, 2011 12:10 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
hi
Don
You do not need a formula. Just select the cells button(upper left) and then
EDITREPLACE
~*
WITH
NOTHING (LEAVE BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Imran khan
Sent: Wednesday, December 28, 2011 4:28 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Correct RED for line wrap
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Wednesday, December 28, 2011 12:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create Uni Code
thanks for your response Dguillett1 Rohan but when I run the macro its
You need to be MUCH more specific on what you want with cell references and
before/after examples.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ashjain2...@yahoo.co.in
Sent: Wednesday, December 28, 2011 3:54 AM
To: excel-macros@googlegroups.com
That’s good. I went back and tested mine. NOT good.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Thursday, December 29, 2011 8:06 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: To Extract a text with Conditions
Hi,
Try this UDF.
Function
Even simpler
Option Explicit
Sub GetFinalDestinationSAS()
Dim c As Range
Dim start As String
Dim final As String
Application.ScreenUpdating = False
For Each c In Range(a6:a Cells(Rows.Count, 1).End(xlUp).Row)
start = Left(c, 3)
If Not InStr(4, c, start) Then final = Right(c, 3)
If InStr(8, c,
One way. Save your file as .xls or .xlsM to allow macros.
Option Explicit
Sub GetFinalDestinationSAS()
Dim c As Range
Dim start As String
Dim final As String
Application.ScreenUpdating = False
For Each c In Range(a6:a Cells(Rows.Count, 1).End(xlUp).Row)
start = Left(c, 3)
If Not InStr(4, c,
I don’t understand your request. “it should highlight”
examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: lucky singh
Sent: Thursday, December 29, 2011 3:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hyperlink to Highlight weekly data
Dear Team,
Attached
Send a file with a complete explanation and examples
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: chhajersand...@gmail.com
Sent: Thursday, December 29, 2011 6:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Auto create of sheet with
Subject: RE: $$Excel-Macros$$ Require Help Urgent
We want to different between last and current month salaries.. And where is
different
Sent from my Nokia phone
-Original Message-
From: dguillett1
Sent: 28-12-2011 9:30:18 pm
Subject: Re: $$Excel-Macros$$ Require Help Urgent
You need
Wonderful solution Guillett, is it possible with formulas?
Regards,
Aamir Shahzad
On Thu, Dec 29, 2011 at 7:33 PM, dguillett1 dguille...@gmail.com wrote:
Even simpler
Option Explicit
Sub GetFinalDestinationSAS()
Dim c As Range
Dim start As String
Dim final As String
@googlegroups.com
Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions
Wonderful solution Guillett, is it possible with formulas?
Regards,
Aamir Shahzad
On Thu, Dec 29, 2011 at 7:33 PM, dguillett1 dguille...@gmail.com wrote:
Even simpler
Option Explicit
Sub
Yes,very nice
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Haseeb Avarakkan
Sent: Thursday, December 29, 2011 9:52 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions
Try this Array Formula,
Are you saying you want each of these to a sheet of it’s own in another
workbook. If so, a looping macro can be developed to do this.
CAR LOAN JUNE 2007 Total
CAR LOAN NOV 2011 Total
CAR LOAN OCT 2011 Total
HOME LOAN Total
HOME LOAN JAN 2006 Total
TL CAR
Sub changeShapecolor()
ActiveSheet.Shapes(Rectangle 2).Fill.ForeColor.SchemeColor = 12’blue
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: bhupendra singh raghav
Sent: Sunday, January 01, 2012 5:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fill Color in
Would this be easier
=A1 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) *
{3,1,3,1,3,1,3,1,3,1,3}), 10)
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Vishwamitra Mishra
Sent: Monday, January 02, 2012 2:03 AM
To: MS EXCEL AND VBA MACROS
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Alberto
Sent: Monday, January 02, 2012 8:32 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Query from URL
Hi,
I use VBA to retrieve wheather data.
This work:
With
601 - 700 of 1000 matches
Mail list logo