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)