Sorry, Yes 2157 worksheet. this monthly salary calculations if less
than 30 days i want change the particular row modifications only .
On Sat, Nov 5, 2011 at 1:33 AM, dguillett1 wrote:
> Did you mean sheet 2157 instead of 2657?
> I, for one, am having a difficult time understanding what
Hi Sam,
Thanks it worked.
>
>From: Sam Mathai Chacko
>To: excel-macros@googlegroups.com
>Sent: Friday, 4 November 2011 12:02 AM
>Subject: Re: $$Excel-Macros$$ Determine scope of name range
>
>
>Sub NameInMe()
>
> Dim nm As Name
>
> For Each nm In Thi
Did you mean sheet 2157 instead of 2657?
I, for one, am having a difficult time understanding what you want. Please
explain the logic.
less than 30 or 31 days
===
What does I want page total in each page mean? Example>’
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothil
Then the macro I provided will do as desired whenever cell f41 is changed.
if placed in the ThisWorkbook module
You may want to try this one instead of the one I provided earlier
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Count > 1 Or Target.Address <>
Another easy way to build this would be to use Pivot Tables
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 10:43 PM, xlstime wrote:
> Please find the attachment..
>
>
>
> On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar > wrote:
>
>> Dear,EXCELERS
>>
>> On this workbook i want in summary she
Please find the attachment..
On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar
wrote:
> Dear,EXCELERS
>
> On this workbook i want in summary sheet* fill total gift given
> coloum*according their given dates Valus in second sheet (gift data),, by
> any
> formula . So please suggest any formul
Use in D20
=SUMPRODUCT(('GIFT DATA'!$B$9:$B$193=Summary!$C20)*('GIFT
DATA'!$E$9:$E$193=Summary!D$15)*('GIFT DATA'!$F$9:$F$193))
and drag down and across
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar
wrote:
> Dear,EXCELERS
>
> On this workbook i want in summary shee
Congrats Sam and
*
*
*Don Guillett, Noorain, Ashish, Dilipandey, Rajan , Aamir, Hasib ,
shaneallen *
On Thu, Nov 3, 2011 at 5:57 AM, Asa Rossoff wrote:
> Congrats Sam!
>
> ** **
>
> Lots of generous effort on your behalf.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googleg
Dear,EXCELERS
On this workbook i want in summary sheet* fill total gift given
coloum*according their given dates Valus in second sheet (gift
data),, by any
formula . So please suggest any formula for this problem.
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, ac
Sorry i checked late
Wowww such a simple solution great thanks alot
Mahreen
On Thu, Nov 3, 2011 at 10:23 PM, Sam Mathai Chacko wrote:
> So did you check my post?
>
> Sam
>
>
> On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi
> wrote:
>
>> I want the user either to have score or NA. When all box
Oops... I was typing in another window while you were doing this..
Looks like we came to the same conclusion.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all th
I think it might be helpful if you could attach a file...
I SOUNDS like you're saying that in rows 41-68
there are records of some sort.
The DATE for each record is in column G.
your first sheet ("1") the date range is November 4, 2011 through
December 1, 2011
sheet "2" has dates from December 12
I've sorted it! It was because the dates were displayed in date format
rather than numbers!
Thanks very much for all your help.
Ed.
On Nov 4, 2:43 pm, Eddie wrote:
> The tab colour doesnt change if the date is within the range or not.
> Either way the tab remains yellow.
>
> On Nov 4, 1:45 pm,
The tab colour doesnt change if the date is within the range or not.
Either way the tab remains yellow.
On Nov 4, 1:45 pm, Sam Mathai Chacko wrote:
> Here's the code to look at Range("F1") from the respective sheets for
> all sheets in the workbook
>
> Sub FindValueColorTab()
>
> Dim wks As W
I have a differing date range (G41:G68) in a number of sheets.
e.g. Sheet 1 ("1") 04/11/11 - 1/12/11, Sheet 2 ("2") 02/12/11 -
28/12/11 etc
What I want to do is colour the sheet tab which contains todays date
which is provided in F41 of each sheet.
Ed.
On Nov 4, 1:19 pm, Paul Schreiner wrote:
Here's the code to look at Range("F1") from the respective sheets for
all sheets in the workbook
Sub FindValueColorTab()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
If IsNumeric(Application.Match(wks.Range("F41").Value,
wks.Range("G41:G68").Value, 0)) Then
"Assuming" you want to search all sheets for the value that is in Range("F41")
of Sheet(1), then
Try this:
Option Explicit
Sub Find_Data()
Dim Sht, Find_Date
Find_Date = Sheets(1).Range("F41").Value
On Error Resume Next
Application.ScreenUpdating = False
For Sht = 1 To Sheets.
Copy/paste this into the ThisWorkbook module.
Now in each sheet if f41 is in the sheet range it will color the sheet tab.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Set mf = Sh.Range("G41:G68").Find(What:=Range("f41"), LookIn:=xlValues, _
LookAt:=xlWhole,
Are you saying that you want to look in the range of each sheet
for the value that is in Range("F41") of EACH SHEET
or are you looking at the value of F41 on sheet(1) and checking the rest of the
sheets for THIS value?
Paul
-
“Do all the good you can,
By a
Post your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ajjw123
Sent: Friday, November 04, 2011 1:05 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ conditional formatting for real time stock
quotes
thanks for the reply .The data is
Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("1").Select
If Range("f41").Value = Range("g41:g68") Then
ActiveWorkbook.Sheets("1").Tab.ColorIndex = 5
Else
ActiveWorkbook.Sheets("1").Tab.ColorIndex = 6
End If
End Sub
Hi,
Using the above code I'm trying to colour worksheet tabs, dete
Maybe, Attach your file with complete details and before/after examples
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Reto
Sent: Tuesday, November 01, 2011 6:39 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ "Global" Drop Down List?
Good morn
22 matches
Mail list logo