I use this code from one worksheet to open another worksheet and
transfer data from selected cells
Workbooks.Open Filename:="R:\General\COVER SHEET_Protective\Protective Packaging Order Log.xlsm", Password:="PP", WriteResPassword:="PP"
Set LastRow = Sheets("ORDER...