sorting multiple sheets with one button?

[Skeetra27]

Hi, I am using excel 2007 and am wondering if I can sort 7 sheets at the
same time. Worksheets are SUNDAY through SATURDAY with Sunday being the main
sheet. I am using several formulas on all pages that feed off of Sunday's
worksheet. All sheets also have a print title that includes a merged cell
and freeze panes if those make a difference. All information are in cells
Row 4 through Row 61 (Sunday's cells include 1 more column, column E (than
MONDAY through SATURDAY). In all honesty I could move this column if it
would make the sort easier.

I would like to be able to sort by WEEKLY HOURS and have all the information
for every other cell follow on all pages. I can do this manually without
causing issues, but it would be easier if it were a "one button" action.

Also, I don't know lots of details about excel, but can get by with good
direction.

Christine

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.