I have a workbook with two worksheets. In sheet1, column A is a list of files, in a particular order (including gaps between 'groups'). The rest of the columns are details about those files. I'd like to use sheet2 to store a different set of data about the files in column B. Simple linking of cells (eg. putting "=sheet1!A1" into cell A1 of sheet2) displays the list of files on sheet2. However, if I mess with the list on sheet1, I have problems. For example:
- If I insert a row in sheet1, sheet2 doesn't automatically update.
- If I change the order of cells in column A of sheet1, irrespective of whether the order of the cells in column A of sheet2 updates successfully, the cells in column B of sheet2 do not, and I therefore corrupt my data.
I found a similar question (with no answer) here: http://www.ozgrid.com/forum/showthread.php?t=152241

Any help would be most appreciated!