Is it possible to maintain a cell reference when you format the relevant cells in a table, and then sort the contents from smallest to largest? In this case, devices eg. cell A1 (Sheet No. 1): "example 1". Cell A1 in (sheet No. 2) to reproduce exactly the same as A1 (Sheet No. 1), and I therefore use the following formula: = 'Sheet1'! A1. How will the subsequent cells also reproduced in (A2, A3, A4 ... etc). When I format the table and sort cell contents from smallest to largest, change the cell reference itself. Is it possible to maintain this reference, despite the sort? Have tried absolute cell reference with no luck..
Bookmarks