Copy and Pasting, offsetting and looping

Hi all,

I've recently started looking into automating some of my daily tasks through VBA, however with little to no previous experience apart from basic macros, I've hit a wall. I was wondering if anyone would be kind enough to help me on this problem which I am sure is very basic, however I'm having trouble with both the looping function and moving down a value through each loop.

Instead of embarrassing myself with my poor code thus far, what I want to do is as follows

Sheet 1 Select
Copy selection from Column A4 (+1)
Sheet 2 Select
Paste Value into column B2 - 4 times
Repeat for second value in Sheet 1 (A5) into next blank row in Sheet 2 (B6)
Loop till blank value in first sheet

Sheet 1 Select
Copy first value from Column F4 (+1)
Sheet 2 Select
Paste Value into column I2 - 4 times
Repeat for second value in Sheet 1 (F5) into next blank row in Sheet 2 (I6)
Loop till blank value in first sheet

Sheet 1 Select
Copy first value from Column J4 (+1)
Sheet 2 Select
Paste Value into column N2 - 4 times
Repeat for second value in Sheet 1 (J5) into next blank row in Sheet 2 (N6)
Loop till blank value in first sheet




so as you see basically the same function for different columns.

Any help/guidance explaining the code would be greatly appreciated.

Thanks!

MB

This has been answered elsewhere!

If anyone has the same problem :

http://www.mrexcel.com/forum/excel-q...ml#post3819889