Posts by gbc65

Re: Execute code when cell is updated

Thanks.

Re: Execute code when cell is updated

AAE;
i thought of that originally, but i want this code to be executed on every sheet (except for DATA, TEMPLATE, TOC) and all future sheets. manually adding this code to each sheet is not practical, as this code is called shortly after a new sheet is created.

is there a way to automatically add this code to a worksheet after it is created?

thanks
greg

I have the following sub, and as good or poorly written as it is, it does what it should.
my question is this, it does what it should only after i select the cell after the data has been entered, i would like it to do its thing when the cell is exited after entering data. does this make sense?

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If ActiveSheet.Name = "DATA" Or ActiveSheet.Name = "TEMPLATE" Or ActiveSheet.Name = "TOC" Then Exit Sub
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
 
    On Error Resume Next
    If Not Intersect(Target, Range("b6:b25")) Is Nothing Then
        If IsError(Application.Match(ActiveSheet.Range("B" & ActiveCell.Row).Value, Sheets("DATA").Range("D2:D4000"), 0)) Then
        If Right(ActiveSheet.Range("b" & ActiveCell.Row), 2) = ".1" Then
            ActiveSheet.Range("c" & ActiveCell.Row) = ActiveSheet.Range("c2").Value & " RACK CHROMING"
            Exit Sub
            Else
                If Right(ActiveSheet.Range("b" & ActiveCell.Row), 2) = ".2" Then
                ActiveSheet.Range("c" & ActiveCell.Row) = ActiveSheet.Range("c2").Value & " RACK PC-MATTE BLACK"
                Exit Sub
                End If
        End If
        End If
End If
 
End Sub

thanks
greg

Re: sumif based on the last 2 characters of corresponding cell in another column

AAE:
My bad, i meant to add the link when i edited my first post, but got side tracked and forgot.
thanks

Re: sumif based on the last 2 characters of corresponding cell in another column

AAE:
thanks, i saw the typo, in my post, and corrected it, but not before you saw it. Your solution gives me a #value error, but because i want to total column J, which are products of a formula, i need to incorporate error checking into your solution for it to work.
as i am just a beginner at this, what would you propose?
thanks
also, what does the -- do in the formula you provided? (i tried to search for this but i need some explanation to point me in the right direction)
greg

Hi all,
I'm trying to write a sumif formula. i want to sum the values from J6:J25 ONLY if the right 2 characters in D6:D25 <> ".2".
this is what i've come up with, but it doesn't work

=SUMIF(D6:D25,RIGHT((D6:D25),2)<>".2",J6:J25)

any help on this is greatly appreciated.
thanks
Greg