Automatically enter data into a cell based on another's cell value

VWRSue · Jul 8th 2020

Hello. I would like Excel enter data from one cell into another cell, based on another cell's entry. For example, I have a date in column A, in column B, there will either be a date entered, or n/a. If column B is n/a, then I would like Excel to take the date in column A and enter it into column C. If column B is a date, then I want to enter data into Column C myself. Is this possible?

**alansidman** · Jul 8th 2020

Code

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
Dim trow As Long
If Target.Column = 2 Then
If Target = "n/a" Then
trow = Target.Row
Range("C" & trow) = Range("A" & trow)
Range("C" & trow) = Format(Range("C" & trow), "short date")
End If
End If


End Sub

Display More

audreyvega · Aug 5th 2020

This worked perfectly! That I didn't though about this earlier, Thanks!

Automatically enter data into a cell based on another's cell value

Participate now!

Share

Users Viewing This Thread