Example : I have a monthly sales goal of 12,000 which I track in excel. Everytime I have a sale I input it into my tracker which shoots out TOTAL sales for that month, and my % to goal. I would like an auto updating cell which pulls from my daily sales cells and gives me how much $ in sales I need per workday to be "on track" for the month. I envision a cell for each workday in the current month. If the sales do not reach the amount needed to be on track for the month it will increase the amounts in all remaining days to be able to meet goal. If i surpass daily goal it will decrease all further daily amounts needed for that month. I would very much appreciate any help from those far more knowledgeable than I with this programSales 2014.xls
Bookmarks