S.D.N.Y. Orders Redactions In Summary Judgment Exhibits for PII Covered by GDPR

This past week, Judge Ronnie Abrams issued a decision, Letchford v. Scotwork (N. Am.), Inc., 19-CV-8921, 2020 U.S. Dist. LEXIS 221770 (S.D.N.Y. Nov. 24, 2020) granting the parties' joint motion to seal exhibits for their summary judgment motions.

The parties requested permission to redact personal information (email addresses, telephone numbers, and home addresses) of Scotwork employees who were EU citizens pursuant to the requirements of the General Data Protection Regulation. The Court determined that even though there was a strong presumption of access, since the documents were relevant for the Court's judicial function, it found limited redactions could be made since the personal information was not necessary or helpful to deciding the summary judgment motion. "Court thus finds that the parties' interest in maintaining the confidentiality of Defendants' employees' personal information sufficient to rebut the common-law presumption of access." Id. at *3.

Set All Excel Rows to the Height of the Highest

You can use the below vba code, available here on the Extend Office site, to automatically adjust all of the rows on an Excel worksheet to the height of the highest row.

The process is simple. Right click on cell which contains the most text. (If you're not sure, you can use the LEN formula to find which cell has the greatest number of characters.) Check the height of that row, and then copy it into the column to the right of the data on the worksheet for all rows.

Run the macro, and then select the column which contains the height of the highest row. All of the rows will be set to that height!

Sub rowheight()

'Updateby Extendoffice

Dim hgt As Variant

Dim WorkRng As Range

xTxt = ActiveWindow.RangeSelection.Address

Set WorkRng = Application.InputBox("please select the data range:", "Kutools for Excel", xTxt, , , , , 8)

For Each H In WorkRng

If H.Value > 15 Then

hgt = H.Value

H.EntireRow.Select

Selection.rowheight = hgt

End If

Next H

End Sub

Automatically create static hyperlinks in Excel - without the HYPERLINK function

If you don't want to use the HYPERLINK function in Excel to create links on a spreadsheet, but instead want to automatically add in 'static' hyperlinks that don't rely upon the dynamic information in the function, you can use the below vba code.

Begin with a worksheet like this, with the names to be displayed for the links in one column, and the file paths for the links in the column to the right.

Edit the visual basic code so that the range listing the file paths is listed:

The macro will automatically create hyperlinks in the second column.

Sub CreateHyperlinks()

Dim cl As Range

For Each cl In Range("B2:B3").Cells '## Modify as needed

cl.Hyperlinks.Add cl, cl.Value, , , cl.Offset(0, -1).Value

Next

End Sub