Excel loop to be worked across 3 sheets of a workbook.

[gvikrama]

Hi,

I am looking for an IF Then loop to work across 3 sheets in a workbook. I have a macro running on Sheet 1 to split the comma separated values in a particular cell (say B11), so that 1st value will be put in E11, 2nd value in F11 and this goes on till the last value entered in B11.

Now I want an IF Then loop to work so that,

==> it should first select E11 and check if it is empty, if not then should enter into the loop.
==> There is a formatted column set of 3 in Sheet 3. After identifying value in E11 of Sheet 1, macro should copy the 3 columns in Sheet 3 to A1 of Sheet 2
==> then copy the value in E11 of Sheet 1 to A2 of Sheet 2.

Now it should go to the next cell of E11 which is F11 and check whether it is empty and if not get on to the loop.

in the loop the column set from sheet 3 should be pasted to D1 of sheet2 and value in F11 of sheet 1 should be pasted to D2 of sheet 2

This should go on until an empty cell is identified in the 11th row of sheet 1

Can you please help me with the best way to implement this loop.