keep rows together

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi I am working on a large spreadsheet of customers with sales figures
etc.

Several customers have several records due to change of names of companies,
mergers etc.

Is there a way of keeping them together in a sort or filter etc.
Thanks tim
 
Select the header row, go to DATA > FILTER. And select AutoFilter.

Alternatively, you could write a macro to auto-sort your table on open or
close event.

Mangesh
 
Back
Top