Hi Guys,

Hoping you can help on this one as although I can work my way through code and generally adapt it i'm not exactly experienced in understanding how or why it does what it does ..

My problem .. a few times a day data is exported from a sharepoint sheet into excel and then this is copied to an existing workbook for processing and logging.

What I need is some VBA code that will copy a select range from the exported workbook to the existing workbook, the range copied must be dynamic as the first time there could be 10 lines of data and then next there could be 20,

The other problem is that the workbooks name obviously changes whenever its exported .. Book1, Book2 and so on so the source workbook name needs to be adaptive in some way..

Hope you can help .. its baking my noodle a bit ..