View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tommy[_2_] Tommy[_2_] is offline
external usenet poster
 
Posts: 5
Default Data sorting automatically?

Every day I have to input the number of meal types served in a restaurant.
This is to keep a list of the best and worse sellers.
For example:
Roast beef 12
Roast Lamb 9
Steak 8
Ham Salad 2

There is a total of 57 meals on the menu and each days count is added to the
previous days total.
Two columns are used A is Meal name and B is total sold.
I have to highlight the two columns then select 'Data' then 'Sort' everytime
I want to show the latest best sellers.
Is there a way to get the two columns to sort automatically, as the data is
inputted.

Thanks