Associating database updated cells with user entered cells

craigyg

Board Regular
Joined
Dec 14, 2005
Messages
114
They should call you Dr. Excel. Your posts have been very helpful to me at work! Anyway, here it is:

The Situation:
I have several spreadsheets I created at my job to track different values associated with courses that my company runs. The typical layout is a column with the course name, one with enrollment numbers, one with course status, etc. The columns on the left side of the spreadsheet update through a query to our database. The columns on the right side of the spreadsheet are filled with data entered by different users. Here is my problem: When I refresh data from the database, sometimes the left side data changes order or has more or fewer elements (due to changes that occur from adding or deleting courses from our schedule). When this happens, the data on the right side that is user entered ceases to be lined up with the left side data that has suddenly changed order. In fact, sometimes it becomes impossible to remember what rows were associated with which courses., rendering the spreadsheet utterly useless as a tracking tool.

The Question:
How can I associate the database updated left side rows with the user entered right side rows so that they stay lined up when I hit "refresh data" in the "data" menu?

Your help is much appreciated. Thanks,

- Craig from Princeton, NJ [/b]
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Craig

If you put the user entered data onto a separate sheet, and make sure that it has a unique key that relates to the "database" data (say Course ID or Course Name) then you could use the VLOOKUP function to bring in the existing user entered data to match the database data.


HTH

Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,767
Members
412,291
Latest member
marypolitan
Top