Good work
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, May 02, 2012 11:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Congrats Cheetah
Regards,
Sam
On Wed,
What do you want where and why. Explanations are always nice.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nemi Gandhi
Sent: Thursday, May 03, 2012 5:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rising lagna-astrology
Attached herewith
I thought I answered this once already
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
This is a a better approach than looping
Filtercopy visible to new workbooksave as close
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Thursday, May 03, 2012 8:27 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Split file
Sent: Friday, May 04, 2012 3:07 AM
To: NOORAIN ANSARI ; rajanverma1987 ; dguillett1 ; excel-macros
Subject: $$Excel-Macros$$ help Pls for creating graph,
Dear experts.
Please help for creating graphs of multipls person. please help..
-- Forwarded message --
From: Harkesh Kumar
Provide a file
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: joseph.cam...@gmail.com
Sent: Saturday, May 05, 2012 2:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Charts
Sent on my BlackBerryŽ from Vodafone
Tested in the source sheet. This is an array formula entered using CSE
=INDEX($C$1:$C$140,MATCH(MIN(ABS($C$1:$C$140-E1)),ABS($C$1:$C$140-E1),0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Monday, May 07, 2012 5:54 AM
To:
Your sample only shows one row per number. You say copy to next file???. Pls
provide larger representative sample and a better explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Prajakt Pande
Sent: Monday, May 07, 2012 7:32 AM
To:
herewith what you requested.
i apologies for inconvenience, attached sheet for your reference.
Thanks Regards,
Prajakt Pande
+971551388482
On Mon, May 7, 2012 at 5:01 PM, dguillett1 dguille...@gmail.com wrote:
Your sample only shows one row per number. You say copy to next file???. Pls
Regards,
Prajakt Pande
+971551388482
On Mon, May 7, 2012 at 5:47 PM, dguillett1 dguille...@gmail.com wrote:
I do NOT understand your explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Prajakt Pande
Sent: Monday, May 07, 2012 8:20 AM
Right click sheet tabview codeinsert thismodify range to suit
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range(a1:b21)) Is Nothing Then Exit Sub
If VarType(Target) = 8 And IsNumeric(Left(Target, 1)) Then
With Target.Font
.FontStyle = Bold
.Strikethrough = True
http://www.xldynamic.com/source/xld.ColourCounter.html
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ChilExcel
Sent: Monday, May 07, 2012 6:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Count sum color cell,
Are you talking about fitting when viewing or printing.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Tuesday, May 08, 2012 11:32 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto)
WHICH???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Wednesday, May 09, 2012 8:52 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto)
Ya, u r right.
Regards,
Muneer,
CC…..
I don’t recall why?? I gave that answer. Can you give more detail with examples
and the logic of what you want.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Filip Houdek
Sent: Wednesday, May 09, 2012 5:05 PM
To: excel-macros@googlegroups.com
Subject: Re:
copy to I3 and enter using CSEcopy down.
=INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-H3)),ABS(Sheet1!$C$2:$C$140-H3),0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Wednesday, May 09, 2012 10:01 PM
To:
OR, use this withOUT the helper column. Again CSE
=INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-LEFT(C3,3))),ABS(Sheet1!$C$2:$C$140-LEFT(C3,3)),0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Wednesday, May 09, 2012 10:01 PM
To:
Won’t a simple vlookup using the false parameter work..??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Smitha S R
Sent: Wednesday, May 09, 2012 8:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Office stock
Hi
PFA the stock statement where I
Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, May 12, 2012 12:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Name Manager
Hi,
I want to know about Name Manager.. .. what is the use of Name
This is very possible with an indirect formula or defined names or with a
macro. Provide a file and your desires.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Friday, May 11, 2012 4:59 AM
To: excel-macros@googlegroups.com
Subject:
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
pick the
@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille
@googlegroups.com
Subject: Re: $$Excel-Macros$$ amend in macro
error reflecting, see the attached snapshot.
On Sun, May 13, 2012 at 12:13 AM, dguillett1 dguille...@gmail.com wrote:
For i = 1 To inputbox(“how many”)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
Why is your request more urgent than other requests
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Dhartikumar Sahu
Sent: Monday, May 14, 2012 2:28 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgently help required how to get access field
You may send to my personal email with an example. If you need to email or
print you shouldn’t need to create at file for each. Simply create a report for
each or email each. Details of your NEED for a separate file..
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
resolved with the suggestion of
=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST)
On Sat, May 12, 2012 at 6:48 PM, dguillett1 dguille...@gmail.com wrote:
This is very possible with an indirect formula or defined names or with a
macro
Provide a file with a complete explanation.
I am a retired regional manager for ING and held a series 7 brokers license but
have never heard of “nifty” stocks.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: coolguy
Sent: Sunday, May 13, 2012 11:35 PM
To:
Provide a file with an explanation and example. One or many??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: sreenivas kammari
Sent: Monday, May 14, 2012 3:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Delete Zero subtotal blocks
Hi,
Is
I suggest you look in the vba help index for FIND and FINDNEXT. Find the value
and then use offset to get data.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Monday, May 14, 2012 5:23 AM
To: excel-macros@googlegroups.com
Subject:
Give a couple of examples of your vlookup formula(s)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Amol Jadhav
Sent: Monday, May 14, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help-- Related to UDF
Hi Experts,
I need your
Put this in the THISWORKBOOK module and delete your buttons. Now each sheet
will print as desired.
If you don’t want ALL sheets in the file then you can restrict by UN commenting
lines
Private Sub Workbook_BeforePrint(Cancel As Boolean)
‘if activesheet.name “dontdothisone” then
Send me your file and tell me your excel version. I’ll look a bit later.
When you say give the user an option to print. What do you mean. Be VERY
specific.
What I did will should do it for each sheet in the file when it is printed.
Don Guillett
Microsoft MVP Excel
SalesAid Software
Based on the file you sent me with ONE sheet with graphs the easiest way would
be to set up an additional printer with ONLY grayscale and call it bw or
whatever and then print to that printer for bw and the other for color.
Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett
Microsoft MVP
Sub lookitup()
Dim c As Range
For Each c In Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row)
c.Offset(, 1) = Columns(F).Find(c, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext).Offset(, -1)
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
and white but manually you can print in
colour, I would like the macro to print in colour ...
Please see if you could help :)
Thanks again,
Sunny
On Mon, May 14, 2012 at 9:34 PM, dguillett1 dguille...@gmail.com wrote:
Based on the file you sent me with ONE sheet with graphs the easiest way
or, replace the values with formulas =d1”“e1. See attached
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Maries
Sent: Wednesday, May 16, 2012 6:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ 2 Values in the same cell
Sub SortByColBAndColC()
ActiveSheet.UsedRange.sort _
Key1:=Range(B2), Order1:=xlAscending, _
Key2:=Range(C2), Order2:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMpositiondatalabels
http://www.techrepublic.com/article/make-your-excel-charts-easier-to-read-with-custom-data-labels/6145493
http://www.ozgrid.com/forum/showthread.php?t=53916
Don Guillett
Microsoft
Pls put your name on the FROM request and provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ..
Sent: Wednesday, May 16, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste
sheet
Core. Please REPLY to messages instead of creating a new one.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: CoRe
Sent: Wednesday, May 16, 2012 4:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: help required for creating a formula
Hello,
Your example doesn’t help much. An ACTUAL sample is required. Dummy data is
fine but must make sense.
Why do you have 90 different sheets with data. Maybe one would do.
You do not need to have blank sheets until needed. Each can be created as
needed with a macro.
I don’t understand copying an
try
Sub setdvlist()
With Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row)
.Sort Key1:=Range(A2), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
.Name = dvlist
End With
With Range(b2).Validation
.Delete
.Add
Provide file
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: sreenivas kammari
Sent: Thursday, May 17, 2012 1:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Delete Zero subtotal blocks
Hi Don,
Say for an example:
I have data from A to
Sub makevalues()
ActiveSheet.UsedRange.Value = _
ActiveSheet.UsedRange.Value
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Thursday, May 17, 2012 12:15 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Values 2 New
Dear
Put in J5 and drag across and down
=IF(E5yes,,$C5/SUMPRODUCT(($E5:$H5=yes)*$E$3:$H$3)*E$3)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sandeep Chhajer
Sent: Friday, May 18, 2012 5:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Apportioned of
Look in the help index for TRANSPOSE.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anand Kumar
Sent: Saturday, May 19, 2012 1:50 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Converting from a single column to different rows
Hi,
I have a
=RANK(C2,$C$2:$C$55)+SUMPRODUCT(--($C$2:$C$55=C2),--($A$2:$A$55A2))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dhananjay Pinjan
Sent: Saturday, May 19, 2012 6:12 AM
To: excel-macros
Subject: $$Excel-Macros$$
Dear All,
I have
You need to make this clear
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Saturday, May 19, 2012 7:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the number missing in other cols
Dear friends,
I have a set
??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 19, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert amount to Million
Dear Group,
Following macro is working fine but when run this code,
OK by me... I’m in TEXAS
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Sunday, May 20, 2012 9:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Hello everyone,
There is sudden
I don’t understand your example but here is a formula you can adapt if you have
the analysis toolpak
=MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Dhanesh Verma
Sent: Monday, May 21, 2012 7:13 AM
Also, please do not use entire columns. Restrict to only area needed.
=VLOOKUP(E3,Sheet1!E1:G100,3,FALSE)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, May 23, 2012 7:06 AM
To: excel-macros@googlegroups.com
Subject: Re:
If you want help you need to:
Use a meaningful subject line in your post
give before/after examples and fully explain the logic.
or...
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: anil kumar
Sent: Thursday, May 24, 2012 5:48 AM
To:
Dunno. Didn’t' realize I replied. Been hectic today.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: bpascal123
Sent: Thursday, May 24, 2012 7:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Macro on daily task
Don, What is this post
Must have replied to another post with a request for a file.
???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: bpascal123
Sent: Thursday, May 24, 2012 4:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Macro on daily
No can do in FORMULAS. Convert to value and then change format. Develop a
macro to do it for you.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: joseph.cam...@gmail.com
Sent: Friday, May 25, 2012 1:43 PM
To:
In the future PLEASE try to use a meaningful subject line (doubt is not
meaningful) and then explain your problem in the posting as well as in the
attached file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, May 26, 2012 5:44 AM
http://technet.microsoft.com/en-us/library/ee624351.aspx
I have xl97, 2003,2007,2010 all on the same computer. if you use Outlook, only
ONE version allowed.
Shouldn’t have a problem with 2007 and 2010. If you do, then develop in 2007.
Of course, 2003 could have macro problems trying to run
please advise, will it be best practise to install both office 2007 and 2010.
Thanks alot for your help.
On Sun, May 27, 2012 at 6:50 PM, dguillett1 dguille...@gmail.com wrote:
http://technet.microsoft.com/en-us/library/ee624351.aspx
I have xl97, 2003,2007,2010 all on the same computer. if you
use a define name for the dv list in the other sheet such as
dvlist
then in the dv list =dvlist
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: chhajersand...@gmail.com
Sent: Monday, May 28, 2012 10:41 AM
To:
homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Jean PIERRE
Sent: Monday, May 28, 2012 3:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA code to add many rows at the end of a named range
?
Which is the VBA code to add many rows at
Use this simpler function in a REGULAR module for only numbers. For only text
simply remove the NOT
It will work with all strings such as
12abc34de56fgh78ijk9
Function ONSAS(rng As Range)
Dim i As LONG
For i = 1 To Len(rng)
If Not Mid(rng, i, 1) Like [!0-9] Then
ONSAS = ONSAS
Only gets the numbers left of text
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Tuesday, May 29, 2012 8:19 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a
particular cell
Hi,
Just install in a directory OTHER than the previous verion. ie: MyExcel2010
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Pradhan
Sent: Tuesday, May 29, 2012 9:16 AM
To: Excel Macros
Subject: $$Excel-Macros$$ Multiple Versions of Excel
Hello
I
I would recommend that the defined name be flexible to include
additions/deletions.
=OFFSET(Data!$C$3,1,0,MATCH(zzz,Data!D:$C)-3,1)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Bé Trần Văn
Sent: Tuesday, May 29, 2012 2:50 PM
To: excel-macros@googlegroups.com
@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to pick values from particular table/list
See the attached sheet FY Ref
Regards,
Gawli Anil
On Wed, May 30, 2012 at 1:34 AM, dguillett1 dguille...@gmail.com wrote:
I would recommend that the defined name be flexible to include
additions/deletions
These messages are cluttering.
For the sake of us all can you strongly suggest that responses to offers be
make OFF LIST.
When I offer a file I will either attach to the group, put in files area (if
available) or say
“I will ONLY respond to OFF list requests for this file”
Don Guillett
Don’t use indirect. Simply use a formula referring to the closed workbook.
Then, when the name of the source file changes use edit replace old name with
new name. A macro using specialcells for formuias would be best.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
There may? be a better way to do this. Reply to ME at the address below with
your file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mark Kerin
Sent: Friday, June 01, 2012 1:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vba formula vs
And you could combine into ONE formula
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Sunday, June 03, 2012 6:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to find paritcular word from sentence
check the attachment
How about a nice macro? Change your formatting and use in macro enabled workbook
Sub filtercopy()
With Sheets(COURSES).UsedRange
.AutoFilter Field:=1 'criteria IF needed
.AutoFilter Field:=2
.AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1)
.Offset(1, 3).Resize(,
index/atch solution also
On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote:
How about a nice macro? Change your formatting and use in macro enabled
workbook
Sub filtercopy()
With Sheets(COURSES).UsedRange
.AutoFilter Field:=1 'criteria IF needed
.AutoFilter
This yields 27
=SUMPRODUCT((RIGHT(B3:B17,1)=e)*(C3:H170))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Sunday, June 03, 2012 1:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ counting E in the column
Dear All,
I need
Ditto from Texas
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Sunday, June 03, 2012 3:48 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulations again Cheeteh
May I ask why your request is more urgent and more important than the other
requests.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Nagendra Modupalli
Sent: Monday, June 04, 2012 11:30 PM
To: excel-macros@googlegroups.com
Subject:
This can probably be greatly simplified. Provide your excel version and the
file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: thatguy
Sent: Monday, June 04, 2012 9:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need VBA to select and
You can use the vba DIR to open each file in the current folder and then copy
the used range.offset(1) to the next available row in the consolidate file. If
necessary, you can specify the files within an array
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From:
Why not use a macro to gather all and then do a unique on the gathered list?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Wednesday, June 06, 2012 10:39 AM
To: excel-macros
Subject: $$Excel-Macros$$ Extract Names from different sheet into
I would have written it a bit more efficiently but what it is doing is copying
all of current region of each sheet to a new sheet.
What do you want to do???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Wednesday, June 06, 2012 5:49 PM
To:
I adhere to the KISS principle so here is a simple macro.
If you want the second row change to rows(2)
Option Explicit
Sub copytoprowofallsheets()
'fire from the First sheet(sheet to far left)
Dim i As Long
For i = 2 To Sheets.Count
Sheets(i).Rows(1).Copy Cells(Rows.Count, 1).End(xlUp)(2)
Next
I understood you wanted the first or second row only. If you want all but the
header row.
Option Explicit
Sub copytoprowofallsheets()
'fire from the First sheet(sheet to far left)
Dim i As Long
For i = 2 To Sheets.Count
Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp)(2)
Next i
For the entire used range simply remove the .offset(1)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Greg
Sent: Thursday, June 07, 2012 1:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ...
Hi Don,
Create combobox1 in sheet1 and then put this code in the SHEET module
Private Sub Worksheet_Activate()
Sheet1.ComboBox1.Clear
Dim sh As Worksheet
For Each sh In Worksheets
Sheet1.ComboBox1.AddItem (sh.Name)
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
Unlock all you want to allow
lock that one
protect sheet
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Friday, June 08, 2012 9:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Edit Cell
Dear
Its is possible to Lock
BBA University of Texas 1959, Graduate studies at UT law school and NYU. Ex US
Air Force Officer.
I am a retired Regional Manager for ING and held a stock brokers series 7
license and insurance license.
To keep myself busy, I am an independent Excel Developer for projects large and
small and
Try
Sub FormulaToEndOffset1SAS()
Dim lr As Long
With ActiveCell
lr = Cells(.Row, .Column).End(xlDown).Row
With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1))
.Formula = _
=IF(ISERR(DATE(LEFT(A .Row ,4),MID(A .Row ,5,2), _
RIGHT(A .Row ,2))),,DATE(LEFT(A .Row ,4), _
MID(A
Forgive me but as I recall you have been a part of this group for awhile. If
so, you should have learned enough to do this yourself.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Tuesday, June 12, 2012 6:45 AM
To: excel-macros@googlegroups.com
Rangefull column is converted to desired
format...
is there any way to limit the code upto selected range only
Regards:
CMA Ankur Pandey
On Tue, Jun 12, 2012 at 6:30 PM, dguillett1 dguille...@gmail.com wrote:
Try
Sub FormulaToEndOffset1SAS()
Dim lr As Long
With ActiveCell
when i go
trough the books. Like String, long etc.
Thanks Regards,
Deba Ranjan P
On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 dguille...@gmail.com wrote:
Forgive me but as I recall you have been a part of this group for awhile.
If so, you should
Provide a file with complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: alvin567
Sent: Wednesday, June 13, 2012 4:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ What tools are most suitable to populate existing
database with
Which months in the 200?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 7:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ No. of years and months
Hi Experts,
Based on a given number I need the result
A look in the help index for INT may be of use to you
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ahmed Honest
Sent: Wednesday, June 13, 2012 8:49 AM
To: excel-macros@googlegroups.com ; talk2mar...@gmail.com
Subject: Re: $$Excel-Macros$$ No. of years and
I would have done it differently but add an on error
And, do you really want to do this with each calculation??. I don’t think so...
'On Error Resume Next
For Each c In rng
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: cardak
Sent: Wednesday, June 13, 2012 2:20
Use this without having to use selections
Option Explicit
Sub CombineSheetsSAS()
Dim i As Long
Sheets.Add before:=Sheets(1)
ActiveSheet.Name = Combined
Sheets(2).Rows(1).Copy Range(a1)
For i = 2 To Sheets.Count
Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp)(2)
Next i
End Sub
Provide a file and a complete explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Saturday, June 16, 2012 2:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: change content of cell across multiple
worksheets
or
ActiveSheet.UsedRange.Columns.AutoFit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Saturday, June 16, 2012 6:09 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that
cell
be EntireColumns as I had posted
Regards,
Sam Mathai Chacko
On Sat, Jun 16, 2012 at 7:29 PM, dguillett1 dguille...@gmail.com wrote:
or
ActiveSheet.UsedRange.Columns.AutoFit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent
Try
Sub FooterSAS()
selectcase InputBox(Enter 1=Confidental, 2=For Internal Use Only 3=Other)
Case Is = 1: x = Confidental
Case Is = 2: x = For Internal Use Only
Case Is = 3: x = Restricted
Case Else
End Select
For Each wk In Application.Workbooks
For Each sh In wk.Worksheets
OOPS
Put a space between select and case
selectcase
select case
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: jonnie...@gmail.com
Sent: Monday, June 18, 2012 4:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
http://oreilly.com/pub/h/2607
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Monday, June 18, 2012 10:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required
Hi Rajan,
Thanks for your
201 - 300 of 1000 matches
Mail list logo