Change Status When Column Filled

[Liyanacomel]

Hello, i have a data need to be fill when ever i made a progrees. Each column are fill with date the progress made. Is it possible for me to made the last column to state the current progress based on the last column that has been filled with the date? i wanted at the current progress column automatically change status when it being filled With the dates.

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

When you enter any value in column 2 to 7 the script will run

Private Sub Worksheet_Change(ByVal Target As Range)
    'Modified  6/17/2022  11:26:45 PM  EDT
    Select Case Target.Column
        Case 2: Target.Offset(, 6).Value = "Sign Up Project"
        Case 3: Target.Offset(, 5).Value = "Contact Pick"""
        Case 4: Target.Offset(, 4).Value = "Submit The Report"
        Case 5: Target.Offset(, 3).Value = "Made Report"
        Case 6: Target.Offset(, 2).Value = "Presenting Report"
        Case 7: Target.Offset(, 1).Value = "Project Finished"
End Select

End Sub

 

[Liyanacomel]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

When you enter any value in column 2 to 7 the script will run

Private Sub Worksheet_Change(ByVal Target As Range)
    'Modified  6/17/2022  11:26:45 PM  EDT
    Select Case Target.Column
        Case 2: Target.Offset(, 6).Value = "Sign Up Project"
        Case 3: Target.Offset(, 5).Value = "Contact Pick"""
        Case 4: Target.Offset(, 4).Value = "Submit The Report"
        Case 5: Target.Offset(, 3).Value = "Made Report"
        Case 6: Target.Offset(, 2).Value = "Presenting Report"
        Case 7: Target.Offset(, 1).Value = "Project Finished"
End Select

End Sub

Thank you! what if the data was in google sheet. How do i apply this coding .? What should i do or find.

 

[My Aswer Is This]

Thank you! what if the data was in google sheet. How do i apply this coding .? What should i do or find.

I know nothing about Google Sheets