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.

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



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


Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

 

All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.

 

This policy is subject to change at any time.

 

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com