Hello All,

Is there a way to link rows between sheets when sorting?

For example, I have a database in which the first several columns in a set of rows from sheet two reference the first several columns in a corresponding set of rows from sheet one. The remaining columns on sheet two are used to input new data, but it is important that each row stay connected.

Is there a way to program the database such that if the selection of rows in sheet one is sorted that the selection of corresponding rows in sheet two (the entire rows, not just the first several columns) will automatically sort in the same way?

Thanks ahead of time for any responses.