data from large database

[subrosumon]

Hi Expert,
Apologies for consuming your valuable time.
I have a large Data base which is showing with Month as well as client.
(Following example Month, Client and amount)

I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be shown (as result bellow)
is it possible to use vlookup or any other formula?

Thanks in advance

[TABLE="width: 146"]
<colgroup><col width="64" style="width: 48pt;" span="2"><colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2327;"><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Database[/TD]
[TD="width: 64, bgcolor: transparent"]

[/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 1,200 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]CDF[/TD]
[TD="bgcolor: transparent"] 1,100 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]CDF[/TD]
[TD="bgcolor: transparent"] 500 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 400 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 200 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 1,200 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb-18[/TD]
[TD="bgcolor: transparent"]CDF[/TD]
[TD="bgcolor: transparent"] 2,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb-18[/TD]
[TD="bgcolor: transparent"]CDF[/TD]
[TD="bgcolor: transparent"] 4,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 3,000 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 2"]Result to be[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 1,200 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 400 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-18[/TD]
[TD="bgcolor: transparent"]ABC[/TD]
[TD="bgcolor: transparent"] 200 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] 1,800 [/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

How about using Data Filters?
If you use the Advanced Filters, you can return the results to another range.

 

[subrosumon]

Actually i am unable to VBA, filter is not serve my purpose, VLookup can be help if some are maching

 

[Joe4]

Filters are NOT VBA.
How do filters NOT serve your purpose? It sounds like pretty much exactly what you want to do. Normal Filters filter in place, but Advanced Filters can filter to a new location.
See here: https://www.contextures.com/xladvfilter01.html

Note that I think you can also use Pivot Tables to return the data that you want, but that would not do it in a new location (it would be in place).

 

[subrosumon]

Thanks, actually i want to inter my data in my database, then i want to prepared a payment voucher. My focus is voucher preparation. Filtering, pivot is other things as my present needs

 

[Joe4]

Where exactly is this database located?
This type of thing (limiting your data based on certain criteria) is actually very easy to do in most database programs (like Microsoft Access or SQL) using queries.
You can use a query to limit your data, and then base your payment voucher on the data in the query.