I have an excel document with multiple tabs. I've set the sheets up to pre-populate names based on what I enter in Sheet 1 but sheet 2 has added columns with information not found on Sheet 1. If I sort Sheet 1 alphabetically, sheet 2 will also sort but the remaining cell values do not sort with it. Is there a way to set sheet 2 up to have the rows move together when sorting?
Solved by X. D. in 22 mins