Paste range at first blank row

Hi,
I'm doing macro that takes data from two different workbooks, formats them inside themselves and paste in to a master workbook. The point is:

On a sheet(data) i want to paste first range into the cell A2, and a range from the second workbook want to paste just under the first one(at first blank cell in column A). Hope its clear. If not let me know I'll paste a exemplary workbook.

Have a nice day,

Please post your code and see what it looks like.

Here You are If you want to simpify this in some way, go ahead. I'm really new to VBA

Please Login or Register  to view this content.

Change these 2 lines

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Thank you, works perfectly