sorting multiple sheets with one button?
 

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

sorting multiple sheets with one button?
 

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Skeetra27" wrote in message
...
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