Excel Fill cells automatically

Microsoft Office excel 2007
November 29, 2010 at 08:14:37
Specs: Windows XP
I am sure this is easy but today I am not feeling so smart. I need to auto fill cells with data entered in other cells, i.e. anything entered in column A needs to copied to the corresponding row in column F. Thanks

See More: Excel Fill cells automatically

Report •

November 29, 2010 at 10:30:31
In F1, put =A1, then drag it down.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

November 29, 2010 at 10:51:16
Thanks that helps. Is there a way to force that to all cells in the column so as news cells are populated it will continue to fill the other column?

Report •

November 29, 2010 at 11:29:43
There are 2 ways to automate the process:

1 - Obviously, you could drag the formula down beyond the existing data so that the formula is "waiting" for Column A to be populated. There's an option to hide zero values so the cells would be blank until Column A was populated.

Since the show/don't show Zero Values option is for the whole sheet, that might be an issue if you need to see some zero values but don't want to see them in Column F.

In that case, you could an IF function in Column F. Read up on the IF function in Excel help to see how it works.

=IF(A1 <> "", A1, "")

2 - If you don't want a bunch of formulas filling Column F waiting for input in Column A, you could use a WorksheetChange macro:

Private Sub Worksheet_Change(ByVal Target As Range)
'Was change made to Column A?
  If Target.Column = 1 Then
'If yes, then populate Column F with the value from Column A
    Range("F" & Target.Row) = Target
  End If
End Sub

Whenever a change is made to Column A, the corresponding cell in Column F will show the same value.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •

Related Solutions

Ask Question