Hi

I need some help here with the following. - Using Excel 2013

I have a temp worksheet which I format some data - i will be running the macro on this workbook;

What i need to do is then go to row 2 select all the rows with data in them (i need to select rows as i have data going into column "w" and possibly further)
With that data selected i need to insert the data into another excel workbook on my c drive called "Data".

However this workbook also contains data already in it - so what i need to do is to insert the data into the last row which does not contain the data

Please please can someone help with the coding here will REALLY APPRECIATE IT!!

Please if you do post any code just preface it so i can understand what is happening at each stage - i do understand a bit of vba but that is just through trial and error with the vba editor

Regards