Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Dear All,
hoping you can help me... actually it will easier if i use project professional, but my manager said i should use excel. A(Activity) B (Target) C(Start) D(Finish) E(Realization) In depth survey 500 respondent what i want to achieve, when i input in column E(realization), the start date will automatically fill with the input date and when they input 500 respondent in column E, the finish date will automatically input date. (like microsoft project)... need your guidance to achieve this...pleaseeee.... so many thanks reza |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Reza,
Right-click the sheet tab, select "View Code" and paste the code into the window that appears. I assumed that the entry of 500 is an actual number, not a string, but that can be changed if needed. HTH, Bernie MS Excel MVP Private Sub Worksheet_Change(ByVal Target As Range) 'Limit to single cells in column E If Target.Cells.Count 1 Then Exit Sub If Target.Column < 5 Then Exit Sub Application.EnabeEvents = False If Target.Value = 500 Then If Cells(Target.Row, 4).Value = "" Then Cells(Target.Row, 4).Value = Date End If Else If Cells(Target.Row, 3).Value < "" Then Cells(Target.Row, 3).Value = Date End If End If Application.EnabeEvents = True End Sub "reza" wrote in message ... Dear All, hoping you can help me... actually it will easier if i use project professional, but my manager said i should use excel. A(Activity) B (Target) C(Start) D(Finish) E(Realization) In depth survey 500 respondent what i want to achieve, when i input in column E(realization), the start date will automatically fill with the input date and when they input 500 respondent in column E, the finish date will automatically input date. (like microsoft project)... need your guidance to achieve this...pleaseeee.... so many thanks reza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |