Copying a changing range from another workbook and pasting it after last column

Hi,

I wonder if someone might be able to help me out here. I've got a macro which builds a report on the status of applications, copying all applications of a particular status to their own tabs in a new workbook and adding a summary sheet to that wb. The summary sheet very simply lists the status' (tab names) and the number of applications in each. What I am trying to do is allow the user to refer to a previous version of the report and copy the stats from that sheet and paste it into column C of the current version. I have attached two sample files. Using them as an example, I would want to copy the range B2:C9 from Apps Report 230114 and paste that into column C of Apps Report 240114. Over time this range will obviously grow so I'd want the range to take account of this. I'd also like the clipboard to be emptied once the paste has happened and the range deselected (or cell A1 selected).

This is the code I have at the moment. It is at the end of the report macro.

Please Login or Register  to view this content.

Anybody?