Hi,

In sheet1 I have Row 7 as header. From row 8 there is data.
In header have items in columnB, quantity in columnF, channel in
columnH & date in column I.


I want a routine which will give me a summary in sheet2 based on
channel selected and start/end date.
--------------------------------------------
Channel:<Select
Start Date:<Select
End Date:<Select


Items Quantity
A 10
B 30
C 60
D 90
E 80
F 70
--------------------------------------------

The quantity is sum of quantity date wise/channel wise.