Q:

Editing the code for a recorded Macro

I am brand new to using macros and code, and am running into a small problem. I have a sheet where I update values along a row. Since these updates are part of a process, I want excel to record my row as a sort of history in next sheet in my workbook. I recorded a macro where when I press cntrl+r, it copies the first row from my data sheet, inserts a row onto the history page, and then copies the data onto that new row. THe only problem I that my data sheet will have multiple rows of data, and I would like the macro to copy my selected row, not just the first row everytime. I have put the code below.
Thank you!
Sub RecordTracker()
RecordTracker Macro
Records the updated row as a history row in Documentation Sheet
Keyboard Shortcut: Ctrl+r

    Sheets("Documentation").Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Sheets("Tracker").Select
    Range("A3:S3").Select
    Selection.Copy
    Sheets("Documentation").Select
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
End Sub

Sorry if my formatting of the code is a little off. First post!

A:

Will Insert a new Row on sheet Documentation from (A2)
Copy the row you have selected (from sheet Tracker, Range A:S)
Paste values onto Documentation A2 (which is your newly created row) 

This will need to be pasted in VBE on your sheet Tracker to execute
Notice that your code can be greatly reduced (as far as lines go) by avoiding the .Select method. You can find some useful information here 
Sub StoreChanges()

    Sheets("Documentation").Range("A2").EntireRow.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Sheets("Tracker").Range(Cells(ActiveCell.Row, "A"), Cells(ActiveCell.Row, "S")).Copy
    Sheets("Documentation").Range("A1").PasteSpecial Paste:=xlPasteValues

End Sub

