sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Guest
I have a workbook with 6 worksheets. I enter employee names and salary on the 6th worksheet(which I keep hidden) and then I have the other 5 worksheets pull the names and salary off of the 6th page in columns A:C. When I add new employees I sort them alphabetically on the 6th page this in return sorts them on all pages. In columns D:J on the other 5 pages(one page per week) I enter the hours they work each day. How can I make sure that when the names are sorted the hours are sorted with it. I'm only sorting on page 6 and on page 6 I don't have the other columns.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

M
  • Question Question
My formula is unnecessarily copied to the adjacent cell when entering data into another cell
Replies
6
Views
202
MrsGrayMarlin
M
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
390
Akuini
Akuini
M
  • Solved
Sort, reference and copy indeterminate cells
Replies
2
Views
135
MissT454
M
K
  • Solved
help with formatting a cell (for TIME, custom format) that retrieves its value from another cell...
Replies
2
Views
346
kbishop94
K
I
  • Solved
Sort column in table when closing workbook
Replies
2
Views
189
ipbr21054
I

Forum statistics

Threads
1,223,406
Messages
6,171,927
Members
452,434
Latest member
NUC_N_FUTS2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top