Help on Formula/Macro for perentage ratio and charts reports

[mobilesuit818]

Hello, Excel 2000 and WinXP is my current setup.

I am need a Macro/Formula to help make a report on a spreadsheet that had important data in Columns L (which is named Sales rep, sorted by ascending) and column O ( Open, closed, dead, quoted).
The end result is that I need to show percentage for each sales rep of quoted/closed, quoted/dead, quoted/hold, quoted/quoted.

Can anyone help me out with this Macro or formula?

 

[macajm]

This is a prime case for a Pivot Table.
When creating the Pivot table (see Excel Help if necessary), make sure that the option to Grand Total for Rows is ticked, Use the "Salesman" field (ie column L) as the Row, the "Status" field (ie this is what I have called your column O), and select "Count of Status" as the Data.
Then right click the Data and under Field Settings|Options choose "Show Data as % of Row".
You can format the % number under Field Settings|Number for "Count of Status"

Hope this helps