As is often the case you do not fully explain. Do you want a BLANK row below or
copy (and insert) the value and what to do with
Mah 5-10 L Aurangabad
Mah 1-5 L Kolhapur
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Monday, June
Application.Workbooks.Open (http://www.jabong.com;)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Wednesday, June 20, 2012 1:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Saving Photos from webpage
Hi All,
Is any
Create a “template” workbook for the child workbooks or do it from the master.
A more detailed explanation of your problem may help.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Richard
Sent: Sunday, June 24, 2012 6:46 PM
To: excel-macros@googlegroups.com
Put in a macro enabled workbook
Sub sumifNOTbold()
dim I as long
dim ii as long
For i = 3 To 7
ms = 0
For ii = 5 To 9
If Cells(ii, 2).Font.Bold =False Then ms = ms + Cells(ii, i)
Next ii
MsgBox ms
Cells(16, i) = ms
Next i
end sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
And, Don Guillett was not re selected.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Sunday, July 01, 2012 11:24 AM
To: excel-macros
Cc: Dilip Pandey ; ashish koul
Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
Nicely done. Suggest refresh of external query on opening .
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Thursday, February 09, 2012 8:57 AM
To: excel-macros
Subject: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW
DA
I just
type name of file into a cell and run this macro to determine file size
Sub filesize() 'FOR SELECTED
MsgBox FILE SIZE IS Format(FileLen(ActiveCell .xls) * 0.0009767,
0) KB
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Prince Dubey
Sent:
With large data, you may take a bit of time with any method. Perhaps you could
break it up.
If desired, send your real file to ME.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Gandhi
Sent: Tuesday, July 03, 2012 3:17 AM
To:
http://www.add-in-express.com/docs/net-excel-xll-addins.php
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Wednesday, July 04, 2012 1:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Function_Code
Dear experts,
I won’t speak for others but your plea for “urgency” makes me NOT respond as
all requests are urgent and yours is no more urgent than others.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dhartikumar Sahu
Sent: Tuesday, July 03, 2012 11:52 PM
To:
Congratulations from Austin Texas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Wednesday, July 04, 2012 11:16 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Hello Everyone,
Rajan Verma has
Since you already have it filtered why have separate sheets. Simply add rows at
top and use a subtotal(109. Or a separate sheet with sumifs for each city
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Deepak Rawat
Sent: Thursday, July 05, 2012 8:26 AM
To:
You could just allow row insertion option before protecting or
ActiveSheet.Unprotect Password:=Don
Rows(ActiveCell.Row).Insert
ActiveSheet.Protect Password:=Don
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, July 06,
If?? I understand what you want, right click sheet tabview codeinsert
thisdouble click on sheet name in column A
Private Sub Worksheet_BeforeDoubleClick (ByVal Target As Range, Cancel As
Boolean)
If Target.Column 1 Then Exit Sub
Application.Goto Sheets(CStr(Target)).Range(Target.Offset(, 1))
If ? I understand your need try this
Sub insertrowsifSAS()
dim I as long
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
lr = Cells(Rows.Count, i).End(xlUp).Row
If lr 1 Then Cells(lr, 1).Resize(Int(Cells(1, i)) + 1).EntireRow.Insert
Next i
End Sub
Don Guillett
Microsoft Excel
Had you explained that you want to select the appropriate range in ALL sheets I
would have offered.
Sub selectallSAS()
dim I as long
With Sheets(settings)
For i = 2 To .Cells(Rows.Count, 1).End(xlUp).Row
Application.Goto Sheets(CStr(.Cells(i, 1))).Range(.Cells(i, 2))
Next i
End With
End Sub
Don
With
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: dguillett1
Sent: Friday, July 06, 2012 9:49 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet
Had you explained that you want to select
To limit the columns.
ActiveCell.Resize(, 4).Insert shift:=xlDown
activecell + 4 columns
or
Selection.Insert shift:=xlDown
select the columns of the row desired
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: B Sharma
Sent: Saturday, July 07, 2012 1:21 AM
http://www.cpearson.com/excel/Rank.aspx
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, July 07, 2012 5:42 AM
To: excel-macros
Subject: $$Excel-Macros$$ Need to upgrade a formula
Hi Group,
Would request you to please help
This should cover ALL contingencies as if finds the last row, finds the 1st and
last columns to evaluate and the row to insert.
Sub insertrowsifSAS()
Dim lr As Long
Dim c As Long
Dim I As Long
lr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
'finds the first column to evaluate
For
When all else fails, try the f1 button
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: priti_verma
Sent: Saturday, July 07, 2012 8:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How Offset function Works
Hi All,
I am new to excel ,
Right click sheet tabview codeinsert this. Now when you put 149 in col A
col B will populate
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 2 Or Target.Column 1 Then Exit Sub
Target.Offset(, 1) = # Target Story
End Sub
-Original Message-
From: deej109
Sent:
You need to post examples, etc.
From: Rajendra prasad yadav
Sent: Monday, August 08, 2011 1:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give the
macro
Homework?
-Original Message-
From: XLS S
Sent: Monday, August 08, 2011 3:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Question
Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I
What do you need to do in Word that you can't do in excel?
-Original Message-
From: skyping1
Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets
labelled 1 to X to Word.
Anyone have any ideas on this
try
$F$4581=Lost)+(Data!$F$2:$F$4581=
From: Shiek Peer Mohd
Sent: Tuesday, August 09, 2011 1:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ sumproduct issue
Hi Experts,
I have the issues in using the multiple criteria in sumproduct. Sample file
attached.
Regards,
Can you clarify with examples
From: Sunny
Sent: Tuesday, August 09, 2011 5:51 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compute combinations, permutations
Hi ,
I am very new to combinations, permutations in Excel, Need help on the attached
file.
I have 3 different
Will dataadvanced filterunique work for you?
-Original Message-
From: Rajan_Verma
Sent: Tuesday, August 09, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ UNIQUE values in Array
Hi,
I was trying to Get Unique List by Using Array Function and the Output is
if we have VBA.
Thanks
Rajan Verma
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, August 09, 2011 8:31 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ UNIQUE values in Array
What you want is doable with a macro. However, your “dummy” data does not give
data for testing to see what you really want. Redo your data and give a better
explanation of what you want. This to get you started
Application.Goto Sheets(3).Range(a2)
myname = Application.InputBox(Pick a cell Then
Attach a file with a better explanation and before/after examples
-Original Message-
From: AJ
Sent: Tuesday, August 09, 2011 2:20 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Locking cells based on conditions / todays date
There are dates in calendar order stored in row
Attach a file
From: Sundarvelan N
Sent: Tuesday, August 09, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached image. Please help on this scenatio.
Thanks
N.Sundarvelan
9600160150
--
Notice the sheet arrow keys at the bottom left. RIGHT click onevoila
-Original Message-
From: Dsastray
Sent: Tuesday, August 09, 2011 4:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic code
found is not working.
I would like
Run this macro on your numbers and just use =e8+g8
Sub fixmynumsSAS()
Application.ScreenUpdating = False
'lr = Cells.SpecialCells(xlCellTypeLastCell).Row
On Error Resume Next
For Each C In Selection 'Range(a1:q lr)
If Trim(Len(C)) 0 And C.HasFormula = False Then
C.NumberFormat =
Post a file with a more complete explanation
-Original Message-
From: Seba
Sent: Wednesday, August 10, 2011 9:36 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ copy selected range to target with params
hi,
I need help with writing a macro which would copy selected range and
Itappears that this is only partially done. You need a worksheet_change
event macro tied to the dropdown cell to do the rest. How do you want the
list of cities displayed?
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 4:00 PM
To: excel-macros@googlegroups.com
or
Sheet1.Range(f2).Value=Sheet1.Range(f2).Value + 1
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 3:10 PM
To: excel-macros@googlegroups.com
Cc: John A. Smith
Subject: Re: $$Excel-Macros$$ Add 1 to a cell every time the file is opened
Hey Johnasmith,
Please find
Or with col 8 formatted as desired place this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 2 Or Target.Column 7 Then Exit Sub
If UCase(Target) = DONE Then Target.Offset(, 1) = Date
End Sub
-Original Message-
From: XLS S
Sent: Wednesday,
To remove macros simply save as .xlsX
From: ja...@macstop.co.uk
Sent: Wednesday, August 10, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ PasteSpecial
thanks - it's a long story but basically I'm trying to export some sheets from
a workbook with loads of code
I now understand what you need. Have you gotten a satisfactory result yet?
From: Rajan_Verma
Sent: Wednesday, August 10, 2011 9:45 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Macro copy filter data in a new sheet
Please Ignore Previous Mail..
See if it helps
Put this macro into a regular module in the Bif file to get the number from the
data file
Option Explicit
Sub GetID_SAS()
Dim lr As Long
Dim myid As String
Application.ScreenUpdating = False
Application.DisplayAlerts = False
myid = InputBox(ID to get, ie 103)
Workbooks.Open Filename:=Total
=SUMPRODUCT((A2:A22={a,c,g})*B2:B22)
-Original Message-
From: naresh v
Sent: Thursday, August 11, 2011 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Like pivot table function
Hi friends,
I have attached one excel, can you please help me ..
Regards,
Naresh V
--
. i have already developed a function
but i was thinking there must be some array function which will store just
unique values in ARRAY but i guess now there's none. anyways thank for your
help.
--- On Tue, 9/8/11, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
or just a little bit neater
Sub MtestSAS()
Application.ScreenUpdating = False
For i =cells(rows.count,”P”).end(xlup).row To 1 Step -1
If Cells(i, 16).Value = 0 Then rows(i).Delete
Next i
Application.ScreenUpdating = True
End Sub
From: Mahesh parab
Sent: Thursday, August 11, 2011 1:15 PM
To:
Pls ignore previous post. I sent the wrong file
Change to verticalremove all merged cellsuse autofilter with SUBTOTAL(109
function
From: Dominic Sundar
Sent: Thursday, August 11, 2011 7:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Forms
Hey there
attach is a copy of an
sheet based on criteria
Hi
if you have only three areas you can do it without macro see the attachment .
just insert a temp column before A and then apply filter and paste data on
sheet 2 rename the sheet
On Sat, Aug 13, 2011 at 10:32 PM, dguillett1 dguille...@gmail.com wrote:
Haven't
Name your shape “LockShape” and use this assigned to a button or another shape
Sub HideUnhideLockShape()
Shapes(LockShape).Visible = Not _
Shapes(LockShape).Visible
End Sub
From: SAJID MEMON
Sent: Tuesday, August 16, 2011 5:33 AM
To: Excel Group
Subject: $$Excel-Macros$$ AutoHide
Hi all
Your source files should all be structured the same. If not, you will have to
program. Attach samples
From: vikas gupta
Sent: Tuesday, August 16, 2011 6:55 AM
To: excel-macros@googlegroups.com
Cc: pankaj chawla ; tech_pankajcha...@rediffmail.com
Subject: Fwd: FW: $$Excel-Macros$$ Workbooks
I would restructure your table to make it simpler but this works.
From: x x
Sent: Tuesday, August 16, 2011 7:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Table - extract some data
Folks, please give me a hint about table attached. I'd like to find a way to
extract exact
I did this VERY recently in another formum. Was it you?
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
tr = Target.Row
Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone
If Target.Column 1 Or Not IsNumeric(Target) Or _
, 2011 at 11:42 PM, dguillett1 dguille...@gmail.com wrote:
I did this VERY recently in another formum. Was it you?
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
tr = Target.Row
Rows(tr).Borders(xlEdgeBottom).LineStyle
For a simple solution, simply record a macro while doing it manually.
From: Satish Bandaru
Sent: Wednesday, August 17, 2011 1:06 AM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro
hi experts
please help me.plz find the atachment
thanks in
It would be very helpful if your data could result in an actual case with a
real example.
You ask to search for data that does NOT exist.
-Original Message-
From: Baby Patel
Sent: Wednesday, August 17, 2011 8:08 AM
To: excel-macros
Subject: $$Excel-Macros$$ Need a Formula or Macro
Look in the vba help index for DIR
From: crazybond
Sent: Wednesday, August 17, 2011 3:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request for Directory Audit Macro
Hi Experts,
Can a vba code/macro be created/ is available in case one needs to do the audit
on the
This will do all with the macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column 1 Then Exit Sub
With Sheets(Sheet2)
.Range(H6) = Target
.Range(d9) = Target.Offset(, 1)
.Range(d11) = Target.Offset(, 2)
End With
End Sub
-Original Message-
From: Dilip Pandey
these data are here in the zipped
file. You can use price list to find the details.
Thanks and regards,
Smriti
On 8/18/11, dguillett1 dguille...@gmail.com wrote:
It would be very helpful if your data could result in an actual case with
a
real example.
You ask to search for data that does NOT exist
Sub FOREACHTRUE()
mc = h 'change to column with formula
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row
If InStr(Cells(i, mc).Formula, TRUE) Then _
Rows(i).Hidden = True
Next
End Sub
From: ashish koul
Sent: Thursday, August 18, 2011 8:05 PM
To: excel-macros@googlegroups.com
Subject: Re:
A simple vlookup formula such as this to lookup the item in the IS sheet when
you know the column should do it. You can then use edit/replace to change the
formulas. A one click macro could do it all.
=VLOOKUP(J9,'2011 Actual'!B2:AG331,10,0)
From: Steve Weaver
Sent: Friday, August
Post your file with a complete explanation and tell us your excel version.
-Original Message-
From: Bob
Sent: Saturday, August 20, 2011 7:46 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Hide Rows that are NOT Yellow
On Sheet2 I have some rows that are highlighted in yellow
I meant to say you can NOT use that part of the formula for the vlookup for
Actual but you can use the match part for the Forecast sheet.
-Original Message-
From: Don Guillett
Sent: Saturday, August 20, 2011 1:08 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help
Sounds a bit like “homework”
From: pankaj gmail account
Sent: Sunday, August 21, 2011 11:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message
Dear Group,
Can you people help me I want to create a Excel based Birthday Mail which will
for this task. Please find the
attachments.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 11, 2011 at 3:18 AM, dguillett1 dguille...@gmail.com wrote:
Or with col 8 formatted as desired place this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range
If I understand your request, you may like this. It also saves the file
Sub cleanrowsandcolumnsSAS()
lr = Cells.Find(*, Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row
lc = Cells.Find(*, Cells(Rows.Count, Columns.Count) _
, , , xlByColumns, xlPrevious).Column
I will take a look at your file dguillett1 @gmail.com
-Original Message-
From: Amit Desai (MERU)
Sent: Tuesday, August 23, 2011 6:26 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file
I have more than 1000 formulaes...spreaded in 4
Rows(lr).Resize(Rows.Count - lr).Delete
Columns(lc).Resize(, Columns.Count - lr).Delete
Application.EnableEvents = True
ActiveWorkbook.Save
End Sub
'--thank you
siti Vi
On Tue, Aug 23, 2011 at 7:37 PM, dguillett1 dguille...@gmail.com wrote:
If I understand your request, you may like
file. You can use price list to find the details.
Thanks and regards,
Smriti
On 8/18/11, dguillett1 dguille...@gmail.com wrote:
It would be very helpful if your data could result in an actual case with
a
real example.
You ask to search for data that does NOT exist.
-Original Message
I would probably also use a macro but if you have a list of sheet names in
column A and put this formula in col B and copy over and down
=INDEX(INDIRECT($A2!a:z),MATCH(,INDIRECT($A2!A:A),1),COLUMN()-1)
-Original Message-
From: Clint Stevens
Sent: Wednesday, August 24, 2011 12:45
Change to 99 if numbers in col a of source sheet
-Original Message-
From: dguillett1
Sent: Thursday, August 25, 2011 8:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets
to a Summary Sheet
I would probably
Should do it assuming layout as described
-Original Message-
From: GreenBriar
Sent: Thursday, August 25, 2011 10:55 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns
I have a series of spreadsheets that have data in them that needs to
, 2011 9:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a Formula or Macro
thanks for your assistance. Please take a look. Earlier did not work.
Thanks,
Smriti
On 8/24/11, dguillett1 dguille...@gmail.com wrote:
If you didn't solve this, I'll take a look?
-Original
Could have been more efficient without selections or incrementing i as in my
offering I previously sent
Option Explicit
Sub transposerows()
Dim i As Long
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row Step 3
Cells(i, 1).Resize(3).Copy
Cells(i, 2).PasteSpecial Transpose:=True
Next i
I didn't test the other code but you may want to try this simple version.
Put in sheet module modify to suit your range and top row
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Range(sortarea).Sort Key1:=Cells(2, ActiveCell.Column),
Order1:=xlAscending
What userform? Put this in the ThisWorkbook module
Private Sub Workbook_Open()
nameofyouruserformhere.Show
End Sub
From: Suryaprasad
Sent: Tuesday, August 30, 2011 7:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ User form
Hi All,
Need a small help , i need to get a pop
You can put this in a regular sub or this worksheet double click event
Right click sheet tabview codeinsert thisdouble click any cell to name range
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
For Each N In ActiveWorkbook.Names
If InStr(1, N.RefersTo,
=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
Dear All,
Do we have any option for countifs Sumifs formula in MS Excel 2003?
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
=sumproduct((a2:a22=1)*(b2:b22))
From: Amit
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Left(Cells(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete
Next i
End Sub
===
-Original Message-
From: Gaetan M
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Left(Cells(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete
Next i
End Sub
-Original Message-
From: Gaetan M
Sent:
You could use this as your criteria but what happens if you also have the
same amount for another 100 rows down and you sort by col E. You could get
UN intended results.
-Original Message-
From: Gaetan M
Sent: Wednesday, August 31, 2011 7:30 AM
To: MS EXCEL AND VBA MACROS
Subject:
=SUMPRODUCT((B3:B22=F5)*(A3:A22=G5)*C3:C22)
From: Sudhir Kumar
Sent: Wednesday, August 31, 2011 6:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Book2.xlsx
Dear All
Please suggest a formula of Sumproducts
Thanking u
--
-Macros$$ Macro to remove repeats and merge
Thank you. The criteria is the column E (RNLO)
On Aug 31, 7:50 am, dguillett1 dguille...@gmail.com wrote:
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step
I would suggest a different structure something like this with all on one line
and use filters and SUBTOTAL(109
date item scheme recd issued on hand
From: Satish Bandaru
Sent: Friday, September 02, 2011 4:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ stock on
Have you tried looking at the help index for countifs?
From: Amit Desai (MERU)
Sent: Friday, September 02, 2011 4:51 AM
To: excel-macros@googlegroups.com
Subject: FW: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
Dear Rajan,
Thanks for this..but I do want to edit
Use a SPIN button from the control toolbox. See atttached
From: Cab Boose
Sent: Friday, September 02, 2011 8:12 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Counter in a Cell
Hi
In attached Sheet1, I want the cell to count from 0 to 16 up and down in
between. The count is
application.enableevents=false
code block
application.enableevents=true
-Original Message-
From: John Holland
Sent: Monday, September 05, 2011 3:28 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ processor to slow for proper sequential processing
of vba code ?
I am
You could maybe use a macro or a simple vlookup formula
From: Shankar Bheema
Sent: Monday, September 05, 2011 8:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003
I am attaching the VBA project and a sample spreadsheet form. I want build a
@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
Not yet..could you please explain me in detail?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Friday
I am not understanding. Perhaps a sample file dguillett1 @gmail.com
-Original Message-
From: John Holland
Sent: Tuesday, September 06, 2011 2:14 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ processor to slow for proper sequential
processing of vba code ?
Thanks
Perhaps because you said to avoid vba. What excel version. Perhaps a sample
file.
From: Zafar Iqbal
Sent: Tuesday, September 06, 2011 2:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting
Dear Experts,
Will somebody inform me that why my request is
A simple way to do this is to select the column headers(top row marked a,b,c,)
desiredplace you mouse on the line between any 2 and click. Record a macro and
assign to a shape or button, if desired.
From: Shankar Bheema
Sent: Tuesday, September 06, 2011 8:48 AM
To:
Be sure to SAVE your file before rechecking. Older versions may require closing
the file and reopening.
From: RK
Sent: Wednesday, September 07, 2011 4:12 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size
Try the following:
Press CTRL+A
Sub Unfilter()
ActiveSheet.ShowAllData
End Sub
Sub Filter()
With Range(a2:f Cells(Rows.Count, 1).End(xlUp).Row)
.AutoFilter field:=1, Criteria1:=Range(b16)
.AutoFilter field:=6, Criteria1:=Range(b17)
End With
End Sub
-Original Message-
From: Tariq Aziz
Sent: Wednesday, September
How about a formula
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code for search
Hai all good evening
I am
. and where to put this code. I made it on userform not on sheet.
So in your formula there is no representation of the objects na. how it works ?
On Wed, Sep 7, 2011 at 7:20 PM, dguillett1 dguille...@gmail.com wrote:
How about a formula
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0
Change the AXES to category. You don’t say which version but in 2003 right
click the chart and select
From: Ramanjaneya Reddy
Sent: Tuesday, September 06, 2011 10:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Decrease the gap between bars in Bar Chart
Is there any way to
NO can do. Cell width for the entire column must be the same. You can merge
cells but NO one suggests that so maybe format to WRAP and raise the height of
the row
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 11:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Which columns need to be totaled?
From: anu gomathi
Sent: Thursday, September 08, 2011 12:14 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Add the multiple row values delete the
duplicate row
Hi Noorain,
Opportunity column contains the duplicate. I need to convert the
NO
From: suresh k
Sent: Thursday, September 08, 2011 9:49 AM
To: Excel group
Subject: Fwd: $$Excel-Macros$$ Re: Marquee in Excel
Hi All,
Anyone is there to provide solution for this query..
Is it possible to work on other worksheet while markquee is there in sheet1.
/suresh
--
IF??? I understand just copypaste valuescopy .
-Original Message-
From: bom
Sent: Friday, September 09, 2011 2:24 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Moving Sheets
I would like to know whether its possible to move sheets from one
workbook to another without
301 - 400 of 1000 matches
Mail list logo