Journal Entries to Voucher.

[mabubakerali]

I am trying to automate some journal entries and i have this problem here, i want to select voucher type and voucher number in voucher sheet and i want excel to display all the entries from general journal in to that Voucher, to get better understanding i have attached the screen shots, please take a look at the screenshot of general journal and you can see that voucher type and voucher number has been written in column K and L respectively, while the data i want to appear on voucher written in O,P and Q , now take a look at the voucher screenshot, what i want is, i want to write the voucher type and voucher number, and i want excel to display all the entries related to that voucher type and number in column C and D in Voucher sheet as you can see in the voucher sheet that i made manually to help you understand better. Thanks