Hello,
I've created an example that illustrates what I'm working because the work is private. So in the example, relative to the actual work, there is an ID number that is related to a Name. And when I receive the excel files, the order of the names need to be adjusted. So in the example, the order of names have to be adjusted such that it matches the correct order. I want the order of names to match the correct order and ID to move with the Name as I adjust. I can't simply use Cut and Insert Cut, because in actuality the volume is much bigger so it would be slow and tiring. Is there a way to use formulas or something in Excel that links the 2 cells Name and ID, such that when I order Name to match the correct order the ID will also move? And is there a way to sort the order of Name to automatically match the Correct Order?
Thank you
I've created an example that illustrates what I'm working because the work is private. So in the example, relative to the actual work, there is an ID number that is related to a Name. And when I receive the excel files, the order of the names need to be adjusted. So in the example, the order of names have to be adjusted such that it matches the correct order. I want the order of names to match the correct order and ID to move with the Name as I adjust. I can't simply use Cut and Insert Cut, because in actuality the volume is much bigger so it would be slow and tiring. Is there a way to use formulas or something in Excel that links the 2 cells Name and ID, such that when I order Name to match the correct order the ID will also move? And is there a way to sort the order of Name to automatically match the Correct Order?
Thank you