Macro button to filter and display

[rizmomin]

This is complicated for me...Please help
Attach is the sheet for referance

There are 2 sheets
1. Sheet1 ....This contains business transaction..
2. Sheet2 where i want to display the transaction bu pressing
button in column E with the month in field F3. The fields
to be displayed are in Row 3 ,,,


Please help me doing 1 macro for the button and i will follow up
doing the rest.

Let me know if you have any questions.

Riz Momin

[Richard Buttrey]

This is complicated for me...Please help
Attach is the sheet for referance

There are 2 sheets
1. Sheet1 ....This contains business transaction..
2. Sheet2 where i want to display the transaction bu pressing
button in column E with the month in field F3. The fields
to be displayed are in Row 3 ,,,


Please help me doing 1 macro for the button and i will follow up
doing the rest.

Let me know if you have any questions.

Riz Momin

Why do you need any buttons? What would they achieve? If you're just wanting the record values then you could use the following formulae:

In L7

=SUMIF(Sheet1!G:G,Sheet2!D7,Sheet1!J:J)

and in H7

=INDEX(Sheet1!A:I,MATCH(D7,Sheet1!G:G,FALSE),3)

I've just shown the two since there weren't any field headings on sheet1 so it wasn't clear for instance which is the Payee field. However just adjust the references in the H7 cell for the other fields, and copy row 7 down to your 'button rows'
HTH

[rizmomin]

Thank you for your help.
But let me explain you what i am trying to accomplish and wants.

What i want is display all transaction for particular Catagory in Profit and Loss Statement..
This would only display 1 catagory detail at a time...


Please see attached sheet..

This is how i want to display when i press Button at E28 "COST OF GOODS:FSI".
Need VBA macro (we can assign Command Button) which will filter all entries for "COST OF GOODS:FSI" for Jan 08...from Sheet1 and display in Sheet2 as shown in attached sheet.

Next time if i press diff button then it should clear previous result and display for the selected catagory.



Please let me know if you have any questions...

I really aprreciate your help....

Riz Momin