Hello,
I have been working on this formula for the past few days and it is just not working at all, please help?
In sheet 1 - in column A, I input dates from Sheet2 and Sheet3 and insert the desire formula in C2-C9 it should pull in the invoice# and the quantities in D2-C9 from sheet2 and sheet3.
Sheet1
<tbody>
</tbody>
Sheet 2 (Report) Only the last 3 business days of the monh
Criteria: Product and Date
<tbody>
</tbody>
Sheet 3 (Report 2) All info related to the May
Criteria: Product and Transaction Type
<tbody>
</tbody>
Thank you.
I have been working on this formula for the past few days and it is just not working at all, please help?
In sheet 1 - in column A, I input dates from Sheet2 and Sheet3 and insert the desire formula in C2-C9 it should pull in the invoice# and the quantities in D2-C9 from sheet2 and sheet3.
Sheet1
A | B | C | D | Helper Column for Sheet 3 | |
1 | Date | Product | Invoice | QTY | |
2 | 04/26/18 | 01234 | |||
3 | 04/27/18 | 01234 | |||
4 | 04/30/18 | 01234 | YYY123 | 200 | |
5 | 04/30/18 | 01234 | AC1234 | 100 | |
6 | 04/30/18 | 01234 | WC5678 | 1000 | |
7 | 05/01/18 | 01234 | AE2222 | 100 | 3rd Party Purchase |
8 | 05/03/18 | 01234 | AG3333 | 30 | Shipped |
9 | 05/04/18 | 01234 | BU5555 | 50 | Received |
10 | 05/04/18 | 01234 | WE6666 | 1000 | Received |
<tbody>
</tbody>
Sheet 2 (Report) Only the last 3 business days of the monh
Criteria: Product and Date
A | G | N | P | U | Y | |||||||||||||||||||||
Month | Product | Product Description | Invoice# | QTY | Date | |||||||||||||||||||||
1 | 04/30/18 | 01234 | Blah | TU1452 | 120 | 04/01/18 | ||||||||||||||||||||
2 | 04/30/18 | 01234 | Blah | AB1111 | 154 | 04/15/18 | ||||||||||||||||||||
3 | 04/30/18 | 01234 | Blah | 22222 | 50 | 04/26/18 | ||||||||||||||||||||
4 | 04/30/18 | 01234 | Blah | 22222 | -50 | 04/26/18 | ||||||||||||||||||||
5 | 04/30/18 | 01234 | Blah | YYY123 | 200 | 04/30/18 | ||||||||||||||||||||
6 | 04/30/18 | 01234 | Blah | AB1234 | 100 | 04/30/18 | ||||||||||||||||||||
7 | 04/30/18 | 01234 | Blah | WC5678 | 1000 | 04/30/18 |
<tbody>
</tbody>
Sheet 3 (Report 2) All info related to the May
Criteria: Product and Transaction Type
F | K | L | N | S | ||||||||
Product | Transaction Type | Date | Invoice# | QTY | ||||||||
1 | 01234 | 3rd Party Purchase | 05/01/18 | AE2222 | 100 | |||||||
2 | 01234 | Shipped | 05/03/18 | CB4444 | 20 | |||||||
3 | 01234 | Shipped | 05/03/18 | CB4444 | -20 | |||||||
4 | 01234 | Shipped | 05/03/18 | AG3333 | 30 | |||||||
5 | 01234 | Received | 05/04/18 | BU5555 | 50 | |||||||
6 | 01234 | Received | 05/04/18 | WE6666 | 1000 |
<tbody>
</tbody>
Thank you.
Last edited: