date modified
 

I have two sheets Data and Summary
The "data" sheets macro extracts data from external file and paste into
"Data" sheet

Everytime the m acro is run to get latest data...

The macro delete all contents of the "data" and then paste new data into the
"data" sheet.

Is there a way.. I can put a date on the "summary" sheet, when was the time
the macro was run ( or in other words.. the data updated)

date modified
 

This little macro records the date in the selected cell and formats it:

Sub Macro2()
Dim d As Date
Dim s As String
d = Now()
s = d
Selection.FormulaR1C1 = s
Selection.NumberFormat = "mm/dd/yy;@"
End Sub

If you always want the date to go in a certain cell, then select it in the
macro.
--
Gary''s Student


"flow23" wrote:

I have two sheets Data and Summary
The "data" sheets macro extracts data from external file and paste into
"Data" sheet

Everytime the m acro is run to get latest data...

The macro delete all contents of the "data" and then paste new data into the
"data" sheet.

Is there a way.. I can put a date on the "summary" sheet, when was the time
the macro was run ( or in other words.. the data updated)