A
Alice M.
Example: My workbook has two sheets:
Sheet One: Contains typed employee names in Col A. Col B is a pasted link
from a column in Sheet Two.
Sheet Two: Col A is a mirror of Col A in Sheet One. It contains pasted links
from the names in Sheet One.
In Sheet Two, Cols B-M (labeled Jan-Dec) contain hours worked in each month,
followed by Col N which is the sum of Col B-M.
The sum in Col N in Sheet Two links to Col B of Sheet One.
Here’s the problem:
When I add a name to the list in Sheet One, then sort, the name list in
Sheet Two sorts OK, but the hours do not stay with the original name.
Sheet One: Contains typed employee names in Col A. Col B is a pasted link
from a column in Sheet Two.
Sheet Two: Col A is a mirror of Col A in Sheet One. It contains pasted links
from the names in Sheet One.
In Sheet Two, Cols B-M (labeled Jan-Dec) contain hours worked in each month,
followed by Col N which is the sum of Col B-M.
The sum in Col N in Sheet Two links to Col B of Sheet One.
Here’s the problem:
When I add a name to the list in Sheet One, then sort, the name list in
Sheet Two sorts OK, but the hours do not stay with the original name.