Copy and paste between two work books paste into unspecified location

Hi,

Any help would be much appreciated. I am trying to create a macro which copies form one sheet and then pastes into another workbook but into a new cell each time it runs i.e. the next week number on. I have created a macro that keeps stalling after the first sub macro. I also am sure if I have constructed it correctly or effecttively. Any advice or help will be much apprecuated i am very new to VBA Language. I have attached a sample sheet to this thread also.

Please Login or Register  to view this content.