Enzo_Matrix
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 113
I have 4 invoices across multiple sheets (new sheet added monthly) and I want to create a master sheet with all part numbers on it.
So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the sheets that have the part number?
Example:
Items:
a,b,c,d
Invoice:
1 - a,d
2 - a,b
3 - c
4 - b,c
so, something along the lines of:
IF(a is on invoice 1, pull cost, else go to invoice 2, else go to invoice 3, else go to invoice 4)
VBA is an option.
So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the sheets that have the part number?
Example:
Items:
a,b,c,d
Invoice:
1 - a,d
2 - a,b
3 - c
4 - b,c
so, something along the lines of:
IF(a is on invoice 1, pull cost, else go to invoice 2, else go to invoice 3, else go to invoice 4)
VBA is an option.