How about a nice macro to populate col K and color the month within the row.
Option Explicit
Sub crossmonthSAS()
Dim i As Long
Dim j As Double
Dim ms As Long
For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
ms = 0
For j = 2 To 8
ms = ms + Cells(i, j)
If ms < 100 Then
Cells(i, "k") = "Not Qualified"
Else
'MsgBox Cells(1, j - 1)
Cells(i, "K") = Cells(1, j)
Cells(i, j).Interior.ColorIndex = 4
Exit For
End If
Next j
Next i
End Sub
-----Original Message-----
From: Deepak Rawat
Sent: Friday, September 23, 2011 4:34 AM
To: excel-macros
Subject: $$Excel-Macros$$ Find the month of sales cross the target
Hil All
I have attached the file of data.
My problem is i have to find the qualifying month of sales by a formula.
if it does not qualify then it should reflect as "Not Qualify"
Pls Help!!
Regards,
Deepak
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
