Hi All,

I am by no means an Excel guru, though I would imagine there MUST be a fairly simple way to achieve the following:

I have used MSQuery (ODBC) to pull about 4 fields from our Company's system into Excel (2007). Adjacent to the live fields are comments fields (static).
If the status of one of the live records changes and it therefore 'drops-off' the list in Excel, is there a way (EASIEST method possible, pls!) to ensure that the static data drops-off too?

Currently, when the list changes, the comments in the adjacent cells do not move, meaning that they are tied to the wrong records, which are changing constantly.

If anyone could shed some light I would be eternally grateful!

Many thanks in advance all, for your help