Hello,
Please find below VBA code. Thanks
Option Compare Text
Dim NSession As Object
Dim NDatabase As Object
Dim NUIWorkSpace As Object
Dim NDoc As Object
Dim NUIdoc As Object
Sub email_notification(ByVal wrkbk_nm As String, ByVal notes_id As String)
' source mrexcel
Set
Dear Group,
How to attach Excel file here in this post? I cannot find any button
for attaching files here in this page. Please help. Thanks
Zafar Iqbal
--
--
Some important links for excel users:
1. Follow us on
Clint
Have you thought about using formulas for your summary sheet? That
way you won't need to copy to a summary sheet, repeat the process, and
then delete it the following day. The formula will keep your summary
sheet constantly updated. You would need to set it up to begin with,
but after
Dear Zafar,
Simply mail your attached file on excel-macros@googlegroups.com
On Thu, Aug 25, 2011 at 1:32 PM, Zafar Iqbal ziqba...@gmail.com wrote:
Dear Group,
How to attach Excel file here in this post? I cannot find any button
for attaching files here in this page. Please help. Thanks
I'm not sure that it's possible with xl 2003 because the conditionnal
formating must be the same as the range of apply.
In xl 2007 and 2010, you can make a test to a range of cell (O2:AS2 in
your example) and apply the result to O3:AS11.
The conditionnal formating has changed a lot with the new
Dear Frederic,
This function LOOKUP(9^9,A:A) is not working..
We are unable to find Adject Output, it is showing #N/A error..
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu, Aug 25, 2011 at 2:36 PM, Frederic LE
kindly put 3 condition it self and then send file.
try this code
Private Sub Worksheet_Change(ByVal Target As Range)
Set I = Intersect(Target, Range(B2:B8))
If Not I Is Nothing Then
Select Case Target
Case 0 To 100: NewColor = 37 ' light blue
Case 101 To 200: NewColor = 46 '
Huh :|
Don't you have any problem with your data (like text instead of
figure) on the last position ?
It works perfectly on my computer
On 25 août, 12:13, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Frederic,
This function LOOKUP(9^9,A:A) is not working..
We are unable to
Hey Nandkumar,
where is due date column.
and use conditional formation for highlighting
On Thu, Aug 25, 2011 at 10:07 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
-- Forwarded message --
From: shridhar pandit shriidhar.pan...@gmail.com
Date: Thu, Aug 18,
Hey Noorain,
it's perfectly working
On Thu, Aug 25, 2011 at 3:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Frederic,
This function LOOKUP(9^9,A:A) is not working..
We are unable to find Adject Output, it is showing #N/A error..
--
Thanks regards,
Noorain Ansari
Dear Experts,
Plz give attachment requirement code.
Regards
Sajid memon
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
goto excel option and click on advanced then un check
show row and column headers
On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
Plz give attachment requirement code.
Regards
Sajid memon
--
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
Dear Sajid,
Pls try
To Hide Row/Column Heading..
*Sub Hide_Rowcolumn_Heading()
ActiveWindow.DisplayHeadings = False
End Sub
*
To Unhide Row/Column Heading..
*Sub Hide_Rowcolumn_Heading()
ActiveWindow.DisplayHeadings = True
End Sub
*
On Thu, Aug 25, 2011 at 5:58 PM, SAJID MEMON
There you go
=SUM(INDIRECT('2011 Actual'!$C$3:ADDRESS(3,MATCH(*TEXT('Monthly
IS'!$J$3,MM/YY)*,'2011 Actual'!$A$1:$N$1,0
On Aug 26, 2:28 am, Steve Weaver steveweave...@comcast.net wrote:
Thank you Sam for this suggestion. However, the formula doesn't provide
the results that I am looking
see if it helps
Sub SORT_DA()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim lA, I As Long
Dim a As Range
Set a = Range(D1)
For lA = 1 To WorksheetFunction.CountIf(Columns(4), HD)
Set a = Columns(4).Find(What:=HD, After:=a, LookIn:=xlValues,
I have a series of spreadsheets that have data in them that needs to
be formatted into 3 columns instead of one column.
The data in Row 1 needs to go in row 1, column 1
Row 2 needs to go in row 1, column 2
Row 3 = Row 1, Col 3
Row 4 = Row 2, Col 1
Row 5 = Row 2, Col 2
Row 6 = Row 2 Col 3
Row 7 =
Thanks ...It was very helpful.
On Aug 22, 1:37 am, Rajan_Verma rajanverma1...@gmail.com wrote:
See if it helps :
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of bom
Sent: Monday, August 22, 2011 4:40 AM
To: MS EXCEL
how about hiding row and column heading for all sheet using VBA? Why the
code below doesn't work?
*Sub HideRowColEntireWorkbook()*
Dim sh As Worksheet
For each sh in ThisWorkbook.Worksheets
sh.DisplayHeadings=False
Next sh
*End Sub*
2011/8/25 NOORAIN ANSARI noorain.ans...@gmail.com
Dear
I want to know the formula to find out the solution.
For Ex: I have two columns
Aru
fddfs
eder
dfds
ihcx
zesr
yes
err
fddfs
dfsf
dfds
dsdas
zesr
xzcxc
vdfd
wewq
dst
fddfs
dfds
dfds
cfdf
zesr
zdfdf
zcvz
drer
sdfds
1
2
Nw i would like to sort
I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll
Employee and One in Master Franchisee of United Colors of Benetton.
Package 2.5-3 Lac.
Please call @ 9711772297
Regards
Rahul Gandhi
--
--
Some
Thanks in advance experts!!! This is very complicated to explain, but
I'll give it a go:
I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3
Sales), and need to find the percent of sales for each category, for
each year in my data.
For instance, if I have:
Invoice#Year
Please provide sample sheet.
On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar impedimenta.st...@gmail.comwrote:
I have a series of spreadsheets that have data in them that needs to
be formatted into 3 columns instead of one column.
The data in Row 1 needs to go in row 1, column 1
Row 2 needs to
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel
Dear excelguru,
Can u pls elaborate what is unique count?
And how it helps?
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 26 Aug 2011 10:49:39
To: excel-macros@googlegroups.com
Go To View and Uncheck the Heading CheckBox.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: Thursday, August 25, 2011 5:59 PM
To: Excel Group
Subject: $$Excel-Macros$$ BarHide
Dear Experts,
Plz give attachment requirement code.
Dear Sandeep,
Please see attached sheet for Example...
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 26, 2011 at 10:51 AM, chhajersand...@gmail.com wrote:
**Dear excelguru,
Can u pls elaborate what is
Try this:
Sub SortList()
On Error Resume Next
Dim Record As Integer
Record = ActiveSheet.UsedRange.Rows.Count
For i = 1 To Record
If Range(D i).Value = HD Then
Range(D i + 1).Select
29 matches
Mail list logo