Sorting in multiple worksheets

G

GWVF

I'm having a few issues sorting rows in multiple worksheets. I have 6
worksheets with Names in one column and employee numbers in another. I have
these linked throughout all six worksheets. When I sort the rows in my
worksheet A it sorts the linked cells brillantly throughout the rest of the
worksheets. However, I have data in the worksheets B-E that relates to the
specific employees name in the row. When I sort the related data does not
stay with the specific employee's row in worksheets B-E. Any ideas?
 
G

Gord Dibben

If you select all columns before doing the sort, all data will stay
together.

But since you have some columns linked in sheets B-E and some not linked,
the not-linked cells will not sort when you sort sheet A.

Only the linked cells will follow sheet A's sort.


Gord Dibben MS Excel MVP
 

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

Linked cells between worksheets and sorting 2
Is not sorting 4
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Need to merge worksheets - Excel 2003 0
Linking worksheets, rearranging rows. 1
Require formula to search across multiple worksheets 2
Combining data from multiple worksheets into one 4
Referencing cells in multiple worksheets 3

Top