Paste data to colums with different layout from the copy range

**Bob@Sun** · 10-16-2009, 05:57 AM

Hello again!

I previously posted a problem related to copying data from one sheet and
paste it in another workbook when "Delivered" is chosen from a drop down menu. Everything works fine with my dummy files, but a problem comes up
when I try to incorporate this code into the original file.

The issue is that once the code copies the info from the range A3:D3 it has to paste it into different cells in the other workbook.
Please see the attached file to see where I need the data from the range A3:D3 to be pasted.

Thanks in advance for the help!

**Bob@Sun** · 10-19-2009, 01:18 PM

Please Help!!!!

**Bob@Sun** · 10-21-2009, 11:29 AM

Please help!!!!

**jaslake** · 10-22-2009, 02:01 PM

Hi Bob
Your procedure works for me. My guess is that EnableEvents was set to false. I inserted a procedure in Workbook Open to set EnableEvents to True.
See if it works for you.
John

PS: I forgot to change the path back to your original path. Do that before you run.

**Bob@Sun** · 10-22-2009, 02:51 PM

Hi jaslake,

Thanks for taking your time to help me.

I guess you did not get me right.
The problem is that when the code copies the info from the Delivery Status file it does that from the cell A3/B3/C3/D3 - Date/Product1/Product2/Product3
And I need this data to be pasted in the other file but in different cells
A2/D2/F2/H2. As you can see in the example file Clients.xls, there is columns like E2,B2,E2 and G2 where different kind of info goes, and I do not wont the code to paste over that information.
Hope that is clear enough.

Any suggestion?

**jaslake** · 10-22-2009, 03:05 PM

Ah, I see. I'll look at that this afternoon.
J

**jaslake** · 10-22-2009, 03:52 PM

Hi Bob
Sorry for the earlier mix up. I completely misread your post. Try the attached and see if it works for you. Let me know if you have any issues.
John