Lifecoachlee
New Member
- Joined
- May 2, 2014
- Messages
- 36
Hi everyone,
I need some help so badly!
Here's a sample of the project I am working on with.
Sheet 1
----------------------------------------------------------------------
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
----------------------------------------------------------------------------
<colgroup><col span="11"><col><col></colgroup><tbody>
</tbody>
Here's what I wanted to happen.
Month, Day and Site have their corresponding data validation list where you can pull up the records to display under the table above once criteria are met and automatically add the values of the same products of the same date.
Example:
I will select from the list the ff in the search criteria:
Month: May
Day: 5
Site: FOB MILL
It should display like this:
<tbody>
</tbody>AMSERCO 5-May-14 1200 1500
CALOSUY 5-May-14 500
Please help. Thank you!
I need some help so badly!
Here's a sample of the project I am working on with.
Sheet 1
----------------------------------------------------------------------
DATE | DEALER | PICKUP SITE | PRODUCT | QUANTITY |
1-Apr-14 | ACAPARROS | EX-PASIG | L.LAPU | 300 |
2-Apr-14 | CALOSUY | EX-PASIG | L.LAPU | 200 |
3-Apr-14 | AMSERCO | FOB MILL | ELEF. | 500 |
12-Apr-14 | ASIATIC | EX-PASIG | L.LAPU | 700 |
16-Apr-14 | ACAPARROS | EX-PASIG | ELEF. | 1500 |
1-May-14 | ASMART | EX-PASIG | ELEF. | 1500 |
2-May-14 | ASMKTG | EX-PASIG | G.HARV. | 1500 |
3-May-14 | CALOSUY | EX-PASIG | S.BLEND | 300 |
4-May-14 | AMSERCO | FOB MILL | L.LAPU | 200 |
5-May-14 | AMSERCO | FOB MILL | L.LAPU | 500 |
5-May-14 | AMSERCO | FOB MILL | L.LAPU | 700 |
5-May-14 | AMSERCO | FOB MILL | G.HARV. | 1500 |
5-May-14 | CALOSUY | FOB MILL | S.LORD | 500 |
13-May-14 | AMSERCO | FOB MILL | ELEF. | 300 |
20-May-14 | AMSERCO | FOB MILL | L.LAPU | 300 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
----------------------------------------------------------------------------
MONTH: | APRIL | DAY: | SITE: | EX-PASIG | ||||||||
DEALER | DATE | L.LAPU | ELEF. | ORO EX. | G.HARV. | S.LORD | S.BLEND | A.PURP. | S.NOODLE | S.GODD. | C.TAIL | E.DRAGON |
<colgroup><col span="11"><col><col></colgroup><tbody>
</tbody>
Here's what I wanted to happen.
Month, Day and Site have their corresponding data validation list where you can pull up the records to display under the table above once criteria are met and automatically add the values of the same products of the same date.
Example:
I will select from the list the ff in the search criteria:
Month: May
Day: 5
Site: FOB MILL
It should display like this:
DEALER | DATE | L.LAPU | ELEF. | ORO EX. | G.HARV. | S.LORD | S.BLEND | A.PURP. | S.NOODLE | S.GODD. | C.TAIL | E.DRAGON |
<tbody>
</tbody>
CALOSUY 5-May-14 500
Please help. Thank you!