Hi,

I'll say right off the bat that I have very little experience programming. I do have an aptitude for it, but that doesn't get you very far without training .

Here is my question/situation:

I have made a macro (using the record button) that copies information from particular cells on sheet 1 and copies them to cells on another sheet called "tracker". It works just like I told it to, but now I want it to check if the cell is occupied and if so, then paste the information on the next row. Can any of you guys help me with that? Here is the code which I copied from the macro I created.

Sheets("Sheet1").Select
    Range("N12").Select
    Selection.Copy
    Sheets("Tracker").Select
    Range("b2").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Sheets("Sheet1").Select
    ActiveWindow.SmallScroll Down:=12
    Range("B29").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Tracker").Select
    Range("C2").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Sheets("Sheet1").Select
    Range("N34").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Tracker").Select
    Range("D2").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
Thanks in advance for any help you guys can give.