Report with more than two criteria

[Juba]

hi all
i want help to get report with many criteria
i explain all what i want in shaeet " Report " in attachment file
http://www.zshare.net/download/518215947ee467e2/ (http://www.zshare.net/download/518215947ee467e2/)

[Bob Phillips]

Try this

[Juba]

thanx xld
it is great work
really it is very amazing work
u do it with out codes
just by using Formula
but there is Problem When there no action on the account name
the Cell "F7" give error "#Value!"
how i can solve it

[Bob Phillips]

Just change the formula in F7 to

=IF($H7="","",D7-E7)

[Juba]

Really many thanx to u xld
to hide the zero which appear on column D. Amount or C. Amount
the best way to use Conditional Formatting

[Bob Phillips]

No, just change the default option, Tools>Options>View, and uncheck the Zero values box in the Window options section.

[Juba]

okay thanx xld
i will try this file today
and i will tell u the result
and many many many thanx xld

[Juba]

Mr xld
i am sorry for all this Question
but
can we convert all this formula to VBA code
coz the formula make my sheets very slowly
i have more than 1500 rows
and it is increase evry day
can u help me in it

[Juba]

Please
i need this help

[Juba]

Mr xld
when i make print from the page it prints all the 3 pages which contain formula while the data which appear just three lines for example.
i make dynamic range start from cell a6 and use 7 columns
i names it DyRange
and i use this code
ActiveSheet.PageSetup.PrintArea = Range("DyRange").AddComment
ActiveWindow.SelectedSheets.PrintOut COPIES:=1, COLLATE:=True
But it is the same problem, it prints all sheet which contain Formula
can i find any help