Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping web query cells attached to other data.
I am pretty sure that this is possible but can't quite figure out how to do
it and am not very literate in Excel. Here is my problem. I am importing data using a web query and every time I update it the information changes. For instance, this is what it looks like originally. TEAM PRICE Duke $144.81 USC $100.31 The order of the information in the web query changes depending on the price. So if USC's price becomes greater than Duke's the next time I update it would look like this: TEAM PRICE USC $147.88 Duke $144.81 This is where I run into my problem. The query uses columns A-G. I have information that I put in in columns I-M that needs to stay attached to each particular team. Example: (QUERY INFO) (MY INFO) TEAM PRICE WINS Games Played Duke $144.81 6 8 USC $100.31 5 9 When the query updates and the information changes order, I need the other information to change order with them so that the wins and games played stay in the same row as the team they are supposed to be with. Somebody mentioned using the VLOOKUP formula to somehow like them together but from what I have been reading, to use that formula you have a unique number or name in the first column but I don't have that with the information that the web query pulls in. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping web query cells attached to other data.
How is the Wins/Games Played linked to the query? Or do you just have it next
to the query data? You could setup the Wins & Games played on another sheet, say in columns C & D. Put the names of the teams in Column A. For column B, you 'could' do something like: =sumif(SheetWithQuery!A:A,A2,SheetWithQuery!B:B) Although I'm sure there's a better way of writing a formula to do that, hopefully it gives you some ideas. -- Best Regards, Luke M "auctionking105" wrote: I am pretty sure that this is possible but can't quite figure out how to do it and am not very literate in Excel. Here is my problem. I am importing data using a web query and every time I update it the information changes. For instance, this is what it looks like originally. TEAM PRICE Duke $144.81 USC $100.31 The order of the information in the web query changes depending on the price. So if USC's price becomes greater than Duke's the next time I update it would look like this: TEAM PRICE USC $147.88 Duke $144.81 This is where I run into my problem. The query uses columns A-G. I have information that I put in in columns I-M that needs to stay attached to each particular team. Example: (QUERY INFO) (MY INFO) TEAM PRICE WINS Games Played Duke $144.81 6 8 USC $100.31 5 9 When the query updates and the information changes order, I need the other information to change order with them so that the wins and games played stay in the same row as the team they are supposed to be with. Somebody mentioned using the VLOOKUP formula to somehow like them together but from what I have been reading, to use that formula you have a unique number or name in the first column but I don't have that with the information that the web query pulls in. Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping web query cells attached to other data.
The wins and games played aren't linked to the query. I manually enter that
data and need it to be attached to the team information that refreshes in the query. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping cell data with records from a query | Excel Discussion (Misc queries) | |||
how to merge many cells to one cell with keeping all data | Excel Worksheet Functions | |||
keeping cells aligned when data is updated | Excel Worksheet Functions | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) |