Adding sales of a particular date

QuestionEdit

QUESTION: Kindly help me with the following. I want to have the sales proceed(product 1) of my sales exec ranjeet of the date 1-08-2010 in another sheet. The sheet 2 should be in auto mode so that i can select a particular date and the sales rep to get his sales figure of that day. Is this possible? if yes please help

Date Sales Exec Name Product 1 01-08-2010 Ranjit 50 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 48 01-08-2010 Ranjit 12 01-08-2010 Ranjit 20 01-08-2010 Ranjit 20 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0

ANSWER: I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file.

http://www.sendspace.com/file/n4g4u3

Scroll the mouse button to the bottom of the website and click Download

The File Name is: Sumproduct Solution (30-07-2010).xls

---------- FOLLOW-UP ----------

QUESTION: Thank you very much. But the answer is not exactly as i desired. I am attaching the actual file that i need the work on. Please check it.

What i need is mentioned in thefile

http://www.sendspace.com/file/vfqk1g

and yes ANSWER: I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file.

http://www.sendspace.com/file/8bgiaj

Scroll the mouse button to the bottom of the website and click Download

The File Name is: Solution - Cash Memo audit DSR_test.xlsx

---------- FOLLOW-UP ----------

QUESTION: thank you first of all and you have been a great help. One last solution to this and i think i will be all set. Once again The link contains thefile and the question i am asking

http://www.sendspace.com/file/1jswtg

AnswerEdit

I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file.

http://www.sendspace.com/file/r3a0rl

Scroll the mouse button to the bottom of the website and click Download

The File Name is: Solution - percentage.xlsx

Note: The Discount Column should be formatted as Percentage. Format Cells>>Number>>Category>>Percentage