VBA for Data Archiving

[excel1989]

I have an excel spreadsheet that lists equipment to be calibrated. The equipment date is updated every time the equipment item is calibrated. Usually every 6 months. I would like to archive all of the previous dates the calibration was completed in a separate sheet as the date is changed for the current calibration.

I am looking for a macro to automatically do this for me. Can someone please help.

Thank you.

[arlu1201]

Sure, it will be good if you explain with the help of an excel sample file.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.