Forum Discussion
Tables, Multiple Tabs and Sorting
If this is has already been discussed please point me to it but I have been trying to locate the answer for about 3 hours now. I have a workbook that we use for keeping stats. My first Tab is called MasterList. This has a table called MasterList that contains four rows with the following Headers A1=Position, B1=Shift, C1=EMP#, D1=DRN, E1=LastName. This sheet represents our employees. EMP# will never be reused unless an employee comes back however the DRN would change as it is Designated Radio Number. I then have 12 tabs Jan-Feb. Each tab has a table Jan=Jan Feb=Feb, Mar etc.... In each table there are 13 columns. The A-E columns the Jan-Dec are linked to the MasterList A-E. If a new employee is added then they are added in all tables Jan-Dec. The stats for each month for each employee are then entered in columns F-M. However if the MasterList is resorted then A-E changes appropriately on tabs Jan-Dec. The problem is columns F-M in the Jan-Dec tabs do not change when sorting by one of the first 5. So if Campbell had 50 tickets in Jan but it gets sorted by LastName now Acox has 50 tickets. I am rather new and about to pull my hair out. Any help is greatly appreciated. I always want the data when entered to stay with the employee number regardless of the sort or filter. Workbook attached.
Thank you
2 Replies
Make sure the employee numbers on the month sheets are inputs, not formulas. Then use the XLOOKUP function to retrieve the other information of an employee in the other A-E columns. Now if you sort the master list, the month sheets are unaffected. You do have to manually add a new employee to all month sheets this way however.
Thank you for responding but that does not solve my problem. I will presume there is no way to keep all the rows synced while using the master list to keep employee updated in each month. The goal is to add employees in the master sheet so that all months are updated with the correct employee and then ensure that each row in reach month stays connected or synced to the employee when the data for each month is entered.
