Help with macro

J

jddonadio

Good evening:



Is it possible to insert a formula in the below listed MACRO. [Column D is
always a date. I need Column F to display a date 14 days greater]



Thanks in advance

John



Sub EnterGrievance()

'

' EnterGrievance Macro

' Macro recorded 2/25/2008 by John Donadio

'

' Keyboard Shortcut: Ctrl+c

'Range("A12").Select



Dim FromRng As Range

Dim ToRng As Range



With Worksheets("Data Sheet")

Set FromRng = .Range("A12:M12")

End With



With Worksheets("Grievance Log")

Set ToRng = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0)

End With



FromRng.Copy _

Destination:=ToRng



Sheets("Data Sheet").Select

Range("E19").Select

End Sub
 
B

Barb Reinhardt

I've answered this one place. You only need to post it once. If people
can't answer, they don't. I've asked some complicated questions here and
never gotten an answer. That is not the norm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top