sorting multiple sheets with one button?

S

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Goal Calculation 4
sorting two columns of merged cells 1
Return information in one cell based on search in other sheets 1
a sorting dilemma 2
copy rows to multiple sheets 1
Excel Calendar 1
Merge Multiple workbook sheets into one workbook 0
sort days of week 3

Top