Jump to content

NWBuck

Legacy Members
  • Posts

    4229
  • Joined

  • Last visited

Posts posted by NWBuck

  1. OK, @Dahobbs, new question...

    I've got a database where folks are filling in information, but there are a lot of categories that are blank. (Specifically, we're hiring, and my database shows all the positions- my staff updates demographic info when the positions are filled)

    I've got another table which pulls out limited info (name, position, pay rate), and I'd prefer that Finance wouldn't have to wade through all the blank rows (open positions).

    Is there a way to create a table that hides rows if one cell (last name, for instance) is empty/blank and then unhides the row if that cell gets updated?

    I'll hang up an listen.

  2. 4 hours ago, Dahobbs said:

    Post the code. 

    Borrowed from an online forum, adapted for my parameters:

    Private Sub Worksheet_Change(ByVal Target As Range)
        ' define Timestamp output column
        Const TimeStampColumn As String = "I"
        
        ' Observe C2:E1048576 for changes
        Dim RangeToObserve As Range
        Set RangeToObserve = Me.Range("A3:E" & Me.Rows.Count)
        
        ' Get all changed cells within the observed range
        Dim ChangedCells As Range
        Set ChangedCells = Application.Intersect(Target, RangeToObserve)
        
        If Not ChangedCells Is Nothing Then
            Application.EnableEvents = False
            On Error GoTo ENABLE_EVENTS ' make sure in case of errors events get enabled!
            
            Dim Row As Variant ' write timestamp for every changed row
            For Each Row In ChangedCells.Rows
                With Me.Cells(Row.Row, TimeStampColumn)
                    .Value = Now()
                    .NumberFormat = "dd\/mm\/yyyy hh:mm"
                End With
            Next Row
            
            On Error GoTo 0
        End If
        
    ENABLE_EVENTS:
        Application.EnableEvents = True

        If Err Then
            ' make sure to raise the error otherwise it will be silent and you will never notice that anything went wrong.
            Err.Raise Err.Number
        End If
    End Sub

  3. OK, I'll play... 

    Excel sheet with a macro to datestamp when a cell in the row changes. 

    Can't get it to fire when a cell auto-fills in response to another sheet being updated (using xlookup). So, the cell isn't empty (per se) since it's got that formula in it. But I'd like it to datestamp when it goes from blank to showing data. 

    Thoughts? 

  4. 13 hours ago, ChuckNorrisActionJeans said:

    We ArEn't a DEMocracY LibTAARD!!11  IT's A coNStiTuTionAL RePUbLIC  huurrrr durrr

    I see this stupid talking point almost every fucking day. No, they don't support democracy.

    "BE IT FURTHER RESOLVED that we... oppose legislation which makes our nation more "democratic" in nature, and that, while we favor and encourage liberty in all 30 nations, we oppose all efforts to use American military might to spread "democracy" around the world."

    Your Washington State Republican party, folks...
    https://www.seattletimes.com/seattle-news/politics/the-wa-gop-put-it-in-writing-that-theyre-not-into-democracy/

    • Rage+1 2
  5. Things that started out as "oops" but now are the way I pronounce things to embarrass my daughters in front of their friends:

    • "luh-VAN-dur" = Lavender
    • "ren-day-ZEE-voose" = Rendezvous
    • "extra ordinary" (break between words)= Extraordinary
    • "kuh-RAM-muhl" = caramel (as a counter point to the "car.mel" and "care.a.mel" debate)
    • Given the previous, was a big fan of "kuh-RAM-muh-low" in the early 2000s

     

    • Like 1
  6. Good question- Lots of places to eat and shop and stuff right near the Bainbridge landing area, so you could probably get away with just walking.

    You might consider renting a bike if you want to tour around a bit more (https://www.bikebarnrentals.com/)... I always try to go the the Exclusion Memorial when I go over to the island (with my car): https://www.nps.gov/miin/learn/historyculture/bainbridge-island-japanese-american-exclusion-memorial.htm

    Here's a few resources: 

     

    • Like 2
  7. 16 minutes ago, RDCanecutter said:

    I like to think that there is a semi-liquid poop pool down at the asshole, so that farts percolate up through it like pot smoke through bong water, except maybe with different effects.

     

    • Haha 2
    • Drool 1
  8. 10 minutes ago, Gil Bang said:

    45 degrees in the courtroom y'all. 

    "We're only honoring the 45th President!"

    ("and trying to keep the stench down by freezing it")

  9. 7 hours ago, Red Five said:

    "Nuh uh! Thank you your honor." (sits down)

    5 hours ago, C-Man said:

    Lies upon lies upon lies ad nauseum

    They should let Trump serve as his own lawyer... you know, with his big brain and all that.

     

    • Haha 2
  10. 23 minutes ago, Pato del Muerto said:

    If you’re cool with million dollar house prices. But I guess if you are comfortable in Seattle proper, you would be. 

    Yup. Except the ones in Seattle are about 2/3 the size and no yard or acreage for the same price.

  11. 22 hours ago, otisdog said:

    Pretty sure that the Lynnwood extension opens August 30.

    Just going to add this...

    On 4/20/2024 at 6:44 AM, gmr548 said:

    Our initial inclination is to look for a place in north Seattle convenient to I-5 and rail. Greenwood, Maple Leaf, Northgate, Green Lake, Roosevelt, something like that. Any thoughts on whether that counter-commute is doable? Evidently there are some staff that live in north Seattle and say it's not bad. I definitely prefer an urban location like that but I work remotely, I'm not the one commuting. Honestly I could compromise on an inner ring suburban location like Shoreline or Mountlake Terrace as long as it's convenient to I-5 + the coming rail extension. I worry that commuting from North Seattle will suck for her despite it being a counter commute but my wife is pretty set on living in Seattle proper as a base to get to know the region better. 

    If you can get past the need to live in Seattle proper, being in Edmonds would be pretty sweet- close to Everett and a quick jaunt down to Seattle if you wanted. Bothell or Montlake Terrace (as you mentioned) might also work (Snohomish county for tax purposes).

    If you were open to something more rural/small town, Snohomish is pretty nice, and I have a lot of friends who really like Woodinville (lotta wineries and such in that area).

    • Fuck Around and Find Out 1
×
×
  • Create New...