Sorting data on linked workbooks in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3063836%22%20slang%3D%22en-US%22%3ESorting%20data%20on%20linked%20workbooks%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3063836%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20master%20workbook%20that%20tracks%20dates%20for%20other%20employees%20in%20our%20agency.%26nbsp%3BIt%20is%20a%20very%20simple%20excel%20workbook%20with%20separate%20sheets%20where%20we%20have%20one%20sheet%20for%20every%20letter%20of%20the%20alphabet%20and%20have%20each%20client's%20information%20on%20the%20corresponding%20sheet%20with%20the%20first%20letter%20of%20their%20last%20name.%26nbsp%3B%20The%20master%20sheet%20is%20a%20working%20document%20stored%20on%20our%20SharePoint%20site%20that%20other%20managers%20have%20access%20to%20and%20can%20update%20regularly%20as%20tasks%20get%20completed.%20Each%20employee%20has%20a%20separate%20sheet%20that%20is%20significant%20to%20them%2C%20that%20has%20the%20data%20linked%20to%20the%20master%20sheet.%20This%20allows%20a%20manager%20to%20update%20the%20master%20sheet%20and%20the%20other%20workbooks%20are%20updated%20correspondingly.%20This%20works%20great%2C%20however%20we%20have%20to%20constantly%20add%20new%20rows%20due%20to%20the%20change%20with%20our%20client%20base.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%3A%20How%20to%20maintain%20alphabetical%20sorting%20on%20the%20master%20sheet%20when%20we%20add%20a%20new%20client%20(to%20help%20prevent%20any%20duplication)%20and%20still%20keep%20the%20linked%20cells%20in%20the%20employee's%20separate%20workbooks%20linked%20to%20that%20individual's%20data%3F%20Mind%20you%2C%20we%20are%20using%20Microsoft%20365%20and%20all%20items%20have%20to%20be%20accessed%20through%20Excel%20online%20which%20means%20no%20VBA%20or%20macros%20can%20be%20used%20unfortunately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20that%20makes%20sense.%20I%20am%20not%20an%20IT%20person%20by%20any%20means%20but%20really%20love%20to%20play%20around%20with%20different%20programs%20and%20develop%20more%20efficient%20ways%20to%20complete%20tasks%20and%20keep%20everyone%20on%20track.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3063836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am working on a master workbook that tracks dates for other employees in our agency. It is a very simple excel workbook with separate sheets where we have one sheet for every letter of the alphabet and have each client's information on the corresponding sheet with the first letter of their last name.  The master sheet is a working document stored on our SharePoint site that other managers have access to and can update regularly as tasks get completed. Each employee has a separate sheet that is significant to them, that has the data linked to the master sheet. This allows a manager to update the master sheet and the other workbooks are updated correspondingly. This works great, however we have to constantly add new rows due to the change with our client base. 

 

The issue: How to maintain alphabetical sorting on the master sheet when we add a new client (to help prevent any duplication) and still keep the linked cells in the employee's separate workbooks linked to that individual's data? Mind you, we are using Microsoft 365 and all items have to be accessed through Excel online which means no VBA or macros can be used unfortunately.

 

Hopefully that makes sense. I am not an IT person by any means but really love to play around with different programs and develop more efficient ways to complete tasks and keep everyone on track. 

0 Replies