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]
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]