I finally figured out how to connect a range of cells in excel 2007 to my website MySql database table and i have it querying the correct records.

I also needed to have some cells that are adjacent to the data connection records that will resort when the data when using the filter option.

My "MySql" data is in the F thru AK columns. I have some fields in the A thru E columns that i write pertinent information about the data retrieved but I cant apply the filter across all the ranges. Excel just wont let me. Is there any way i can link those "A thru E" columns to the Data Connection columns so resort doesn't get out of whack?

I really appreciate any advice.

thanks,

Mark