ExcelBanter - Update data linked between worksheets when resorting data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Update data linked between worksheets when resorting data (https://www.excelbanter.com/excel-discussion-misc-queries/150330-update-data-linked-between-worksheets-when-resorting-data.html)

JayStar

Update data linked between worksheets when resorting data

I refer to certain cells in a different worksheet (same workbook). When
resorting the main worksheet, the data does not update in the associated
worksheet. It always used to in previous Excel versions. What do I need to
do?
--
JayStar
England

All times are GMT +1. The time now is 11:47 AM.