From: Daisy on
Can I link two columns to auto fill Column A when corresponding data is
entered in Column B?
From: Gord Dibben on
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 <Daisy(a)discussions.microsoft.com>
wrote:

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