date wise data required

[majidsiddique]

Hi all,

i would like to record in date wise in sheet2:
eg: A2 start date
A3 end date


between all the data extract both date in copy sheet2. in additional criteria transaction type: Cash or A/Payable
A3: Cash or A/Payable if any select

[TABLE="width: 596"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Purhas Date [/TD]
[TD]Bill No[/TD]
[TD]Vandor[/TD]
[TD]Item[/TD]
[TD]Qty[/TD]
[TD]Rate[/TD]
[TD]Amount[/TD]
[TD]Trasaction Type[/TD]
[/TR]
[TR]
[TD]02/08/2018[/TD]
[TD]1101[/TD]
[TD]Sultan Corp[/TD]
[TD]computer screen[/TD]
[TD]5[/TD]
[TD]12000[/TD]
[TD]60000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]02/08/2018[/TD]
[TD]1102[/TD]
[TD]Basit Traders[/TD]
[TD]laptop[/TD]
[TD]2[/TD]
[TD]14000[/TD]
[TD]28000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]02/08/2018[/TD]
[TD]1103[/TD]
[TD]Aladin Traders[/TD]
[TD]printer[/TD]
[TD]1[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]02/08/2018[/TD]
[TD]1104[/TD]
[TD]Vass Mac[/TD]
[TD]ink remover[/TD]
[TD]4[/TD]
[TD]4000[/TD]
[TD]16000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]02/08/2018[/TD]
[TD]1105[/TD]
[TD]Floppy Traders[/TD]
[TD]disk reader[/TD]
[TD]5[/TD]
[TD]8000[/TD]
[TD]40000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]03/08/2018[/TD]
[TD]1107[/TD]
[TD]Basit Traders[/TD]
[TD]frank remover[/TD]
[TD]8[/TD]
[TD]9000[/TD]
[TD]72000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]03/08/2018[/TD]
[TD]1112[/TD]
[TD]Floppy Traders[/TD]
[TD]fans[/TD]
[TD]3[/TD]
[TD]10000[/TD]
[TD]30000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]04/08/2018[/TD]
[TD]2201[/TD]
[TD]Sultan Corp[/TD]
[TD]screen 3.5 inch[/TD]
[TD]5[/TD]
[TD]8000[/TD]
[TD]40000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]04/08/2018[/TD]
[TD]4401[/TD]
[TD]farooq interprises[/TD]
[TD]LED[/TD]
[TD]8[/TD]
[TD]11000[/TD]
[TD]88000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]04/08/2018[/TD]
[TD]5501[/TD]
[TD]Sultan Corp[/TD]
[TD]fax[/TD]
[TD]10[/TD]
[TD]5000[/TD]
[TD]50000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]06/08/2018[/TD]
[TD]1201[/TD]
[TD]farooq interprises[/TD]
[TD]laptop[/TD]
[TD]8[/TD]
[TD]7000[/TD]
[TD]56000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]06/08/2018[/TD]
[TD]1305[/TD]
[TD]Basit Traders[/TD]
[TD]screen 4.5 inc[/TD]
[TD]4[/TD]
[TD]8000[/TD]
[TD]32000[/TD]
[TD]cash[/TD]
[/TR]
[TR]
[TD]06/08/2018[/TD]
[TD]1408[/TD]
[TD]Sultan Corp[/TD]
[TD]disk 5.1[/TD]
[TD]5[/TD]
[TD]9000[/TD]
[TD]45000[/TD]
[TD]A/Payable[/TD]
[/TR]
[TR]
[TD]06/08/2018[/TD]
[TD]1509[/TD]
[TD]Basit Traders[/TD]
[TD]remover link pad[/TD]
[TD]2[/TD]
[TD]10000[/TD]
[TD]20000[/TD]
[TD]cash[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

@ majidsiddique

Post #3 provides a formula approach. If it's not what you want, simply ignore it. Next time around please try to be explicit about the sort of solution you would want.

Regards