Hi mehmetcik, Thanks for your response. This looks really close to what I need.

The thing is, I need to run this macro from worksheet 'new' in the 'test sheet.xlsm' workbook. So it will need go to workbook 'test sheet.xlsx', retrieve the data within the parameters you have set out and paste it back into 'test sheet.xlsm' workbook on the 'new' worksheet.

If this is this possible.

Thanks again