How to enter sales goal figures for individual salespeople
Hey everyone -
I have a question regarding sales goal figures. I have a set of data with individual sales listed on it, with the date of the invoice, salesperson, sale total, and other data detailing each unique sale. On a separate spreadsheet, I have each sales goal for each person, for the year, and also for each month. How would I go about combining these two sets of data so that I can use graphs that show both the sales goal, and then the monthly/yearly progress? The sales sheet updates automatically, but the sales goals sheet will stay the same throughout the year.
Thank you for any help, it's much appreciated!