Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 11-18-2009, 01:22 PM
mtnguye9 mtnguye9 is offline Excel Database Windows XP Excel Database Office 97
Excel Database
Join Date: Nov 2009
Posts: 4
mtnguye9 is on a distinguished road
Default Excel Database

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?
Reply With Quote
Old 11-26-2009, 01:42 PM
zyzzyva57 zyzzyva57 is offline Excel Database Windows Vista Excel Database Office 2007
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road

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

You can easily hide stuff without deleting the data
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Database Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Excel Database Outlook: database creation was unsuccessful Pine Ridge Outlook 2 10-02-2009 10:42 AM
Excel to lookup Access Database PeterP Excel 1 06-11-2009 12:33 PM
Excel Database Access database engine with Streets and Trips 2009 dreemsnake Misc 3 05-26-2009 10:25 AM
Populate cells in Word from a database hotlilshan Word 3 12-09-2008 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd. is not affiliated with Microsoft