Excel: Locking 2 cells together that stay together no matter sort

Charmie91752 

Don't make it more complicated than it needs to be. No need to "lock" cells together. Just create a table, as you've described, Name, Number, Director, Lead, Year  (i.e., no need to limit yourself to two columns)

Then go to Data...Sort

Here, I created this table

Then go to Data...Sort and fill in the resulting dialog box to sort by Name (it'll look like this)

Note, if you want to, you can go back in and sort by any other column, or by a primary and a secondary sort, if, say, you wanted movies by the same director in order by year...

Anyway, that initial table sorted solely by name

I've attached that spreadsheet for you to play with. Just make sure you keep adding rows to the existing table (you can also add columns. DO NOT leave empty rows.