ExcelBanter - Linking columns for auto fill

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Linking columns for auto fill (https://www.excelbanter.com/excel-discussion-misc-queries/259898-linking-columns-auto-fill.html)

Daisy

Linking columns for auto fill

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

Gord Dibben

Linking columns for auto fill

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?

All times are GMT +1. The time now is 02:45 AM.