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

Hi, did this solve your issue?

If NO, please comment.
If YES, please mark it as solved, see this link: http://www.msofficeforums.com/excel/announcements.html

Marking issues as solved makes this forum more effective!

Best regards
Bjorn