Macro to loop untill zero value

Hi,
I am need of some assistant, please could some help out.

I have recorded a macro but how do i make loop over and over until it get 0 value.

In MULTI LINE sheet there is a button which user press to activate macro.

as the button is pressed information from MULTI LINE BREAK DOWN sheet is copied over to PREVIEW MULTI LINE LABEL sheet

Example - MULTI LINE BREAK DOWN sheet row2
Column A - goes to cell A2 in PREVIEW MULTI LINE LABLE
Column B - goes to cell B3 in PREVIEW MULTI LINE LABEL
Column C - goes to cell A1 in PREVIER MULTI LINE LABEL

Example - MULTI LINE BREAK DOWN sheet row3
Column A - goes to cell E2 in PREVIEW MULTI LINE LABLE
Column B - goes to cell F3 in PREVIEW MULTI LINE LABEL
Column C - goes to cell E1 in PREVIER MULTI LINE LABEL

In short
ROW2 Info goes to Left Hand side
ROW3 Info goes to Right Hand side
move down
ROW4 Info goes to Left Hand Side
ROW5 Info goes to Right Hand Side

My MACRO codeing is

Please Login or Register  to view this content.

This codeing is up to 6 rows. In MULTI LINE BREAK DOWN sheet i can have to 60,80,130,etc rows worth of information. In this sheet column A has zero value then it should stop.

Can someone please assist me. any help would be appricated.

I have attached file.

Hi
try the macro in the attached file
Ravi

See if this points you in the right direction

Please Login or Register  to view this content.

VBA Noob

Hi VBA Noob,

I pasted your solution, but error highlighted the line below.

Please Login or Register  to view this content.

Many thanks for helping get through my problem.

Warm Regards

Try amended code

Please Login or Register  to view this content.

VBA Noob