Solved

Add date to cell when another function is completed

Posted on 2014-04-22
3
205 Views
Last Modified: 2014-04-22
I have a workbook (attached and scrubbed) that when I put a value in Col N (Funds Rcvd) AND when there is a value in Col K (USC MC) a function is kicked off.

What I need is that after this function is completed today's date gets input into Col P (Sent for Processing)

ApplicantStatus-Scrubbed.xls
0
Comment
Question by:mabehr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40014931
Hi,

I suppose you are talking of this part of the code ( see my addition at line 6

    If Range("N" & Target.Row) <> "" And _
        Range("K" & Target.Row) <> "" Then
        If MsgBox("Reply Mail for " & Cells(Target.Row, "C") & ", " & Cells(Target.Row, "B") & " as USD amount entered ?", vbQuestion + vbYesNo, "Send Email") = vbYes Then
            fName = CreateNewCardLoad(Range(Cells(Target.Row, "A"), Cells(Target.Row, "T")))
            SendEmail Range(Cells(Target.Row, "A"), Cells(Target.Row, "T")), Cells(Target.Row, "O"), fName
            Cells(Target.Row, "P") = Date ' my Addition
            Exit Sub
        End If
    End If

Open in new window

Regards
0
 

Author Comment

by:mabehr
ID: 40015161
Thanks, Rgonzo1971. I'll be back in the office later today and will try it out then.
0
 

Author Closing Comment

by:mabehr
ID: 40016664
Worked perfectly, Rgonzo1971. Thank you.

Are you interested in solving another situation I have?
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question