Auto update another cell upon data enter

**zonexs123** · 03-14-2012, 01:58 PM

Hello Experts,

This is my first post in this forum. I am stuck with one of a problem in excel. I have a sheet where some data has been added frequently. I have a column E in which I have to add the "Received Date". I have another column F for "Status" & column G for "Total" which is a formula field.

What I want that whenever I fill the date in column E, It will update Column F & G with data "Completed" & "Total" value respectively without copying it and pasting manually.

As I am new to excel function & logic..even handle VBA little bit, please help me out here accordingly.

I have also attached an sample file ......

Thanks in advance.

Santosh

**DGagnon** · 03-14-2012, 02:02 PM

Welcome to the Forums, i would be glad to help you with this, give this a try.

In column F use this formula

=IF(E2<>"","Completed","")

and in G use this

=IF(E2<>"",C2+D2,"")

**roki4** · 03-14-2012, 05:01 PM

Ya, that would do it assuming amount 1, 2, and the date are entered manually.

**jaslake** · 03-14-2012, 07:47 PM

Hi Santosh
Try this code in the attached

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Target.Column = 5 Then Exit Sub
    If Not Target = "" Then
        Target.Offset(0, 1) = "Completed"
        Target.Offset(0, 2) = Target.Offset(0, -1)
    End If
End Sub

Let me know of issues.