Display all values of the same date vertically

[Lifecoachlee]

Hi everyone,

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>

AMSERCO 5-May-14 1200 1500
CALOSUY 5-May-14 500



Please help. Thank you!

 

[Lifecoachlee]

Yes they are same, but we will use IvecBooking for it must be defined in terms of the already booking ranges.

Ivec is by the way an abbrev from integer vector.



Lrow is an abbrev of last row. LrowBooking is the current last row of the data area in the BOOKINGS sheet.

The following workbook contains the required definitions, not only involving BOOKINGS, but also WITHDRAWALS and ARRIVALS:
https://dl.dropboxusercontent.com/u/65698317/FLOUR%20MILL%20MARKETING%20SYSTEM%20v8%20dynamic.xlsm

Moreover, all of the formulas are adjusted to refer to the dynamic named ranges...

This is perfect! You are giving me a whole lot of walk through tutorials, Aladin.
You're amazing, brother!

 

[Aladin Akyurek]

This is perfect! You are giving me a whole lot of walk through tutorials, Aladin.
You're amazing, brother!

You're welcome. Thanks for kind feedback.