exex-Large
New Member
- Joined
- Nov 8, 2005
- Messages
- 2
Hi,
I need help (many people have said that I do, hehehe). I have 3 workbooks containing 1 sheet in each.
Book1 has unique part numbers in column A, in a sheet called parts.
Book2 has part number, car and colour details in a sheet called details, and this sheet has duplicate entries of part number.
Book3 has a sheet called cost which has 2 columns, a car (unique) and cost.
I would like a formula to use each part number in Book1 to access all occurences of the part number in Book2. For each of the part numbers found in Book2 If the colour is equal to red use the car column to reference the car column in Book3 to determine the cost. Because there are multiple occurrences in Book2 the cost will have to be summed and placed in column B in the parts sheet in Book1.
Can I do this with a formula? if not would VBA be more advisable and if so would it be possible to give me an example of the code?
Please help, I am going mad with frustration.
Many thanks
Gary
I need help (many people have said that I do, hehehe). I have 3 workbooks containing 1 sheet in each.
Book1 has unique part numbers in column A, in a sheet called parts.
Book2 has part number, car and colour details in a sheet called details, and this sheet has duplicate entries of part number.
Book3 has a sheet called cost which has 2 columns, a car (unique) and cost.
I would like a formula to use each part number in Book1 to access all occurences of the part number in Book2. For each of the part numbers found in Book2 If the colour is equal to red use the car column to reference the car column in Book3 to determine the cost. Because there are multiple occurrences in Book2 the cost will have to be summed and placed in column B in the parts sheet in Book1.
Can I do this with a formula? if not would VBA be more advisable and if so would it be possible to give me an example of the code?
Please help, I am going mad with frustration.
Many thanks
Gary