VBA Copy Ranges from a Worksheet to a Workbook

[pinstripe05]

Good afternoon Everyone,

I'm hoping if I could get some. I'm not familiar on how to copying a sheet from one workbook and paste it to the next available row on another workbook. I hope my explanation is helpful.

My active workbook name is called "Templates"
The sheet from the active workbook I want to copy the information from is called "Year"
The rows I would like to copy are A4:E10 and paste to the next available row on the other workbook, same columns
The workbook path I would like to paste the information to is "C:\Users\Justin\Desktop\New Offices\2012 Offices.xlsx"
The sheet in workbook 2012 Offices is called "Offices"

Both workbooks have the same headers and start on the same row. Is there a way to make sure it finds the next available row when copying over to the next workbook so it does not delete any existing information?

Any help would be appreciated.

Justin

[pinstripe05]

I'm not sure if this would help, but I have updated the excel spreadsheet so there are no blanks.

[pinstripe05]

Solved it. Thanks