Copy from 1st workbook and paste to 2nd workbook

I am trying to create a macro whereas I copy data from an open workbook and paste into a 2nd (unopened) workbook. Not a probelm in itself except I want to run this on a weekly basis and each week (for up to 5 weeks) I need to place the data in to a different cell range.This data in the 2nd workbook is accumulated and expressed in chart form. PLEASE Help as it sending me crazy!!! I've been trying with elseif but without any luck.

Thanks

Zipped example files attached

I want to copy "Gold formatted" cells from "Schedule_new.xls" into "Gold formatted" cells "Fault_codes_monthly.xls" sheet = "weekly faults"

Hi Roy

Thanks for the prompt reply.

I've stripped the code right back to something that works. As you can see all it will do is copy and paste from cells "C1:G138" from one workbook to destination cells "C1:G138" on the other.

Thanks again!!

Please Login or Register  to view this content.

Hi Roy

Thanks for the code.
To explain more clearly whenever I run the macro I want to paste to cell "C2" in the destination file then use the same macro the following week which will see that cell "C2" contains text so move along to next empty cell (which would then be "H2") and paste there and so on for the remaining weeks of the month. I nearly had it last night with the code you originally gave me but it's still not there.


Thanks!!

Thanks Roy!!

Wasn't far out after all. I've added code for info.
Works great without Option explicit statement but when incorporated gives "compile error" : "Variable not defined" on answer =
This must be any easy fix surely???
Thanks!!

Please Login or Register  to view this content.