View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default how do I automatically sort a column on entry

Hi, I have a spreadsheet with a number of entries over 25 columns on sheet1
that are totalled in row 30 (cells A30 to Y30). On sheet2 I have a summary
for each category that is linked to the sums on sheet1. I would like the
sheet2 summary to automatically sort every time I update the numbers on
sheet1. Could anyone help please.
Thanks.