keep rows together

[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

 

[Don Guillett]

You might assign each an ID num.

 

[Mangesh Yadav]

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