Solved

Add date to cell when another function is completed

Posted on 2014-04-22
3
201 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
  • 2
3 Comments
 
LVL 49

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

832 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