If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I combine two queries from different worksheets
I need to combine information in two worksheets. The worksheets contain
similar information. Ie Both contain Item numbers and Item Descriptions but I need to see all the extra columns on one spreadsheet so I can see all the information connected to each item. |
#2
|
|||
|
|||
How do I combine two queries from different worksheets
Try this:
Make sure the workbook is saved (so MS Query can find it) and that both data lists are named ranges (eg rngList1, rngList2). Then.... Starting with an empty worksheet: 1)Select the cell where you want the consolidated data to start 2)DataImport External DataNew Database Query Databases: Excel Files Browse to the file, pick the 2 data ranges to import. ---Accept defaults until the next step. At The last screen select The View data/Edit The Query option. The 2 data lists should now be displayed in the query editor. Drag the Item Number field from one table to the Item Number field on the other table. Drag the Item Description field from one table to the Item Description field of the other table. Next, drag each field you want to see from the table to the lower section of the query editor. NOTE: Drag the Item Number and Item Description fields from only one of the tables. When the data looks right....Click the Return Data to Excel button. Let us know if you experience any issues. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jez838" wrote: I need to combine information in two worksheets. The worksheets contain similar information. Ie Both contain Item numbers and Item Descriptions but I need to see all the extra columns on one spreadsheet so I can see all the information connected to each item. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
combine multiple worksheets & files into 1 | Barb | Worksheet Functions | 3 | October 7th, 2005 11:43 PM |
how can I combine multiple worksheets into one? | Deb Bagby | Worksheet Functions | 1 | September 29th, 2005 04:34 PM |
How do I combine different worksheets into one book? | Madcat | New Users | 1 | September 13th, 2005 10:47 PM |
multiple SQL queries | yoyoh2ogirl | Running & Setting Up Queries | 5 | August 10th, 2004 09:18 PM |
Combine three worksheets | JerryB | Worksheet Functions | 4 | April 12th, 2004 10:25 PM |