Linking columns for auto fill

D

Daisy

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

Gord Dibben

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

Copy down column A as far as you wish.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Passwords 2
Fill handle fill down alternative methods question 2
Custom List Auto Fill Question 4
Fill without formatting 1
How do I auto populate a column with information from another colu 2
auto fill 2

Top