Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
output date modified if data is entered for multiple rows | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
Modified Date | New Users to Excel |