PDA

View Full Version : Report with more than two criteria



Juba
11-25-2008, 12:48 AM
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
11-25-2008, 03:11 AM
Try this

Juba
11-25-2008, 03:20 AM
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
11-25-2008, 03:49 AM
Just change the formula in F7 to

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

Juba
11-25-2008, 04:02 AM
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
11-25-2008, 04:05 AM
No, just change the default option, Tools>Options>View, and uncheck the Zero values box in the Window options section.

Juba
11-25-2008, 04:08 AM
okay thanx xld
i will try this file today
and i will tell u the result
and many many many thanx xld

Juba
11-25-2008, 07:32 AM
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
11-25-2008, 11:48 PM
Please
i need this help

Juba
11-29-2008, 06:57 AM
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