Automatic Data Sort?

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'm something of an amateur with Excel, using Excel 2000.
I have a workbook with several sheets, and a master sheet
which calculates data from the other sheets. Is there a
way to automatically *sort* the new data (like everytime
the file is closed or opened for example) so that the new
data placed in the "other" worksheets is displayed on the
master in a newly sorted order, or do I have to manually
sort the master everytime I change the data in the other
sheets?
 
When you are manually sorting, just go to tools|macro|Record new macro, give
it a name then sort your data the way you want it, after you're done click
the stop recording button. Right click on your sheet tab, click view code,
select workbook from the left hand side, then workbook from the right hand
side left drop down, then open or beforeclose, then where the cursor is type
the name of the macro you just named and recorded. Then save, now
depending on where you put the macro name it will run your sort macro when
you open the workbook or before it closes.

HTH
 
Back
Top