Web Query Question
 

I'm updating sports scores in excel 2002, The first set of Columns Are the
Team Names and the Final Score of the Game (These 2 columns update after each
game). My other 2 columns are used for notes and other information. When
ever I refresh the data, the first 2 sets of columns update, however the
notes for the game stays in the same place. How do I get my other 2 columns
to move down the page with the old scores. Please help, because this is
driving me crazy! If I need to explain further Please dont hesitate to ask!!
Thank you, Matt

Web Query Question
 

Thu, 20 Dec 2007 13:22:00 -0800 from SoflyMatt
:
I'm updating sports scores in excel 2002, The first set of Columns Are the
Team Names and the Final Score of the Game (These 2 columns update after each
game). My other 2 columns are used for notes and other information. When
ever I refresh the data, the first 2 sets of columns update, however the
notes for the game stays in the same place. How do I get my other 2 columns
to move down the page with the old scores.

It sounds like you didn't specify enough columns in your Data | Sort
operation. You need to highlight the whole table, not just the
columns that contain the sort keys, before clicking Data | Sort.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Web Query Question
 

Hard to tell without seeing. Send a workbook to my private address below, if
you like.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SoflyMatt" wrote in message
...
I'm updating sports scores in excel 2002, The first set of Columns Are
the
Team Names and the Final Score of the Game (These 2 columns update after
each
game). My other 2 columns are used for notes and other information. When
ever I refresh the data, the first 2 sets of columns update, however the
notes for the game stays in the same place. How do I get my other 2
columns
to move down the page with the old scores. Please help, because this is
driving me crazy! If I need to explain further Please dont hesitate to
ask!!
Thank you, Matt