Copy Range from one workbook to new range in new workbook!

[christopherL]

Hi there,
I have two reports being created and sent to me everyday, each day the report contains yesterdays data.
So the name will be irDeltaCRD_yesterday and irDeltaEQ_yesterday

What I want to do is copy the data from workbook irDeltaCRD_yesterday(Sheetname: irDeltaCRD_yesterday) and paste it beneath the data in woorkbook irDeltaEQ_yesterday(Sheetname: irDeltaEQ_yesterday).

I am attaching the two workbooks that are being created, these are todays.


irDeltaCRD_20131114.xls irDeltaEQ_20131114.xls

So first attachment into second attachment!

This is way out of my current skill-level so anyhelp will do.

Thank you and have a nice weekend,
Chris

[AB33]

Chris,
This is how I have done the code.
Save both sheets as XLSM on my desktop.
Open the DRL sheet from EQ sheet.
You need to change the folder and sheet names to suit you.

[christopherL]

Thank you! Regards