Copy multiple rows from one workbook & paste to another below existing data

using excel 2010. Can someone please help me in creating a macro that will copy multiple rows (#'s of rows will constantly change) from one workbook & then paste them into another workbook below existing data (& the # of rows with existing data constantly changes as well)

Thank you.

Assuming that both workbooks are opened and you wish to copy from a workbook named "Data" and sheet "Info" you could try something like this

Please Login or Register  to view this content.

Where the copy to part is set by the line

Please Login or Register  to view this content.

If your data in target workbook (ThisWorkbook) does not start in the A column you need to change this to the propper column.

Alf

Thanks - did a little modifying & it works.