Copy & Paste Range Using VBA Macro

[bloodmilksky]

Hi Guys,

I was wondering if anyone can help me as I dont know if this is possible. I was wondering if anyone knows can use VBA to :

1. Copies values from Sheet 1 A1,A2,A3,B1,B2,B3,C1,C2,C3 into E11:E14
2. Then Copies this range E11:E14 into Sheet 2 A1:L1000
3. But each time it did copy would move along one ranges worth so the new range wouldnt be over written.once it reached J1:L4 it would move to the next line A5:C8 and so on
4. This would be using a macro button.

Please if you have any questions let me know

really appreciate any help

Many thanks

Bloodmilksky

 

[Norie]

Can you clarify exactly what you want to do?

For example how can 9 values ( A1,A2,A3,B1,B2,B3,C1,C2,C3) be copied into 4 cells?

 

[bloodmilksky]

Thats my bad for multitasking it should be 9 values in to e11:g14 really sorry

 

[bloodmilksky]

the end goal is to create a holiday request form based soley on requests copying and pasting each request onto sheet 2 and then should the date range submitted confilict with any previous request it will return a yes or no message. does this make sense?

 

[Norie]

It kind of makes sense but the ranges still don't seem right, perhaps I'm missing something.

 

[bloodmilksky]

so A1,A2,A3,B1,B2,B3,C1,C2,C3 would form a request and then once entered these values would appear in for example E10:G12

this range would then be copied on to Sheet 2