SpencerRichman
New Member
- Joined
- Feb 15, 2013
- Messages
- 33
- Office Version
- 2021
- Platform
- Windows
I have an employee tracking workbook with two worksheets. The first worksheet is called “Staff” contains employee information like this:
And then the second worksheet, called “Staff Reviews” is used to track regular reviews and looks like this:
In the second worksheet, column A’s formula is simply “=Staff!A3”, then A4, A5, etc.
Column B uses Index, Match to populate the start date.
But the rest of the columns in the Staff Reviews worksheet is comprised of data (i.e. columns E & I) that I manually input and formulas (i.e. columns D & H) based on column B’s date.
My QUESTION is this… when we add new employees we generally just add their data to the bottom blank row in the Staff worksheet. But then once in a while when we’ve added quite a few employees we use the Data->Sort function on the Staff worksheet to reorder them all in alphabetical order. On the Staff Review page, this changes the order of the data in columns A and B … but then the data in columns D through I are no longer paired with the correct employee name because that data does not get reordered to ‘stay’ with the right employee. How can I get the rest of the data in the Staff Review worksheet to move with their respective employee names when the employee names move due to the data sort on the Staff worksheet?
And then the second worksheet, called “Staff Reviews” is used to track regular reviews and looks like this:
In the second worksheet, column A’s formula is simply “=Staff!A3”, then A4, A5, etc.
Column B uses Index, Match to populate the start date.
But the rest of the columns in the Staff Reviews worksheet is comprised of data (i.e. columns E & I) that I manually input and formulas (i.e. columns D & H) based on column B’s date.
My QUESTION is this… when we add new employees we generally just add their data to the bottom blank row in the Staff worksheet. But then once in a while when we’ve added quite a few employees we use the Data->Sort function on the Staff worksheet to reorder them all in alphabetical order. On the Staff Review page, this changes the order of the data in columns A and B … but then the data in columns D through I are no longer paired with the correct employee name because that data does not get reordered to ‘stay’ with the right employee. How can I get the rest of the data in the Staff Review worksheet to move with their respective employee names when the employee names move due to the data sort on the Staff worksheet?
