Excel; How can I use Query to create lists from separate workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have 5 worksheets in 1 workbook with purchasing data in them. The sheets have some different fields, but all contain a Filing No, Date, Vendor Name, Description, Department No, Account No, and Amount.

I would like to pull the above information and place it into a master list based on Department No. and Account No. criteria (Ex; If (DepartmentNo=431110 and AccountNo=560420) = True, then insert into list)

I thought that creating a database query was a promising solution. Unfortunately I cannot get it to work. I can get query to properly pull entries from a single sheet. When I include the other sheets in the query, it tells me that the tables cannot be linked and I must do it manually. I am stuck after this point. I have tried reading the help files on query but I do not understand what I need to do to get this to work.

Some others tried to help me by providing me with VB code, but I am not experienced enough to be able to manipulate it to match what I am trying to do.

I really would appreciate any help you can give me! Thank you!
 
I think you will find it much easier to copy/paste into a single tabl
and use a pivot table or whatever
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Query setup 0
save each sheet of a workbook as its own workbook 3
Simple internal database query in Excel 2007 2
Merge Multiple workbook sheets into one workbook 0
Query criteria from Excel workbook 2
Is it possible to use MS query to query the dta in same sheet 2
How to extract email addresses from 1 worksheet to another workbook 11
Can't create a report from my query in Access 1

Back
Top