In A1 enter =IF(B1="","",B1)

Copy down column A as far as you wish.


Gord Dibben MS Excel MVP

On Thu, 25 Mar 2010 09:11:01 -0700, Daisy
wrote:

Can I link two columns to auto fill Column A when corresponding data is
entered in Column B?