Adding More To My Macro

I have a Macro that I use often - It cuts a Designated Row from my AMZ-GM Open Sheet and moves it to the first open row of AMZ-GM Sold and leaves Cell U in that row Copied to the clipboard.

I would like to add two more jobs to that macro but am having a hard time.

1. I currently start the process in AMZ-GM Open.xls by Control F to find the SKU Number for the item I want to move ( it is always in Column N ) - I then manually highlight the entire row and run the macro below.

I would like to add code to my macro to highlight the row that my SKU cell found is in.

SO.... I want to start my macro from a single chosen cell instead of a chosen highlighted row.

I need to start my macro from the chosen cell in Column N. I need to add code to Highlight the row that my active cell is in and then proceed with the rest of the macro.

I recorded a macro starting with a cell -highlighting the row but it records as a specific cell / row number. I dont understand how to make it based on what ever cell is shown as active.

2. I would like to take the copied cell text ( U ) that remains from the last command and insert it into an open Word Document ( Amazon Sale.doc) at the position of the cursor in the that open Word Document. I'm not finding much info on moving that cells text to Word.

Heres my current Macro
--------------------------------------------------------------

Sub OpentoSold()
'
' OpentoSold Macro
' Macro recorded 2/1/2008 by Mike
'
' Keyboard Shortcut: Ctrl+q
'
Dim objLastRow As Range
Dim lastRow As Integer

Selection.Cut
Windows("AMZ-GM-Combine.Xls").Activate

Windows("AMZ-GM Sold.xls").Activate '

Set objLastRow = ActiveSheet.Cells.SpecialCells(xlLastCell)

lastRow = objLastRow.Row + 1

Rows(lastRow).Select
ActiveSheet.Paste

Range("U" & lastRow).Select

Selection.Copy

End Sub

------------------------------------------------------------