Hi
I hope someone can help me with an issue I'm having with a spreadsheet I have. In the book, I have a list of sales agents and on a daily basis each sale is recorded against each agent on the list. The information is fairly straight forward in that just the value of the sales is recorded, but there will be multiple entries from each agent over the course of the day. So for example, one agent may have 12 sales recorded.
On sheet1, there is a list of recorded sales for the day (agents name and value of sale) and on sheet2 I would like to have a drop down menu to select each agent in A1, and in B1 record their sales for the day.
Thanks for your help!
Phil
I hope someone can help me with an issue I'm having with a spreadsheet I have. In the book, I have a list of sales agents and on a daily basis each sale is recorded against each agent on the list. The information is fairly straight forward in that just the value of the sales is recorded, but there will be multiple entries from each agent over the course of the day. So for example, one agent may have 12 sales recorded.
On sheet1, there is a list of recorded sales for the day (agents name and value of sale) and on sheet2 I would like to have a drop down menu to select each agent in A1, and in B1 record their sales for the day.
Thanks for your help!
Phil