Hi. I am looking for a way to maintain data on multiple sheets if I sort.
For example:
Sheet 1
A B
1 k blue
2 m green
3 c red

Sheet 2 is
A B
1 =sheet1!A1 circle
2 =sheet1!A2 square
3 =sheet1!A3 oval

Every time I sort column A in sheet 1, column A in sheet 2 does as well, but
the sort did not expand to the data in column B sheet 2. Is there a way
around this? Thanks!