Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Query Updating Question | Excel Discussion (Misc queries) | |||
Query Editor question | Excel Discussion (Misc queries) | |||
MS Query question | Excel Worksheet Functions | |||
Web Query question | Excel Discussion (Misc queries) | |||
Web Query Question | Excel Discussion (Misc queries) |