Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update a spreadsheet with new information.
My problem deals with data. I obtain data from my company database and copy
the information onto Excel spreadsheet. There are about 6 columns with the last column being labeled the "Notes" column because that's where I track and leave notes on how things are going with each item. The PROBLEM is that our database is constantly being updated with new information. Thus I am forced to either create an entirely new spreadsheet and sit there re-entering my "Notes" information for each item OR to go through my original spreadsheet and compare it to the new one to find deleted items, added items, changes to specs..due dates..etc. of items. Basically I spend a lot of downtime re-entering information and reviewing old data. Is there any way I can update the data without having to constantly use new spreadsheets and having to re-enter information? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto update of cell information | Excel Discussion (Misc queries) | |||
Automatic update of information in a spreadsheet | Excel Discussion (Misc queries) | |||
Can I total information in 1 spreadsheet from several others? | New Users to Excel | |||
Using multiple spreadsheet for different information | Setting up and Configuration of Excel | |||
How do I set up an excel spreadsheet to update every time a user . | New Users to Excel |