Software

Ask something
Discussion Locked

Track changes in excel 2002

0 helpful
5 replies

by mckay_mark

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hopefully someone can help me. I have a user who has an excel spreadsheet that is used for tracking customer orders. He has a macro that clears the data in certain columns at the beginnig of everyday. Just recently he has been asked to have the data that would normally be deleted stored for reference (ie: a customer calling to find out what they had ordered on a specific date). Is there a macro or some other way to get excel to copy this data to another sheet or workbook? Thanks!!

5 replies

by pr0x1

There are many ways to accomplish this.

1) The easiest is to create a simple macro that prompts the user to save the file as another name as soon as it is opened. You can even open the file read-only so they have to save it as another name. Create a naming and/or versioning scheme for the file to track your changes.

2) You can also use the SelectCurrentRegionSelect funciton to select the data, or hard code the cell range, copy it, and then open an archive excel file and paste it to the end of the file or on a new tab in that file and save it there before the data is deleted, OR after just before the file is closed.

These are just two ideas off the top of my head, again, there are many others.
Hope this helps.

This discussion is closed to new replies.