table refresh on any cell edit

%3CLINGO-SUB%20id%3D%22lingo-sub-3072903%22%20slang%3D%22en-US%22%3Etable%20refresh%20on%20any%20cell%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072903%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20in%20Excel%202016%20that%20has%20a%20sort%20function%2C%20when%20I%20add%20to%20that%20sheet%20I%20want%20the%20data%20automatically%20sorted%2C%20like%20when%20I%20press%20F9.%26nbsp%3B%20Anybody%20have%20any%20idea%20how%20or%20if%20this%20can%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I have a sheet in Excel 2016 that has a sort function, when I add to that sheet I want the data automatically sorted, like when I press F9.  Anybody have any idea how or if this can be done?

0 Replies