I am attempting to get this code to work. The issue I am having is that the
worksheet named Socal Work Order is in another workbook. HOw do I refer to
it? Is there a way I can do it without using the workbook name, provided
both workbooks are open? I am using Office 2003 Pro SP2.

Dim Inrng As Range
Dim ORng As Range
Dim inWs As Worksheet
Dim outWs As Worksheet
Dim iLastRow As Long

Set inWs = ActiveSheet
Set outWs = Worksheets("SoCal Work Order")
Set ORng = outWs.Cells(outWs.Cells(92, 1).End(xlUp).Row + 1, "A")

TIA