Thread: Really would appreciate some help with my macro!

Hi there. Can anyone please help me with this, sure it wouldn't take more than a minute.

Have 2 data sheets.

First sheet is full of info.
Reads
A B C D E F G H I J K L M with data down to maybe 1000 entries (varies)

I want to create a macro which creates the following in a new sheet.
C2 F2
C2 G2
C2 H2
C2 I2
C3 F3
C3 G3
C3 H3
C3 I3
C4 F4 etc
until it loops to an end field which I can set myself (just in case of blank entries at some point).

Any help would be greatly appreciated.