gregphillips03

Sub NewTable()

Set Table = Sheet1.[a2:d4]

With Application

    Record = .Transpose(.Index(Table, , 1))
    FirstDate = .Transpose(.Index(Table, , 2))
    LastDate = .Transpose(.Index(Table, , 3))
    Count = .Transpose(.Index(Table, , 4))

gregphillips03

Keybase proof

I hereby claim:

• I am gregphillips03 on github.
• I am gregphillips (https://keybase.io/gregphillips) on keybase.
• I have a public key whose fingerprint is D31A DBDA 4DDA 1A4B BFEF A1DF A11F 795C CE3E 7DBC

To claim this, I am signing this object: