Hi Everyone, 

This is the leaderboard in our sales office at work. In every Sheet (Month), column BP shows each salesman’s total sales for the month in green. It is custom filtered to order the salesmen from most sales to the least in descending order. Resulting in column BP constantly rearranging; so I am struggling to make the final totals in column BP report on the following months column B titled “Last Month” with the correct corresponding salesman. Does anyone know how I can make each sheets column BP report to column B on the following sheet although they sort every day? 

Thank you for your time. 

​Hi Everyone, This is the leaderboard in our sales office at work. In every Sheet (Month), column BP shows each salesman’s total sales for the month in green. It is custom filtered to order the salesmen from most sales to the least in descending order. Resulting in column BP constantly rearranging; so I am struggling to make the final totals in column BP report on the following months column B titled “Last Month” with the correct corresponding salesman. Does anyone know how I can make each sheets column BP report to column B on the following sheet although they sort every day?  Thank you for your time.    Read More

​