Loop to copy and paste cell values

Hi all, I would much appreciate any help on this..
I need to make a macro that will copy the contents of Sheet2!E1, go to Sheet1!C1, paste in c1,c2,c3,c4, then copy Sheet2!E2, then paste in Sheet1, cells c5,c6,c7,c8, then copy
Sheet2!E3 and paste into Sheet1, cells c9,c10,c11,c12, and continue until the next cell down in the E column of Sheet 2 is empty. Anybody think they can help me with this ?

prontrad,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar