mrsphxbabe
Board Regular
- Joined
- Aug 11, 2008
- Messages
- 60
Hello, we use quickbooks for our accounting needs. The problem is that quickbooks (qbs) wont allow certain information to be displayed on some reports. We can pull a YTD sales report that shows a comparison from last year, but it will not display who the sales rep is for that company. Is there a formula or macro that can be used so that a column would be added automatically and could add the reps names in that column next to the correct company? Right now I have to run 35 separate reports, 1 report for each sales rep in order to get the sales for each individual rep. We want to run 1 report and have the reps automatically matched to the company name. Below is the example spread sheet, the column that has a header of "rep"is what needs to be added along with the sales rep. is this possible?
<colgroup><col><col><col><col><col span="2"><col><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>
rep | Jan 18 | Jan 17 | $ Change | % Change | Feb 18 | Feb 17 | $ Change | % Change | Mar 18 | Mar 17 | |||
Aaron & Company - Flemington, NJ | sa | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
Ace Plumbing, Heating & Electrical | sa | 0.00 | 1,160.00 | -1,160.00 | -100.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
AF SUPPLY | as | ||||||||||||
Brooklyn, NY - AF Supply | asas | ||||||||||||
Liberty - Hicksville NY - AF | kijmnn | 604.00 | 0.00 | 604.00 | 100.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
Brooklyn, NY - AF Supply - Other | asd | 44.00 | 0.00 | 44.00 | 100.0% | 0.00 | 0.00 | 0.00 | 0.0% | 954.00 | 88.00 | ||
Total Brooklyn, NY - AF Supply | adfaf | 648.00 | 0.00 | 648.00 | 100.0% | 0.00 | 0.00 | 0.00 | 0.0% | 954.00 | 88.00 | ||
New York, NY - AF Supply | adfaf | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
Quality - Harrison, NJ - AF Supply | afda | 0.00 | 844.00 | -844.00 | -100.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
AF SUPPLY - Other | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | |||
Total AF SUPPLY | afdaf | 648.00 | 844.00 | -196.00 | -23.22% | 0.00 | 0.00 | 0.00 | 0.0% | 954.00 | 88.00 | ||
Anew ******* & Bath Design | 573.75 | 0.00 | 573.75 | 100.0% | 78.75 | 0.00 | 78.75 | 100.0% | -157.50 | 0.00 | |||
Atlantic Plumbing | fafaf | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | ||
Bathtique, LTD | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 0.00 | 0.00 | 0.0% | 0.00 | 283.60 |
<colgroup><col><col><col><col><col span="2"><col><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>