Taking information to another page while sorting.

%3CLINGO-SUB%20id%3D%22lingo-sub-2112206%22%20slang%3D%22en-US%22%3ETaking%20information%20to%20another%20page%20while%20sorting.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112206%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20B%3D%20Names%20(B8%3AB22)%3C%2FP%3E%3CP%3EColumn%20C%20%3DPosition%20(C8%3AC22)%3C%2FP%3E%3CP%3EColumn%20D%20%3D%20Clock%20Number%20(D8%3AD22)%3C%2FP%3E%3CP%3EColumn%20E%20%3D%20Hire%20date%20(E8%3AE22)%3C%2FP%3E%3CP%3EColumn%20F%20%3D%20Machine%20Number%20(F8%3AF22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20take%20this%20table%20on%20a%20sheet%20named%20(EE%20Change)%20to%20another%20sheet%20while%20sorting%20it%20by%20hire%20date%2C%20newest%20to%20oldest%20on%20one%20sheet%20named%20(VLE)%2C%20oldest%20to%20newest%20on%20another%20sheet%20named%20(Send%20Out).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20goal%20is%20so%20supervisors%20can%20go%20to%20one%20sheet%20(EE%20Change)%20and%20change%20employees%20information%20and%20it%20update%20across%20multiple%20other%20sheets.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2112206%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2112631%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20information%20to%20another%20page%20while%20sorting.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F226259%22%20target%3D%22_blank%22%3E%40Matt%20Dymond%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Matt.%20It%20would%20be%20easier%20for%20folks%20here%20in%20%3CU%3Etechcommunity%3C%2FU%3E%20to%20help%20you%20if%20you%20posted%20a%20copy%20(or%20a%20mockup%2C%20something%20without%20real%20names%20of%20real%20people)%20of%20your%20actual%20workbook%20as%20it%20exists%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20absence%20of%20that%2C%20let%20me%20refer%20you%20to%20the%20newly%20released%20%3CSTRONG%3ESORT%3C%2FSTRONG%3E%20function%2C%20which%20should%20be%20able%20to%20take%20your%20basic%20data%20and%20array%20it%20on%20your%20%3CU%3E%3CEM%3EVLE%3C%2FEM%3E%3C%2FU%3E%20sheet%20oldest%20to%20newest%2C%20and%20on%20your%20%3CU%3E%3CEM%3ESendOut%3C%2FEM%3E%3C%2FU%3E%20newest%20to%20oldest.%20Any%20changes%20made%20on%20%3CU%3E%3CEM%3EEE_Change%3C%2FEM%3E%3C%2FU%3E%20would%20automatically%20be%20reflected%20on%20the%20subordinate%20sheets.%20I%20would%20strongly%20recommend%20making%20that%20data%20into%20an%20official%20Excel%20Table%3B%20that%20would%20then%20allow%20new%20names%20to%20be%20added%20to%20the%20list%20(new%20hires).%20If%20you%20wanted%20to%20keep%20a%20history%20of%20all%20employees%20and%20even%20all%20transactions%20(I%20was%20the%20director%20of%20the%20HR%20database%20for%20a%20major%20corporation%20some%2025%20years%20ago%3B%20retired%20now%3B%20but%20I've%20helped%20design%20major%20systems%20to%20track%20EE%20history%20over%20their%20careers)...then%20you'd%20need%20to%20add%20some%20columns%20designating%20not%20only%20hire%20dates%2C%20but%20start%20dates%20for%20positions%2C%20etc.%26nbsp%3B%26nbsp%3B%20But%20all%20of%20that%20could%20be%20handled%20by%20%3CSTRONG%3ESORT%3C%2FSTRONG%3E%20plus%20%3CSTRONG%3EFILTER%3C%2FSTRONG%3E%2C%20the%20latter%20taking%20care%20to%20list%20only%20Current%20employee%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20good%20instructional%20site%3A%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-sort-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-sort-function%3C%2FA%3E%3C%2FP%3E%3CP%3EEven%20better%2C%20here's%20a%20video%20by%20a%20Microsoft%20developer%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Column B= Names (B8:B22)

Column C =Position (C8:C22)

Column D = Clock Number (D8:D22)

Column E = Hire date (E8:E22)

Column F = Machine Number (F8:F22)

 

I want to take this table on a sheet named (EE Change) to another sheet while sorting it by hire date, newest to oldest on one sheet named (VLE), oldest to newest on another sheet named (Send Out). 

 

The goal is so supervisors can go to one sheet (EE Change) and change employees information and it update across multiple other sheets. 

1 Reply

@Matt Dymond 

 

Hi, Matt. It would be easier for folks here in techcommunity to help you if you posted a copy (or a mockup, something without real names of real people) of your actual workbook as it exists now.

 

In the absence of that, let me refer you to the newly released SORT function, which should be able to take your basic data and array it on your VLE sheet oldest to newest, and on your SendOut newest to oldest. Any changes made on EE_Change would automatically be reflected on the subordinate sheets. I would strongly recommend making that data into an official Excel Table; that would then allow new names to be added to the list (new hires). If you wanted to keep a history of all employees and even all transactions (I was the director of the HR database for a major corporation some 25 years ago; retired now; but I've helped design major systems to track EE history over their careers)...then you'd need to add some columns designating not only hire dates, but start dates for positions, etc.   But all of that could be handled by SORT plus FILTER, the latter taking care to list only Current employee data.

 

Here's a good instructional site: https://exceljet.net/excel-functions/excel-sort-function

Even better, here's a video by a Microsoft developer: https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...