Seeking a simple matching exercise
[Users questions | Browse:38 | Favorites]
Users questions:I is for sales, customer inquiries received every day table, inquiry about close to 2000 or so, on the EXCEL workbook 1, and our inventory of all cargo on another EXCEL workbook 2, quotation of the goods is not all there, so they need a one query, whichLike too much work, so trying to find there is no convenient way to let workbook workbook 1 and 2 to match the data. Long as we can highlight the data in the workbook workbook 1 2 whether there is on the line, the results show in which no restrictions. Workbook in the two data can be moved as needed.
Experts answer: between the query and workbook workbook with a table within the inter-query formulas is the same, look at details. Attachment: query method. Xls
Experts answer: between the query and workbook workbook with a table within the inter-query formulas is the same, look at details. Attachment: query method. Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.