I have created a data page in excel. This page has lots of data which will be updated everymonth.



Now, everymonth I retype the new data in and lost those old data.

Is there anyway you can keep old data and be able to update it at the same time in excel?

I have told that this could be solved by VBA or acess. But I'd like to do it in excel....

Anyone has ideas?

I would investigate Data tab > Sort & Filter group > Filter

You can easily hide stuff without deleting the data