S
seto
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 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!