Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2009, 01:22 PM
mtnguye9 mtnguye9 is offline Excel Database Windows XP Excel Database Office 97
Novice
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
  #2  
Old 11-26-2009, 01:42 PM
zyzzyva57 zyzzyva57 is offline Excel Database Windows Vista Excel Database Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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

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

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.
MSOfficeForums.com is not affiliated with Microsoft