Hi...

Can anyone help me to prepare a macro for repeat function till the reference column has a data.

To illustrate, if a cell of (column-1 of worksheet-1) has a number, the number needs to be referred in worksheet-2 for analysis and the result shall be copied back in a column-2 assigned in worksheet-1. This function shall be repeated till column-1 has data cells.

I am looking for a macro which can repeat the said function till it finds a data in column-1.

Looking forward for a solution as soon as possible.

Thanks

Kanagaraj