Hi!

Here's your file:

http://s44.yousendit.com/d.aspx?id=1...T3L017NLNF6RFY

I added drop down lists so you can select the month, year and client name.
I "fixed" the date column so that only the days of the month that is
selected will be displayed.
I created an additional named range, Magazine. That should be self
explanatory!
I changed the Total formula.

Biff

"skarbanan" wrote in
message ...

Yes...here is the sample...
I got very frustrated because it seems a little problem but it turn put
to be a bigger one
http://www.excelforum.com/attachment...3&d=1135682721

or visit the first page of the thread


--
skarbanan
------------------------------------------------------------------------
skarbanan's Profile:
http://www.excelforum.com/member.php...o&userid=29901
View this thread: http://www.excelforum.com/showthread...hreadid=496084