Day book generation from other sheets

[kprabhupaul]

Dear All,

I will enter Data by Datewise in different sheets like Purchase entries in Purchases sheet, Sale entries in Sales sheet, Receipt entries in Receipts Sheet and so on ..

Now the required result/data is

if I input particular date,

It should return all the transactions on that date one by one with Date, Ref/Bill No, Description, Debit and Credit values.

Please find the photo and file attachment for named ranges and for better idea.

thank you very much in advance

[kprabhupaul]

Please brothers,

can anyone solve this problem ..?

Help be appreciated thank you

[cytop]

If it is that urgent then perhaps the Commercial Services forum might be more appropriate.

[kprabhupaul]

one friend given this formula for daybook!a3

=IFERROR(IF(ROWS($A$3:$A3)>COUNTIF(PURCHASES!$A:$A,$C$1),INDEX(SALES!A:A,SMALL(INDEX((SALES!$A$3:$A$1000<>$C$1)*10^10+ROW(SALES!$A$3:$A$1000),0),ROWS($A$3:$A3)-COUNTIF(PURCHASES!$A:$A,$C$1))),INDEX(PURCHASES!A:A,SMALL(INDEX((PURCHASES!$A$3:$A$1000<>$C$1)*10^10+ROW(PURCHASES!$A$3:$A$1000),0),ROWS($A$3:$A3)))),"")

but it is not reflecting results correctly .. (because I made few changes to doc)

::: thank you :::