Hi. I'm trying to link between two sheets. There are filters on both sheets.
Sheet1 A1 has the data: Cheetah
Sheet2 A1 is linked to Sheet1 A1 using the formula 'Sheet1'!A1
This works well until I use the filter to sort Sheet1. Then, the value on Sheet2 A1 now shows the data on Sheet1 A1...